Lk_Virus_Strain
Controlled vocabulary for virus strains.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| name | varchar(200) | Name or identifier | |
| center_id_name_season_list | varchar(500) | List of teams studying a virus in a season | |
| description | varchar(1000) | Free text to expand upon details | |
| link | varchar(2000) | Link to URL | |
| season_list | varchar(100) | List of seasons for the virus | |
| taxonomy_id | int | Standardized value in LK_SPECIES | |
| virus_name | varchar(10) | Reported value |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | name | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| hai_result | virus_strain_preferred | lk_virus_strain | name |
| neut_ab_titer_result | virus_strain_preferred | lk_virus_strain | name |
| Name | Center_Id_Name_Season_List | Description | Link | Season_List | Taxonomy_Id | Virus_Name |
|---|