Table cxgn.public.dbxrefA unique, global, public, stable identifier. Not necessarily an eXternal reference - can reference data items inside the particular chado instance being used. Typically a row in a table can be uniquely identified with a primary identifier (called dbxref_id); a table may also have secondary identifiers (in a linking table <T>_dbxref). A dbxref is generally written as <DB>:<ACCESSION> or as <DB>:<ACCESSION>:<VERSION>.
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| dbxref_id | Primary key | Asc | dbxref_pkey |
| db_id + accession + version | Must be unique | Asc/Asc/Asc | dbxref_c1 |
| db_id | Performance | Asc | dbxref_idx1 |
| accession | Performance | Asc | dbxref_idx2 |
| version | Performance | Asc | dbxref_idx3 |
|
