Table cxgn.sgn.blast_annotations

 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
blast_annotation_id serial 10  √  nextval('blast_annotations_blast_annotation_id_seq'::regclass)
blast_hits.blast_annotation_id blast_hits_blast_annotation_id_fkey
apply_id int4 10  √  null
unigene.unigene_id apply_id_fkey
apply_type int4 10  √  null
blast_target_id int4 10  √  null
n_hits int4 10  √  null
hits_stored int4 10  √  null
last_updated int4 10  √  null
host varchar 20  √  null
pid int4 10  √  null

Table contained 956,930 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name Anomalies
blast_annotation_id Primary key Asc blast_annotations_pkey  
apply_id Performance Asc apply_id_idx  
apply_id + blast_target_id Must be unique Asc/Asc blast_annotations_apply_id_blast_target_id_uq These unique columns are also nullable

Close relationships  within one two degrees of separation :