NOTE: We are working on migrating this site away from MediaWiki, so editing pages will be disabled for now.
Template:ChadoTable cvterm
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 |
Module: | CV |
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.
FK | Name | Type | Description |
---|---|---|---|
cvterm_id | serial | PRIMARY KEY | |
cv | cv_id | integer | UNIQUE#1 NOT NULL |
name | character varying(1024) | UNIQUE#1 NOT NULL | |
definition | text | A human-readable text
definition. | |
dbxref | dbxref_id | integer | UNIQUE NOT NULL |
is_obsolete | integer | UNIQUE#1 NOT NULL | |
is_relationshiptype | integer | NOT NULL 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. |
Tables referencing cvterm via foreign key constraints:
- acquisition_relationship
- acquisitionprop
- analysisfeatureprop
- analysisprop
- arraydesign
- arraydesignprop
- assayprop
- biomaterial_relationship
- biomaterial_treatment
- biomaterialprop
- cell_line_cvterm
- cell_line_cvtermprop
- cell_line_relationship
- cell_lineprop
- contact
- contact_relationship
- control
- cvterm_dbxref
- cvterm_relationship
- cvtermpath
- cvtermprop
- cvtermsynonym
- dbxrefprop
- element
- element_relationship
- elementresult_relationship
- environment_cvterm
- expression_cvterm
- expression_cvtermprop
- expressionprop
- feature
- feature_cvterm
- feature_cvtermprop
- feature_expressionprop
- feature_genotype
- feature_pubprop
- feature_relationship
- feature_relationshipprop
- featuremap
- featureprop
- library
- library_cvterm
- libraryprop
- nd_experiment
- nd_experiment_stock
- nd_experiment_stockprop
- nd_experimentprop
- nd_geolocationprop
- nd_protocol_reagent
- nd_protocolprop
- nd_reagent
- nd_reagent_relationship
- nd_reagentprop
- organismprop
- phendesc
- phenotype
- phenotype_comparison_cvterm
- phenotype_cvterm
- phenstatement
- phylonode
- phylonode_relationship
- phylonodeprop
- phylotree
- project_relationship
- projectprop
- protocol
- protocolparam
- pub
- pub_relationship
- pubprop
- quantification_relationship
- quantificationprop
- stock
- stock_cvterm
- stock_dbxrefprop
- stock_relationship
- stock_relationship_cvterm
- stockcollection
- stockcollectionprop
- stockprop
- studydesignprop
- studyfactor
- studyprop
- studyprop_feature
- synonym
- treatment