marker_location

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Check Constraints

Search:

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

Showing 1 to 1 of 1 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation