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