DATABASE SCHEMA

Explore data model:

SPECIMEN_IDENTIFICATION_GEOLOGY

Referencing tables: None


Field Database column Data type Description Referenced table
agent agent int agent
classification class_id int classification
current current tinyint
date_added date_added datetime
date_changed date_changed datetime
date_identified date_identified date
date_identified_free date_identified_free varchar
id id int(auto increment)
mineral mineral int classification_mineral
name name varchar
name_en name_en varchar
reference reference int reference
remarks remarks text
rock rock int classification_rock
specimen specimen int specimen
type type int list_identification_type
user_added user_added varchar
user_changed user_changed varchar