cvterm_relationship

11002 rows


Description

A relationship linking two cvterms. Each cvterm_relationship constitutes an edge in the graph defined by the collection of cvterms and cvterm_relationships. The meaning of the cvterm_relationship depends on the definition of the cvterm R refered to by type_id. However, in general the definitions are such that the statement all SUBJs REL some OBJ is true. The cvterm_relationship statement is about the subject, not the object. For example “insect wing part_of thorax”

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cvterm_relationship_id serial 10 √ nextval('cvterm_relationship_cvterm_relationship_id_seq'::regclass)
type_id int4 10 null
cvterm.cvterm_id cvterm_relationship_type_id_fkey C

The nature of the relationship between subject and object. Note that relations are also housed in the cvterm table, typically from the OBO relationship ontology, although other relationship types are allowed
subject_id int4 10 null
cvterm.cvterm_id cvterm_relationship_subject_id_fkey C

the subject of the subj-predicate-obj sentence. The cvterm_relationship is about the subject. In a graph, this typically corresponds to the child node
object_id int4 10 null
cvterm.cvterm_id cvterm_relationship_object_id_fkey C

the object of the subj-predicate-obj sentence. The cvterm_relationship refers to the object. In a graph, this typically corresponds to the parent node

Indexes

Constraint Name Type Sort Column(s)
cvterm_relationship_pkey Primary key Asc cvterm_relationship_id
cvterm_relationship_c1 Must be unique Asc/Asc/Asc subject_id + object_id + type_id
cvterm_relationship_idx1 Performance Asc type_id
cvterm_relationship_idx2 Performance Asc subject_id
cvterm_relationship_idx3 Performance Asc object_id

Relationships

Close relationships within degrees of separation