blast_annotations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
blast_annotation_id serial 10 √ nextval('sgn.blast_annotations_blast_annotation_id_seq'::regclass)
blast_hits.blast_annotation_id blast_hits_blast_annotation_id_fkey C
apply_id int4 10 √ null
unigene.unigene_id apply_id_fkey R
apply_type int4 10 √ null
blast_target_id int4 10 √ null
blast_targets.blast_target_id Implied Constraint R
n_hits int4 10 √ null
hits_stored int4 10 √ null
last_updated int4 10 √ null
host varchar 20 √ null
pid int4 10 √ null
p_markers.pid Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
blast_annotations_pkey Primary key Asc blast_annotation_id
apply_id_idx Performance Asc apply_id
blast_annotations_apply_id_blast_target_id_uq Must be unique Asc/Asc apply_id + blast_target_id

Relationships

Close relationships within degrees of separation