Template:ChadoTable cvterm relationship
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
Table: | cvterm_relationship |
Module: | CV |
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".
FK | Name | Type | Description |
---|---|---|---|
cvterm_relationship_id | serial | PRIMARY KEY
| |
cvterm | type_id | integer | UNIQUE#1
NOT NULL 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. |
cvterm | subject_id | integer | UNIQUE#1
NOT NULL 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. |
cvterm | object_id | integer | UNIQUE#1
NOT NULL 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. |
Tables referencing cvterm_relationship via foreign key constraints:
- None.