Template:ChadoTable phenotype

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
Module:	Phenotype

A phenotypic statement, or a single atomic phenotypic observation, is a controlled sentence describing observable effects of non-wild type function. E.g. Obs=eye, attribute=color, cvalue=red.

phenotype columns

FK	Name	Type	Description
	phenotype_id	serial	PRIMARY KEY
	uniquename	text	UNIQUE NOT NULL
cvterm	observable_id	integer	The entity: e.g. anatomy_part, biological_process.
cvterm	attr_id	integer	Phenotypic attribute (quality, property, attribute, character) - drawn from PATO.
	value	text	Value of attribute - unconstrained free text. Used only if cvalue_id is not appropriate.
cvterm	cvalue_id	integer	Phenotype attribute value (state).
cvterm	assay_id	integer	Evidence type.

Tables referencing phenotype via foreign key constraints:

• feature_phenotype
• nd_experiment_phenotype
• phenotype_comparison
• phenotype_cvterm
• phenstatement