Schema Version: 1.3 Module: chado

contactprop


Description

A contact can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible.

Columns

Column Type Size Foreign Key Nullable Default Comments
contactprop_id bigserial 19
nextval('contact.contactprop_contactprop_id_seq'::regclass)
contact_id int8 19
contact.contact_id contactprop_contact_id_fkey C
null
type_id int8 19
cvterm.cvterm_id contactprop_type_id_fkey C
null
value text 2147483647
√ null
rank int4 10
0

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
contactprop_pkey Primary key Asc contactprop_id
contactprop_c1 Must be unique Asc/Asc/Asc contact_id + type_id + rank
contactprop_idx1 Performance Asc contact_id
contactprop_idx2 Performance Asc type_id

Relationships

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