Template:ChadoTable dbxref
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
Table: | dbxref |
Module: | General |
A 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>.
FK | Name | Type | Description |
---|---|---|---|
dbxref_id | serial | PRIMARY KEY | |
db | db_id | integer | UNIQUE#1 NOT NULL |
accession | character varying(255) | UNIQUE#1 NOT NULL | |
version | character varying(255) | UNIQUE#1 NOT NULL | |
description | text |
Tables referencing dbxref via foreign key constraints:
- arraydesign
- assay
- biomaterial
- biomaterial_dbxref
- cell_line_dbxref
- cvterm
- cvterm_dbxref
- dbxrefprop
- element
- feature
- feature_cvterm_dbxref
- feature_dbxref
- library_dbxref
- nd_experiment_dbxref
- nd_experiment_stock_dbxref
- organism_dbxref
- phylonode_dbxref
- phylotree
- protocol
- pub_dbxref
- stock
- stock_dbxref
- study