Table cxgn.sgn_bt.seqread

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
read_id serial 10  √  nextval('seqread_read_id_seq'::regclass)
est.read_id read_id_fkey
clone_id int4 10  √  null
clone.clone_id clone_id_fk
facility_id int4 10  √  null
facility.facility_id facility_id_fk
submitter_id int4 10  √  null
batch_id int4 10  √  null
primer varchar 50  √  null
direction bpchar 1  √  null
trace_name varchar 50
trace_location text 2147483647
attribution_id int4 10  √  null
date timestamp 29,6 ('now'::text)::timestamp(6) with time zone
censor_id int4 10  √  null
cxgn_production_visible bool 1  √  false

Table contained 667,385 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
read_id Primary key Asc seqread_pkey
clone_id Performance Asc clone_id_idx2
trace_name Performance Asc trace_name_idx

Close relationships  within one two degrees of separation :