Table cxgn.genomic.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 10  √  nextval('clone_clone_id_seq'::regclass)
chromat.clone_id chromat_clone_id_fkey
library_id int8 19  √  null
library.library_id clone_library_id_fkey
clone_type_id int2 5 (0)::smallint
clone_type.clone_type_id clone_clone_type_id_fkey
platenum int4 10  √  null
wellrow varchar 2  √  null
wellcol int2 5  √  null
genbank_accession varchar 32  √  null
bad_clone varchar 32  √  null
estimated_length int8 19  √  null

Table contained 473,472 rows at Wed May 20 01:31 EDT 2009

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 :