Table cxgn.public.cvterm

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

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_id

serial

√

nextval('cvterm_cvterm_id_seq'::regclass)

analysisprop.type_id	analysisprop_type_id_fkey
cvterm_dbxref.cvterm_id	cvterm_dbxref_cvterm_id_fkey
cvterm_pub_ranking.cvterm_id	cvterm_pub_ranking_cvterm_id_fkey
cvterm_relationship.object_id	cvterm_relationship_object_id_fkey
cvterm_relationship.subject_id	cvterm_relationship_subject_id_fkey
cvterm_relationship.type_id	cvterm_relationship_type_id_fkey
cvtermpath.object_id	cvtermpath_object_id_fkey
cvtermpath.subject_id	cvtermpath_subject_id_fkey
cvtermpath.type_id	cvtermpath_type_id_fkey
cvtermprop.cvterm_id	cvtermprop_cvterm_id_fkey
cvtermprop.type_id	cvtermprop_type_id_fkey
cvtermsynonym.cvterm_id	cvtermsynonym_cvterm_id_fkey
cvtermsynonym.type_id	cvtermsynonym_type_id_fkey
dbxrefprop.type_id	dbxrefprop_type_id_fkey
feature.type_id	feature_type_id_fkey
feature_cvterm.cvterm_id	feature_cvterm_cvterm_id_fkey
feature_cvtermprop.type_id	feature_cvtermprop_type_id_fkey
feature_relationship.type_id	feature_relationship_type_id_fkey
feature_relationshipprop.type_id	feature_relationshipprop_type_id_fkey
featureprop.type_id	featureprop_type_id_fkey
organism_relationship.type_id	organism_relationship_type_id_fkey
organismpath.type_id	organismpath_type_id_fkey
organismprop.type_id	organismprop_type_id_fkey
phenotype.assay_id	phenotype_assay_id_fkey
phenotype.attr_id	phenotype_attr_id_fkey
phenotype.cvalue_id	phenotype_cvalue_id_fkey
phenotype.observable_id	phenotype_observable_id_fkey
phenotype_cvterm.cvterm_id	phenotype_cvterm_cvterm_id_fkey
pub.type_id	pub_type_id_fkey
pub_relationship.type_id	pub_relationship_type_id_fkey
pubprop.type_id	pubprop_type_id_fkey
synonym.type_id	synonym_type_id_fkey

cv_id

int4

cv.cv_id

cvterm_cv_id_fkey

The cv/ontology/namespace to which
this cvterm belongs

name

varchar

1024

A concise human-readable name or
label for the cvterm. uniquely identifies a cvterm within a cv

definition

text

2147483647

√

null

A human-readable text
definition

dbxref_id

int4

dbxref.dbxref_id

cvterm_dbxref_id_fkey

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

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

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

Table contained 44,067 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
cvterm_id	Primary key	Asc	cvterm_pkey
name + cv_id + is_obsolete	Must be unique	Asc/Asc/Asc	cvterm_c1
dbxref_id	Must be unique	Asc	cvterm_c2
cv_id	Performance	Asc	cvterm_idx1
name	Performance	Asc	cvterm_idx2
dbxref_id	Performance	Asc	cvterm_idx3