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 |
---|