SARV database schema

TAXON

Field	Database column	Data type	Referenced table
author_year	author_year	varchar
date_added	date_added	datetime
date_changed	date_changed	datetime
fossil_group	fossil_group_id	int	taxon
hierarchy_string	hierarchy_string	varchar
id	id	int(auto increment)
in_baltoscandia	in_baltoscandia	tinyint
in_estonia	in_estonia	tinyint
is_authorized	is_authorized	tinyint
is_fossil	is_fossil	tinyint
is_fossil_group	is_fossil_group	tinyint
is_private	is_private	tinyint
is_valid	is_valid	tinyint
owner	owner	varchar
parent	parent_id	int	taxon
rank	rank	int	taxon_rank
rank_original	rank_original	int	taxon_rank
reference	reference	int	reference
remarks	remarks	text
sort	sort	int
stratigraphy_base	stratigraphy_base	int	stratigraphy
stratigraphy_top	stratigraphy_top	int	stratigraphy
taxon	taxon	varchar
taxon_epithet	taxon_epithet	varchar
taxon_id_eol	taxon_id_eol	int
taxon_id_nrm	taxon_id_nrm	varchar
taxon_id_pbdb	taxon_id_pbdb	int
taxon_id_plutof	taxon_id_plutof	int
taxon_id_tol	taxon_id_tol	int
taxon_original_name	taxon_original_name	varchar
type_taxon	type_taxon_id	int	taxon
type_taxon_free	type_taxon	varchar
user_added	user_added	varchar
user_authorized	user_authorized	varchar
user_changed	user_changed	varchar