TABLES
4
VIEWS
0
COLUMNS
20
Constraints
10
chado.phenotype Tables
Table / View | Referenced | Foreign Keys | Columns | Type | Comments |
---|---|---|---|---|---|
feature_phenotype | 0 | 2 | 3 | Table | Linking table between features and phenotypes. |
phenotype | 7 | 4 | 8 | Table | 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_cvterm | 0 | 2 | 4 | Table | phenotype to cvterm associations. |
phenotypeprop | 0 | 2 | 5 | Table | A phenotype can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible. There is a unique constraint, phenotypeprop_c1, for the combination of phenotype_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank. |