Table cxgn.sgn.unigene_member

 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
unigene_member_id serial 10  √  nextval('unigene_member_unigene_member_id_seq'::regclass)
unigene_id int4 10 0
unigene.unigene_id unigene_member_unigene_id_fkey
est_id int4 10  √  null
est.est_id est_id_fkey
start int8 19  √  null
stop int8 19  √  null
qstart int8 19  √  null
qend int8 19  √  null
dir bpchar 1  √  null

Table contained 2,564,656 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
unigene_member_id Primary key Asc unigene_member_pkey
est_id Performance Asc est_id_idx2
unigene_id + est_id Performance Asc/Asc unigene_id_2_idx
unigene_id Performance Asc unigene_id_idx3

Close relationships  within one two degrees of separation :