Table cxgn.sgn.deprecated_mapdata

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
loc_id serial 10  √  nextval('deprecated_mapdata_loc_id_seq'::regclass)
deprecated_marker_locations.loc_id loc_id_fk
map_id int8 19 (0)::bigint
deprecated_maps.map_id map_id_fk
lg_id int8 19  √  null
deprecated_linkage_groups.lg_id lg_id_fk
offset numeric 8,5  √  null
loc_type int8 19 (0)::bigint
loc_order int8 19 (0)::bigint

Table contained 7,750 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
loc_id Primary key Asc mapdata_pkey
map_id + lg_id Performance Asc/Asc map_id_idx2

Close relationships  within one two degrees of separation :