A term, class, universal or type within an ontology or controlled vocabulary. This table is also used for relations and properties. cvterms constitute nodes in the graph defined by the collection of cvterms and cvterm_relationships.
Primary identifier dbxref - The unique global OBO identifier for this cvterm. Note that a cvterm may have multiple secondary dbxrefs - see also table: cvterm_dbxref.
is_obsolete
int4
10
0
Boolean 0=false,1=true; see GO documentation for details of obsoletion. Note that two terms with different primary dbxrefs may exist if one is obsolete.
is_relationshiptype
int4
10
0
Boolean 0=false,1=true relations or relationship types (also known as Typedefs in OBO format, or as properties or slots) form a cv/ontology in themselves. We use this flag to indicate whether this cvterm is an actual term/class/universal or a relation. Relations may be drawn from the OBO Relations ontology, but are not exclusively drawn from there.
Showing 1 to 7 of 7 entries
Table contained -1 rows
Indexes
Constraint Name
Type
Sort
Column(s)
cvterm_pkey
Primary key
Asc
cvterm_id
cvterm_c1
Must be unique
Asc/Asc/Asc
name + cv_id + is_obsolete
cvterm_c2
Must be unique
Asc
dbxref_id
cvterm_idx1
Performance
Asc
cv_id
cvterm_idx2
Performance
Asc
name
cvterm_idx3
Performance
Asc
dbxref_id
Showing 1 to 6 of 6 entries
Relationships
The following entity relationship (ER) diagram shows the relationships involving the cvterm table.
