Schema Version: 1.3

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('chado.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.

Show relationships within degrees of separation