Schema Version: 1.3

dbxrefprop


Description

Metadata about a dbxref. Note that this is not defined in the dbxref module, as it depends on the cvterm table. This table has a structure analagous to cvtermprop.

Columns

Column Type Size Foreign Key Nullable Default Comments
dbxrefprop_id bigserial 19
nextval('chado.dbxrefprop_dbxrefprop_id_seq'::regclass)
dbxref_id int8 19
dbxref.dbxref_id dbxrefprop_dbxref_id_fkey R
null
type_id int8 19
cvterm.cvterm_id dbxrefprop_type_id_fkey R
null
value text 2147483647
''::text
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
dbxrefprop_pkey Primary key Asc dbxrefprop_id
dbxrefprop_c1 Must be unique Asc/Asc/Asc dbxref_id + type_id + rank
dbxrefprop_idx1 Performance Asc dbxref_id
dbxrefprop_idx2 Performance Asc type_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the dbxrefprop table.

Show relationships within degrees of separation