dbxref

60763 rows


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 Nulls Auto Default Children Parents Comments
dbxref_id serial 10 √ nextval('dbxref_dbxref_id_seq'::regclass)
bs_protocol_step_dbxref.dbxref_id bs_protocol_step_dbxref_dbxref_id_fkey R
bs_sample_dbxref.dbxref_id bs_sample_dbxref_dbxref_id_fkey R
bs_sample_element_dbxref.dbxref_id bs_sample_element_dbxref_dbxref_id_fkey R
ge_experiment_dbxref.dbxref_id ge_experiment_dbxref_dbxref_id_fkey R
ge_experimental_design_dbxref.dbxref_id ge_experimental_design_dbxref_dbxref_id_fkey R
ge_fluorescanning.dbxref_id ge_fluorescanning_dbxref_id_fkey R
ge_platform_dbxref.dbxref_id ge_platform_dbxref_dbxref_id_fkey R
ge_target_dbxref.dbxref_id ge_target_dbxref_dbxref_id_fkey R
ge_template_dbxref.dbxref_id ge_template_dbxref_dbxref_id_fkey R
allele_dbxref.dbxref_id allele_dbxref_dbxref_id_fkey R
germplasm.dbxref_id germplasm_dbxref_id_fkey R
individual_dbxref.dbxref_id individual_dbxref_dbxref_id_fkey R
individual_dbxref_evidence.evidence_code individual_dbxref_evidence_evidence_code_fkey R
individual_dbxref_evidence.evidence_description individual_dbxref_evidence_evidence_description_fkey R
individual_dbxref_evidence.evidence_with individual_dbxref_evidence_evidence_with_fkey R
individual_dbxref_evidence.reference_id individual_dbxref_evidence_reference_id_fkey R
individual_dbxref_evidence.relationship_type individual_dbxref_evidence_relationship_type_fkey R
individual_dbxref_evidence_history.evidence_code individual_dbxref_evidence_history_evidence_code_fkey R
individual_dbxref_evidence_history.evidence_description individual_dbxref_evidence_history_evidence_description_fkey R
individual_dbxref_evidence_history.evidence_with individual_dbxref_evidence_history_evidence_with_fkey R
individual_dbxref_evidence_history.reference_id individual_dbxref_evidence_history_reference_id_fkey R
individual_dbxref_evidence_history.relationship_type individual_dbxref_evidence_history_relationship_type_fkey R
locus2locus.evidence_id locus2locus_evidence_id_fkey R
locus2locus.reference_id locus2locus_reference_id_fkey R
locus2locus.relationship_id locus2locus_relationship_id_fkey R
locus_dbxref.dbxref_id locus_dbxref_dbxref_id_fkey R
locus_dbxref_evidence.evidence_code_id locus_dbxref_evidence_evidence_code_id_fkey R
locus_dbxref_evidence.evidence_description_id locus_dbxref_evidence_evidence_description_id_fkey R
locus_dbxref_evidence.evidence_with locus_dbxref_evidence_evidence_with_fkey R
locus_dbxref_evidence.reference_id locus_dbxref_evidence_reference_id_fkey R
locus_dbxref_evidence.relationship_type_id locus_dbxref_evidence_evidence_relationship_type_id_fkey R
locus_dbxref_evidence_history.evidence_code locus_dbxref_evidence_history_evidence_code_fkey R
locus_dbxref_evidence_history.evidence_description locus_dbxref_evidence_history_evidence_description_fkey R
locus_dbxref_evidence_history.evidence_with locus_dbxref_evidence_history_evidence_with_fkey R
locus_dbxref_evidence_history.reference_id locus_dbxref_evidence_history_reference_id_fkey R
locus_dbxref_evidence_history.relationship_type locus_dbxref_evidence_history_relationship_type_fkey R
locusgroup_member.reference_id locusgroup_member_reference_id_fkey R
population_dbxref.dbxref_id population_dbxref_dbxref_id_fkey C
user_trait.dbxref_id user_trait_dbxref_id_fkey N
cvterm.dbxref_id cvterm_dbxref_id_fkey N
cvterm_dbxref.dbxref_id cvterm_dbxref_dbxref_id_fkey C
dbxrefprop.dbxref_id dbxrefprop_dbxref_id_fkey R
feature.dbxref_id feature_dbxref_id_fkey N
feature_cvterm_dbxref.dbxref_id feature_cvterm_dbxref_dbxref_id_fkey C
feature_dbxref.dbxref_id feature_dbxref_dbxref_id_fkey C
nd_experiment_dbxref.dbxref_id nd_experiment_dbxref_dbxref_id_fkey C
nd_experiment_stock_dbxref.dbxref_id nd_experiment_stock_dbxref_dbxref_id_fkey C
nd_geolocation_dbxref.dbxref_id nd_geolocation_dbxref_dbxref_id_fkey C
organism_dbxref.dbxref_id organism_dbxref_dbxref_id_fkey C
phylonode_dbxref.dbxref_id phylonode_dbxref_dbxref_id_fkey C
phylotree.dbxref_id phylotree_dbxref_id_fkey C
project_dbxref.dbxref_id fkey_dbxref_id C
pub_dbxref.dbxref_id pub_dbxref_dbxref_id_fkey C
stock.dbxref_id stock_dbxref_id_fkey N
stock_dbxref.dbxref_id stock_dbxref_dbxref_id_fkey C
unigene_dbxref.dbxref_id unigene_dbxref_dbxref_id_fkey R
domain.dbxref_id domain_dbxref_id_fkey R
est_dbxref.dbxref_id est_dbxref_dbxref_id_fkey R
list_dbxref.dbxref_id list_dbxref_dbxref_id_fkey C
db_id int4 10 null
db.db_id dbxref_db_id_fkey C
accession varchar 255 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

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

Close relationships within degrees of separation