DATABASE SCHEMA

Explore data model:

ROCK

Referencing tables: rock_image | rock_locality | rock_tree | rock_synonym | rock_mineral | rock_property | rock_reference | 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_in_estonia description_in_estonia text
description_usage description_usage text
formula formula varchar
formula_html formula_html varchar
id id int(auto increment)
ima_status ima_status int
in_estonia in_estonia tinyint
in_portal in_portal tinyint
is_private is_private tinyint
is_resource is_resource tinyint
link_wikipedia link_wikipedia varchar
link_wikipedia_en link_wikipedia_en varchar
mindat_id mindat_id int
name name varchar
name_en name_en varchar
remarks remarks text
rock_rank rock_rank int rock_rank
rock_type rock_type int rock_type
sort sort int
user_added user_added varchar
user_changed user_changed varchar