Table cxgn.sgn_bt.deprecated_marker_confidences

Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
confidence_id serial 10  √  nextval('deprecated_marker_confidences_confidence_id_seq'::regclass)
map_version.default_threshold map_version_default_threshold_fkey
marker_confidence.confidence_id Implied Constraint
confidence_name varchar 16  √  null
legacy_conf_id int8 19  √  null
deprecated_marker_locations.confidence confidence_fk
cxgn_production_visible bool 1  √  false

Table contained 5 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name Anomalies
confidence_id Primary key Asc marker_confidences_pkey  
confidence_name + legacy_conf_id Performance Asc/Asc confidence_name_idx  
legacy_conf_id Must be unique Asc legacy_conf_id_unique This unique column is also nullable

Close relationships  within one two degrees of separation :