deprecated_maps

0 rows


Columns

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
header text 2147483647 null
abstract text 2147483647 null
genetic_cross varchar 250 √ null
population_type varchar 250 √ null
population_size int8 19 √ null
seed_available int8 19 √ null
seed_url varchar 250 √ null
deprecated_by int8 19 √ (0)::bigint
map_type varchar 7 √ null

Indexes

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

Check Constraints

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

Relationships

Close relationships within degrees of separation