contact_relationship

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

contact_relationship_id

serial

10

√

nextval('contact_relationship_contact_relationship_id_seq'::regclass)

type_id

int4

10

null

cvterm.cvterm_id

contact_relationship_type_id_fkey

C

subject_id

int4

10

null

contact.contact_id

contact_relationship_subject_id_fkey

C

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

object_id

int4

10

null

contact.contact_id

contact_relationship_object_id_fkey

C

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

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