deprecated_maps

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

map_id

serial

10

√

nextval('sgn.deprecated_maps_map_id_seq'::regclass)

deprecated_linkage_groups.map_id	map_id_fk	R
deprecated_map_cross.map_id	map_id_fk	R
deprecated_mapdata.map_id	map_id_fk	R
fish_result.map_id	map_id_fkey	R
temp_map_correspondence.old_map_id	temp_map_correspondence_old_map_id_fkey	R

legacy_id

int8

19

(0)::bigint

short_name

varchar

50

''::character varying

long_name

varchar

250

''::character varying

number_chromosomes

int8

19

(0)::bigint

default_threshold

int8

19

(0)::bigint

text

2147483647

null

abstract

text

2147483647

null

genetic_cross

varchar

250

√

null

population_type

varchar

250

√

null

Showing 1 to 10 of 15 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
maps_pkey	Primary key	Asc	map_id
legacy_id_idx	Performance	Asc	legacy_id

Showing 1 to 2 of 2 entries

Check Constraints

Search:

Constraint Name	Constraint
maps_map_type_check	((((map_type)::text = 'genetic'::text) OR ((map_type)::text = 'fish'::text)))

Showing 1 to 1 of 1 entries

Columns

Indexes

Check Constraints

Relationships

Close relationships within degrees of separation