Table cxgn.sgn_bt.linkage_group

 Generated by
SchemaSpy
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
lg_id serial 10  √  nextval('linkage_group_lg_id_seq'::regclass)
marker_location.lg_id marker_location_lg_id_fkey
map_version_id int4 10  √  null
map_version.map_version_id linkage_group_map_version_id_fkey
lg_order int4 10
lg_name text 2147483647  √  null
cxgn_production_visible bool 1  √  false
north_location_id int4 10  √  null
marker_location.location_id linkage_group_north_location_id_fkey
south_location_id int4 10  √  null
marker_location.location_id linkage_group_south_location_id_fkey

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
lg_id Primary key Asc linkage_group_pkey  
map_version_id + lg_order Must be unique Asc/Asc linkage_group_map_version_id_key  
map_version_id + lg_name Must be unique Asc/Asc linkage_group_map_version_id_key1 These unique columns are also nullable

Close relationships  within one two degrees of separation :