Difference between revisions of "Template:ChadoTable element relationship"

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|element_relationship|Sometimes we want to combine measurements from multiple elements to get a composite value. Affymetrix combines many probes to form a probeset measurement, for instance.}}
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Mage|element_relationship|Sometimes we want to combine measurements from multiple elements to get a composite value. Affymetrix combines many probes to form a probeset measurement, for instance.}}
 
{{ChadoColumnsHeader|Mage|element_relationship}}
 
{{ChadoColumnsHeader|Mage|element_relationship}}
{{ChadoColumnDesc||element_relationship_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||element_relationship_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|element}}|subject_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|element}}|subject_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|element}}|object_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Mage|element}}|object_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||value|text|}}
 
{{ChadoColumnDesc||value|text|}}
{{ChadoColumnDesc||rank|integer|''UNIQUE#1''
+
{{ChadoColumnDesc||rank|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|element_relationship}}
 
{{ChadoTablesReferencingHeader|element_relationship}}
 
+
* 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: element_relationship
Module: Mage

Sometimes we want to combine measurements from multiple elements to get a composite value. Affymetrix combines many probes to form a probeset measurement, for instance.

element_relationship columns
FK Name Type Description
element_relationship_id serial PRIMARY KEY
element subject_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL

element object_id integer UNIQUE#1

NOT NULL

value text
rank integer UNIQUE#1

NOT NULL


Tables referencing element_relationship via foreign key constraints:

  • None.