NOTE: We are working on migrating this site away from MediaWiki, so editing pages will be disabled for now.
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 The local part of the identifier. Guaranteed by the db authority to be unique for that db. | |
version | character varying(255) | UNIQUE#1
NOT NULL DEFAULT ''::character varying
| |
description | text |
Tables referencing dbxref via foreign key constraints:
- None.