Difference between revisions of "Template:ChadoTable cv"

From GMOD
Jump to: navigation, search
(Script test)
 
(Table definition for Chado on 2010/11/24)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<noinclude>{{ChadoTableTemplateHeader}}</noinclude><protect>{{ChadoTableDesc|CV|cv|A controlled vocabulary or ontology. A cv is
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|CV|cv|A controlled vocabulary or ontology. A cv is
 
composed of cvterms (AKA terms, classes, types, universals - relations
 
composed of cvterms (AKA terms, classes, types, universals - relations
 
and properties are also stored in cvterm) and the relationships
 
and properties are also stored in cvterm) and the relationships
 
between them.}}
 
between them.}}
 
{{ChadoColumnsHeader|CV|cv}}
 
{{ChadoColumnsHeader|CV|cv}}
{{ChadoColumnDesc||cv_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||cv_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc||name|character varying(255)|''UNIQUE''
+
{{ChadoColumnDesc||name|character varying(255)|''UNIQUE''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
The name of the ontology. This
 
The name of the ontology. This
 
corresponds to the obo-format -namespace-. cv names uniquely identify
 
corresponds to the obo-format -namespace-. cv names uniquely identify
Line 19: Line 17:
  
 
{{ChadoTablesReferencingHeader|cv}}
 
{{ChadoTablesReferencingHeader|cv}}
 
+
{{ChadoReferencingTable|CV|cvterm}}
* None.
+
{{ChadoReferencingTable|CV|cvtermpath}}
 
</protect>
 
</protect>

Latest revision as of 19:59, 24 November 2010

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:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.


Table: cv
Module: CV

A controlled vocabulary or ontology. A cv is composed of cvterms (AKA terms, classes, types, universals - relations and properties are also stored in cvterm) and the relationships between them.

cv columns
FK Name Type Description
cv_id serial PRIMARY KEY
name character varying(255) UNIQUE

NOT NULL
The name of the ontology. This corresponds to the obo-format -namespace-. cv names uniquely identify the cv. In OBO file format, the cv.name is known as the namespace.

definition text A text description of the criteria for

membership of this ontology.

Tables referencing cv via foreign key constraints: