Lk_Disease
Controlled vocabulary for disease.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| name | varchar(250) | Name or identifier | |
| disease_ontology_id | varchar(50) | ||
| description | varchar(1000) | Free text to expand upon details | |
| link | varchar(2000) | Link to URL | |
| human_phenotype_id | varchar(50) | Link to Human Phenotype Ontology |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | name | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| immune_exposure | disease_preferred | lk_disease | name |
| study_2_condition_or_disease | condition_preferred | lk_disease | name |