Table cxgn.genomic_bt.chromat

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
chromat_id bigserial 19  √  nextval('chromat_chromat_id_seq'::regclass)
gss.chromat_id gss_chromat_id_fkey
clone_id int8 19  √  null
clone.clone_id chromat_clone_id_fkey
primer varchar 50  √  null
direction bpchar 1  √  null
filename varchar 50 ''::character varying
subpath text 2147483647
date timestamp 29,6 ('now'::text)::timestamp(6) with time zone
censor_id int4 10  √  null
read_class_id int8 19  √  null
cxgn_production_visible bool 1  √  false

Table contained 401,652 rows at Thu Jun 21 23:00 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
chromat_id Primary key Asc chromat_pkey
clone_id Performance Asc clone_id_idx
filename Performance Asc filename_idx

Close relationships  within one two degrees of separation :