annotation

286600 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
annotation_num serial 10 √ nextval('annotation_annotation_num_seq'::regclass)
action_annotation.annotation_num fk_action_annotation_annotation_numR
feature_of_interest_annotation.annotation_num fk_feature_of_interest_annotation_annotation_numR
result_annotation.annotation_num fk_result_annotation_annotation_numR
sampling_feature_annotation.annotation_num fk_sampling_feature_annotation_annotation_numR
annotation_type_num int4 10 null
annotation_type.annotation_type_num fk_annotation_annotation_type_numR
annotation_text varchar 2000 null
data_source_num int4 10 null
citation.citation_num fk_annotation_data_source_numR
annotation_entered_time timestamp 29,6 null
annotation_link varchar 256 √ null
annotation_code varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
annotation_pkey Primary key Asc annotation_num
uc_annotation_type_num_text_source_num_idx Must be unique Asc/Asc/Asc annotation_type_num + annotation_text + data_source_num

Relationships

Close relationships within degrees of separation