Schema Version: 1.3 Module: chado

biomaterial_dbxref


Columns

Column Type Size Foreign Key Nullable Default Comments
biomaterial_dbxref_id bigserial 19
nextval('mage.biomaterial_dbxref_biomaterial_dbxref_id_seq'::regclass)
biomaterial_id int8 19
biomaterial.biomaterial_id biomaterial_dbxref_biomaterial_id_fkey C
null
dbxref_id int8 19
dbxref.dbxref_id biomaterial_dbxref_dbxref_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
biomaterial_dbxref_pkey Primary key Asc biomaterial_dbxref_id
biomaterial_dbxref_c1 Must be unique Asc/Asc biomaterial_id + dbxref_id
biomaterial_dbxref_idx1 Performance Asc biomaterial_id
biomaterial_dbxref_idx2 Performance Asc dbxref_id

Relationships

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