Table cxgn.public.dbxref

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>.

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
dbxref_id serial 10  √  nextval('dbxref_dbxref_id_seq'::regclass)
cvterm.dbxref_id cvterm_dbxref_id_fkey
cvterm_dbxref.dbxref_id cvterm_dbxref_dbxref_id_fkey
dbxrefprop.dbxref_id dbxrefprop_dbxref_id_fkey
feature.dbxref_id feature_dbxref_id_fkey
feature_cvterm_dbxref.dbxref_id feature_cvterm_dbxref_dbxref_id_fkey
feature_dbxref.dbxref_id feature_dbxref_dbxref_id_fkey
organism_dbxref.dbxref_id organism_dbxref_dbxref_id_fkey
pub_dbxref.dbxref_id pub_dbxref_dbxref_id_fkey
unigene_dbxref.dbxref_id unigene_dbxref_dbxref_id_fkey
db_id int4 10
db.db_id dbxref_db_id_fkey
accession varchar 255 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 412,586 rows at Fri Oct 10 01:31 EDT 2008

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

Close relationships  within one two degrees of separation :