Table cxgn.sgn.est

 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
est_id serial 10  √  nextval('est_est_id_seq'::regclass)
est_dbxref.est_id est_dbxref_est_id_fkey
qc_report.est_id est_id_fk
unigene_member.est_id est_id_fkey
read_id int4 10  √  null
seqread.read_id read_id_fkey
version int4 10  √  null
basecaller varchar 40  √  null
seq text 2147483647  √  null
qscore text 2147483647  √  null
call_positions text 2147483647  √  null
status int4 10  √  null
flags int8 19  √  null
date date 13  √  null
genbank_submission_date date 13  √  null
genbank_confirmed bool 1  √  null

Table contained 1,197,154 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
est_id Primary key Asc est_pkey
flags + status Performance Asc/Asc flags_2_idx
flags Performance Asc flags_idx
read_id Performance Asc read_id_idx
status + flags + est_id Performance Asc/Asc/Asc rsi_idx
status Performance Asc status_idx

Close relationships  within one two degrees of separation :