cxgn_breedbase
.sgn
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
deprecated_mapdata
0
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
loc_id
serial
10
√
nextval('sgn.deprecated_mapdata_loc_id_seq'::regclass)
deprecated_marker_locations
.loc_id
loc_id_fk
C
map_id
int8
19
(0)::bigint
deprecated_maps
.map_id
map_id_fk
R
lg_id
int8
19
√
null
deprecated_linkage_groups
.lg_id
lg_id_fk
R
offset
numeric
8,5
√
null
loc_type
int8
19
(0)::bigint
loc_order
int8
19
(0)::bigint
Showing 1 to 6 of 6 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
mapdata_pkey
Primary key
Asc
loc_id
map_id_idx2
Performance
Asc
/
Asc
map_id + lg_id
Showing 1 to 2 of 2 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees