Table cxgn.sgn.linkage_group

Generated by
SchemaSpy

Legend:

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

√

nextval('linkage_group_lg_id_seq'::regclass)

marker_location.lg_id

marker_location_lg_id_fkey

map_version_id

int4

√

null

map_version.map_version_id

linkage_group_map_version_id_fkey

lg_order

int4

lg_name

text

2147483647

√

null

north_location_id

int4

√

null

marker_location.location_id

linkage_group_north_location_id_fkey

south_location_id

int4

√

null

marker_location.location_id

linkage_group_south_location_id_fkey

Table contained 407 rows at Wed May 20 01:50 EDT 2009

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
lg_name	Performance	Asc	sgn_linkage_group_name_idx