DATABASE SCHEMA

Explore data model:

TAXON_OCCURRENCE

Referencing tables: None


Field Database column Data type Description Referenced table
country country int list_country
date_added date_added datetime
date_changed date_changed datetime
depth depth double
depth_interval depth_interval double
figures figures varchar
geographic_distribution geographic_distribution varchar
geographic_distribution_en geographic_distribution_en varchar
id id int(auto increment)
locality locality int locality
locality_free locality_free varchar
pages pages varchar
reference reference int reference
remarks remarks varchar
stratigraphic_distribution stratigraphic_distribution varchar
stratigraphic_distribution_en stratigraphic_distribution_en varchar
stratigraphy_base stratigraphy_base int stratigraphy
stratigraphy_base_free stratigraphy_base_free varchar
stratigraphy_top stratigraphy_top int stratigraphy
stratigraphy_top_free stratigraphy_top_free varchar
taxon taxon int taxon
timestamp timestamp datetime
user_added user_added varchar
user_changed user_changed varchar