Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
feature_phenotype Table feature_phenotype_id bigserial 19 nextval('phenotype.feature_phenotype_feature_phenotype_id_seq'::regclass)
phenotypeprop Table type_id int8 19 null
phenotypeprop Table phenotypeprop_id bigserial 19 nextval('phenotype.phenotypeprop_phenotypeprop_id_seq'::regclass)
phenotype_cvterm Table phenotype_id int8 19 null
phenotype_cvterm Table rank int4 10 0
phenotype Table assay_id int8 19 null

Evidence type.

phenotype_cvterm Table cvterm_id int8 19 null
feature_phenotype Table feature_id int8 19 null
phenotype Table observable_id int8 19 null

The entity: e.g. anatomy_part, biological_process.

phenotype Table attr_id int8 19 null

Phenotypic attribute (quality, property, attribute, character) - drawn from PATO.

phenotype Table value text 2147483647 null

Value of attribute - unconstrained free text. Used only if cvalue_id is not appropriate.

phenotype Table uniquename text 2147483647 null
phenotype Table phenotype_id bigserial 19 nextval('phenotype.phenotype_phenotype_id_seq'::regclass)
feature_phenotype Table phenotype_id int8 19 null
phenotypeprop Table rank int4 10 0
phenotypeprop Table value text 2147483647 null
phenotype Table name text 2147483647 null
phenotype_cvterm Table phenotype_cvterm_id bigserial 19 nextval('phenotype.phenotype_cvterm_phenotype_cvterm_id_seq'::regclass)
phenotype Table cvalue_id int8 19 null

Phenotype attribute value (state).

phenotypeprop Table phenotype_id int8 19 null