annotation_sequence


Description

The table holds sequences related to the specific annotation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
annotation_id int4 10 null
annotation.annotation_id annotation_sequence_annotation_id_fkeyR
sequence_id int4 10 null
sequence.sequence_id annotation_sequence_sequence_id_fkeyR
product varchar 2147483647 null
aminoacid_sequence varchar 2147483647 null
annotation_nucleotide_sequence varchar 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
annotation_sequence_pkey Primary key Asc annotation_id
ann_seq__seq_id__product Must be unique Asc/Asc sequence_id + product

Relationships