Table cxgn.sgn_bt.qc_report

 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
qc_id serial 10  √  nextval('qc_report_qc_id_seq'::regclass)
est_id int4 10 0
est.est_id est_id_fk
basecaller varchar 40  √  null
qc_status int8 19  √  null
vs_status int8 19  √  null
qstart int8 19  √  null
qend int8 19  √  null
istart int8 19  √  null
iend int8 19  √  null
hqi_start int8 19  √  null
hqi_length int8 19  √  null
entropy float4 8,8  √  null
expected_error float4 8,8  √  null
quality_trim_threshold float4 8,8  √  null
vector_tokens text 2147483647  √  null
cxgn_production_visible bool 1  √  false

Table contained 623,922 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
qc_id Primary key Asc qc_report_pkey
est_id + hqi_start + hqi_length Performance Asc/Asc/Asc est_id_2_idx
est_id Must be unique Asc qc_report_est_id_key

Close relationships  within one two degrees of separation :