Table cxgn.sgn_bt.deprecated_maps

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
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
map_id serial 10  √  nextval('deprecated_maps_map_id_seq'::regclass)
deprecated_linkage_groups.map_id map_id_fk
deprecated_map_cross.map_id map_id_fk
deprecated_mapdata.map_id map_id_fk
fish_result.map_id map_id_fkey
map.map_id Implied Constraint
temp_map_correspondence.old_map_id temp_map_correspondence_old_map_id_fkey
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
abstract text 2147483647
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
cxgn_production_visible bool 1  √  false

Table contained 12 rows at Thu Jun 21 23:03 EDT 2007

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

Close relationships  within one two degrees of separation :