marker_location

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
location_id serial 10 √ nextval('sgn.marker_location_location_id_seq'::regclass)
linkage_group.north_location_id linkage_group_north_location_id_fkey R
linkage_group.south_location_id linkage_group_south_location_id_fkey R
marker_experiment.location_id marker_experiment_location_id_fkey C
marker_to_map.location_id Implied Constraint R
lg_id int4 10 null
linkage_group.lg_id marker_location_lg_id_fkey C
map_version_id int4 10 null
map_version.map_version_id marker_location_map_version_id_fkey C
position numeric 9,6 null
confidence_id int4 10 null
marker_confidence.confidence_id marker_location_confidence_id_fkey R
subscript bpchar 1 √ null
position_north numeric 8,5 √ null
position_south numeric 8,5 √ null

Indexes

Constraint Name Type Sort Column(s)
marker_location_pkey Primary key Asc location_id

Check Constraints

Constraint Name Constraint
marker_location_subscript_check (((subscript = 'A'::bpchar) OR (subscript = 'B'::bpchar) OR (subscript = 'C'::bpchar) OR (subscript IS NULL)))

Relationships

Close relationships within degrees of separation