Difference between revisions of "Template:ChadoTable study"

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|Mage|study|}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Mage|study|}}
 
{{ChadoColumnsHeader|Mage|study}}
 
{{ChadoColumnsHeader|Mage|study}}
{{ChadoColumnDesc||study_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||study_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|contact_id|integer|''NOT NULL''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|contact_id|integer|''NOT NULL''<br />
 
+
 
}}
 
}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|General|dbxref}}|dbxref_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|General|dbxref}}|dbxref_id|integer|}}
{{ChadoColumnDesc||name|text|''UNIQUE''
+
{{ChadoColumnDesc||name|text|''UNIQUE''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||description|text|}}
 
{{ChadoColumnDesc||description|text|}}
Line 18: Line 15:
  
 
{{ChadoTablesReferencingHeader|study}}
 
{{ChadoTablesReferencingHeader|study}}
 
+
* {{ChadoReferencingTable|Mage|study_assay}}
* None.
+
* {{ChadoReferencingTable|Mage|studydesign}}
 +
* {{ChadoReferencingTable|Mage|studyprop}}
 
</protect>
 
</protect>

Revision as of 19:23, 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: study
Module: Mage


study columns
FK Name Type Description
study_id serial PRIMARY KEY
contact contact_id integer NOT NULL
pub pub_id integer
dbxref dbxref_id integer
name text UNIQUE

NOT NULL

description text

Tables referencing study via foreign key constraints: