Difference between revisions of "Template:ChadoTable quantification"

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|quantification|Quantification is the transformation of an image acquisition to numeric data. This typically involves statistical procedures.}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Mage|quantification|Quantification is the transformation of an image acquisition to numeric data. This typically involves statistical procedures.}}
 
{{ChadoColumnsHeader|Mage|quantification}}
 
{{ChadoColumnsHeader|Mage|quantification}}
{{ChadoColumnDesc||quantification_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||quantification_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|acquisition}}|acquisition_id|integer|''NOT NULL''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|acquisition}}|acquisition_id|integer|''NOT NULL''<br />
 
+
 
}}
 
}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|operator_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Contact|contact}}|operator_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|protocol}}|protocol_id|integer|}}
 
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|protocol}}|protocol_id|integer|}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Companalysis|analysis}}|analysis_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Companalysis|analysis}}|analysis_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc||quantificationdate|timestamp without time zone|''DEFAULT ''now()
+
{{ChadoColumnDesc||quantificationdate|timestamp without time zone|''DEFAULT ''now()<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc||name|text|''UNIQUE#1''
+
{{ChadoColumnDesc||name|text|''UNIQUE#1''<br />
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||uri|text|}}
 
{{ChadoColumnDesc||uri|text|}}
Line 24: Line 19:
  
 
{{ChadoTablesReferencingHeader|quantification}}
 
{{ChadoTablesReferencingHeader|quantification}}
 
+
* {{ChadoReferencingTable|Mage|elementresult}}
* None.
+
* {{ChadoReferencingTable|Mage|quantification_relationship}}
 +
* {{ChadoReferencingTable|Mage|quantificationprop}}
 
</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: quantification
Module: Mage

Quantification is the transformation of an image acquisition to numeric data. This typically involves statistical procedures.

quantification columns
FK Name Type Description
quantification_id serial PRIMARY KEY
acquisition acquisition_id integer NOT NULL
contact operator_id integer
protocol protocol_id integer
analysis analysis_id integer UNIQUE#1

NOT NULL

quantificationdate timestamp without time zone DEFAULT now()
name text UNIQUE#1
uri text

Tables referencing quantification via foreign key constraints: