Table cxgn.genomic_bt.clone

 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
clone_id serial 4  √  nextval('genomic_bt.clone_clone_id_seq'::text)
chromat.clone_id chromat_clone_id_fkey
library_id int8 8  √  null
library.library_id clone_library_id_fkey
clone_type_id int2 2 (0)::smallint
clone_type.clone_type_id clone_clone_type_id_fkey
platenum int4 4  √  null
wellrow bpchar 2  √  null
wellcol int2 2  √  null
genbank_accession varchar 32  √  null
bad_clone varchar 32  √  null
estimated_length int8 8  √  null
cxgn_production_visible bool 1  √  false

Table contained 235,776 rows at Wed Sep 13 17:06 EDT 2006

Indexes:
Column(s) Type Sort Constraint Name
clone_id Primary key Asc clone_pkey
platenum + wellrow + wellcol + clone_type_id Performance Asc/Asc/Asc/Asc byname_idx
clone_type_id Performance Asc clone_type_id_idx
library_id Performance Asc library_id_idx

Close relationships  within one two degrees of separation :