Table cxgn.public.cvterm_relationship

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"

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cvterm_relationship_id

serial

√

nextval('cvterm_relationship_cvterm_relationship_id_seq'::regclass)

type_id

int4

cvterm.cvterm_id

cvterm_relationship_type_id_fkey

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

cvterm.cvterm_id

cvterm_relationship_subject_id_fkey

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

cvterm.cvterm_id

cvterm_relationship_object_id_fkey

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

Table contained 63,508 rows at Wed May 20 01:40 EDT 2009

Indexes:

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