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 |