DATABASE SCHEMA

Explore data model:

CLASSIFICATION_MINERAL

Referencing tables: specimen_identification_geology |


Field Database column Data type Description Referenced table
dana_code dana_code varchar
dana_rank dana_rank varchar
date_added date_added datetime
date_changed date_changed datetime
formula formula varchar
formula_html formula_html varchar
id id int(auto increment)
mindat_id mindat_id int
name name varchar
name_et name_et varchar
old_dana_class_en old_dana_class_en varchar
old_dana_class_et old_dana_class_et varchar
parent_id_dana parent_id_dana int classification_mineral
parent_id_strunz parent_id_strunz int classification_mineral
remarks remarks text
strunz_code strunz_code varchar
user_added user_added varchar
user_changed user_changed varchar