Template:ChadoTable phenotype comparison

From GMOD

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:

• phenotype_comparison_cvterm