Template:ChadoTable phenstatement

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:	phenstatement
Module:	Genetic

Phenotypes are things like "larval lethal". Phenstatements are things like "dpp-1 is recessive larval lethal". So essentially phenstatement is a linking table expressing the relationship between genotype, environment, and phenotype.

phenstatement columns

FK	Name	Type	Description
	phenstatement_id	serial	PRIMARY KEY
genotype	genotype_id	integer	UNIQUE#1 NOT NULL
environment	environment_id	integer	UNIQUE#1 NOT NULL
phenotype	phenotype_id	integer	UNIQUE#1 NOT NULL
cvterm	type_id	integer	UNIQUE#1 NOT NULL
pub	pub_id	integer	UNIQUE#1 NOT NULL

Tables referencing phenstatement via foreign key constraints:

• None.