EUROCORE database architecture and components

lithology

Contents:

Description:

Referencing tables: agent classification_rock color color_attribute drillcore grain_size rock_occurrence_type weathering_degree



Field Database column Data type Description Referenced table
id id int(auto increment)
drillcore drillcore int drillcore
start_depth start_depth double
end_depth end_depth double
rock_name rock_name int classification_rock
rock_class rock_class int classification_rock
field_name field_name varchar
rock_occurrence_type rock_occurrence_type int rock_occurrence_type
grain_size grain_size int grain_size
color color int color
color_attribute color_attribute int color_attribute
weathering_degree weathering_degree int weathering_degree
mineralogical_rock_name mineralogical_rock_name varchar
chemical_rock_name chemical_rock_name varchar
description description text
remarks remarks text
agent_described agent_described int agent
date_described date_described date
public public tinyint
date_added date_added datetime
date_changed date_changed datetime