Difference between revisions of "Template:ChadoTable phenotype comparison"

From GMOD
Jump to: navigation, search
(Table definition for Chado on 2010/11/24)
(Table definition for Chado on 2010/11/24)
 
Line 28: Line 28:
  
 
{{ChadoTablesReferencingHeader|phenotype_comparison}}
 
{{ChadoTablesReferencingHeader|phenotype_comparison}}
* {{ChadoReferencingTable|Genetic|phenotype_comparison_cvterm}}
+
{{ChadoReferencingTable|Genetic|phenotype_comparison_cvterm}}
 
</protect>
 
</protect>

Latest revision as of 19:58, 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: phenotype_comparison
Module: Genetic

Comparison of phenotypes e.g., genotype1/environment1/phenotype1 "non-suppressible" with respect to genotype2/environment2/phenotype2.

phenotype_comparison columns
FK Name Type Description
phenotype_comparison_id serial PRIMARY KEY
genotype genotype1_id integer UNIQUE#1

NOT NULL

environment environment1_id integer UNIQUE#1

NOT NULL

genotype genotype2_id integer UNIQUE#1

NOT NULL

environment environment2_id integer UNIQUE#1

NOT NULL

phenotype phenotype1_id integer UNIQUE#1

NOT NULL

phenotype phenotype2_id integer
pub pub_id integer UNIQUE#1

NOT NULL

organism organism_id integer NOT NULL


Tables referencing phenotype_comparison via foreign key constraints: