Difference between revisions of "Template:ChadoTable library cvterm"

From GMOD
Jump to: navigation, search
(Table definition, first upload on 2010/11/22.)
 
(Table definition for Chado on 2010/11/24)
 
Line 1: Line 1:
<noinclude>{{ChadoTableTemplateHeader}}</noinclude><protect>{{ChadoTableDesc|Library|library_cvterm|The table library_cvterm links a library to controlled vocabularies which describe the library.  For instance, there might be a link to the anatomy cv for &quot;head&quot; or &quot;testes&quot; for a head or testes library.}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Library|library_cvterm|The table library_cvterm links a library to controlled vocabularies which describe the library.  For instance, there might be a link to the anatomy cv for &quot;head&quot; or &quot;testes&quot; for a head or testes library.}}
 
{{ChadoColumnsHeader|Library|library_cvterm}}
 
{{ChadoColumnsHeader|Library|library_cvterm}}
{{ChadoColumnDesc||library_cvterm_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||library_cvterm_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Library|library}}|library_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Library|library}}|library_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|cvterm_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|cvterm_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|library_cvterm}}
 
{{ChadoTablesReferencingHeader|library_cvterm}}
 
+
* None.</protect>
* None.
+
</protect>
+

Latest revision as of 19:21, 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: library_cvterm
Module: Library

The table library_cvterm links a library to controlled vocabularies which describe the library. For instance, there might be a link to the anatomy cv for "head" or "testes" for a head or testes library.

library_cvterm columns
FK Name Type Description
library_cvterm_id serial PRIMARY KEY
library library_id integer UNIQUE#1

NOT NULL

cvterm cvterm_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing library_cvterm via foreign key constraints:

  • None.