Schema Version: 1.3

contact_relationship


Description

Model relationships between contacts

Columns

Column Type Size Foreign Key Nullable Default Comments
contact_relationship_id bigserial 19
nextval('chado.contact_relationship_contact_relationship_id_seq'::regclass)
type_id int8 19
cvterm.cvterm_id contact_relationship_type_id_fkey C
null

Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.

subject_id int8 19
contact.contact_id contact_relationship_subject_id_fkey C
null

The subject of the subj-predicate-obj sentence. In a DAG, this corresponds to the child node.

object_id int8 19
contact.contact_id contact_relationship_object_id_fkey C
null

The object of the subj-predicate-obj sentence. In a DAG, this corresponds to the parent node.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
contact_relationship_pkey Primary key Asc contact_relationship_id
contact_relationship_c1 Must be unique Asc/Asc/Asc subject_id + object_id + type_id
contact_relationship_idx1 Performance Asc type_id
contact_relationship_idx2 Performance Asc subject_id
contact_relationship_idx3 Performance Asc object_id

Relationships