feature_dbxref

0 rows


Description

links a feature to dbxrefs. This is for secondary identifiers; primary identifiers should use feature.dbxref_id

Columns

Column Type Size Nulls Auto Default Children Parents Comments
feature_dbxref_id serial 10 nextval('feature_dbxref_feature_dbxref_id_seq'::regclass)
feature_id int4 10 null
feature.feature_id feature_dbxref_feature_id_fkey C
dbxref_id int4 10 null
dbxref.dbxref_id feature_dbxref_dbxref_id_fkey C
is_current bool 1 true

the is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked feature

Indexes

Constraint Name Type Sort Column(s)
feature_dbxref_pkey Primary key Asc feature_dbxref_id
feature_dbxref_c1 Must be unique Asc/Asc feature_id + dbxref_id
feature_dbxref_idx1 Performance Asc feature_id
feature_dbxref_idx2 Performance Asc dbxref_id

Relationships