DATABASE SCHEMA

Explore data model:

TAXON

Referencing tables: conop_distribution | preparation | preparation_taxa | specimen_identification | taxon_common_name | taxon_description | taxon_image | taxon_list | taxon_occurrence | taxon_page | taxon_synonym | taxon_type_specimen |


Field Database column Data type Description 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