EUROCORE database architecture and components

deposit

Contents:

Description:

Referencing tables: age drillcore ore_genetic_type ore_metal_group ore_metal_subgroup reference



Field Database column Data type Description Referenced table
id id int(auto increment)
name name varchar
alternative_names alternative_names varchar
district district varchar
metgen_area metgen_area varchar
latitude latitude double
longitude longitude double
main_commodity main_commodity varchar
other_commodities other_commodities varchar
metal_group metal_group int ore_metal_group
metal_subgroup metal_subgroup int ore_metal_subgroup
genetic_type genetic_type int ore_genetic_type
remarks remarks text
status status varchar
mining_method mining_method varchar
discovery discovery int
mining_start mining_start int
mining_time mining_time varchar
size_cat size_cat varchar
resource resource double
reserve reserve double
mined_mt mined_mt double
tonnage tonnage double
grade grade text
mineralogy1 mineralogy1 text
mineralogy2 mineralogy2 text
host_rock1 host_rock1 text
host_rock2 host_rock2 text
adj_rock1 adj_rock1 text
adj_rock2 adj_rock2 text
adj_rock3 adj_rock3 text
adj_rock4 adj_rock4 text
age_host age_host int age
age_min age_min int age
radiom_age_host radiom_age_host text
radiom_age_min radiom_age_min text
alteration alteration text
metam_grade metam_grade varchar
ore_distrib ore_distrib varchar
texture texture varchar
structure structure varchar
shape shape varchar
strike strike varchar
dip dip varchar
plunge plunge varchar
tect_ctrl tect_ctrl text
public public tinyint
date_added date_added datetime
date_changed date_changed datetime
reference reference int reference