Lk_Species
Controlled vocabulary of common species names.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| name | varchar(30) | Name or identifier | |
| common_name | varchar(100) | Common name for the species. | |
| link | varchar(2000) | Link to URL | |
| taxonomy_id | varchar(10) | Standardized value in LK_SPECIES | |
| taxonomy_id_subset | varchar(10) | Species subset |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | name | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| subject | species | lk_species | name |
| Name | Common_Name | Taxonomy_Id | Taxonomy_Id_Subset | Link |
|---|