DATABASE SCHEMA

Explore data model:

TAXON_TYPE_SPECIMEN

Referencing tables: None


Field Database column Data type Description Referenced table
date_added date_added datetime
date_changed date_changed datetime
id id int(auto increment)
locality locality int locality
locality_free locality_free varchar
locality_free_en locality_free_en varchar
reference reference int reference
remarks remarks text
repository repository varchar
specimen specimen int specimen
specimen_number specimen_number varchar
stratigraphy stratigraphy_id int stratigraphy
stratigraphy_free stratigraphy_free varchar
stratigraphy_free_en stratigraphy_free_en varchar
taxon taxon int taxon
timestamp timestamp datetime
type_type type_type int taxon_type_type
user_added user_added varchar
user_changed user_changed varchar