Schema Version: 1.3 Module: chado

feature_dbxref


Description

Links a feature to dbxrefs.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_dbxref_id bigserial 19
nextval('sequence.feature_dbxref_feature_dbxref_id_seq'::regclass)
feature_id int8 19
feature.feature_id feature_dbxref_feature_id_fkey C
null
dbxref_id int8 19
dbxref.dbxref_id feature_dbxref_dbxref_id_fkey C
null
is_current bool 1
true

True if this secondary dbxref is the most up to date accession in the corresponding db. Retired accessions should set this field to false

Table contained -1 rows

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

The following entity relationship (ER) diagram shows the relationships involving the feature_dbxref table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation