DATABASE SCHEMA

Explore data model:

CLASSIFICATION_ROCK

Contents: hierarchical classification of rocks and sediments

Referencing tables: sample | specimen_identification_geology |


Field Database column Data type Description Referenced table
date_added date_added datetime
date_changed date_changed datetime
description description text
description_en description_en text
hierarchy_string hierarchy_string varchar
id id int(auto increment)
name name varchar
name_en name_en varchar
parent parent_id int classification_rock
remarks remarks text
user_added user_added varchar
user_changed user_changed varchar