Schema Version: 1.3 Module: chado

dbxref


Description

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 _dbxref). A dbxref is generally written as : or as ::.

Columns

Column Type Size Foreign Key Nullable Default Comments
dbxref_id bigserial 19
nextval('db.dbxref_dbxref_id_seq'::regclass)
db_id int8 19
db.db_id dbxref_db_id_fkey C
null
accession varchar 1024
null

The local part of the identifier. Guaranteed by the db authority to be unique for that db.
version varchar 255
''::character varying
description text 2147483647
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
dbxref_pkey Primary key Asc dbxref_id
dbxref_c1 Must be unique Asc/Asc/Asc db_id + accession + version
dbxref_idx1 Performance Asc db_id
dbxref_idx2 Performance Asc accession
dbxref_idx3 Performance Asc version

Relationships

The following entity relationship (ER) diagram shows the relationships involving the 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