EUROCORE database architecture and components

drillcore

Contents:

Description:

Referencing tables: agent analysis deposit dip drillcore_box drillcore_interval drillcore_diameter lithology mineralization_alteration mineral_occurrence reference rqd sample structure



Field Database column Data type Description Referenced table
id id int(auto increment)
name name varchar
latitude latitude double
longitude longitude double
elevation elevation double
drilling_year drilling_year int
drilling_agent drilling_agent int agent
hole_length hole_length double
hole_azimuth hole_azimuth double
hole_dip hole_dip double
deposit deposit int deposit
core_depositor core_depositor int agent
number_boxes number_boxes int
diameter diameter varchar
remarks remarks text
public public tinyint
date_added date_added datetime
date_changed date_changed datetime
references references int reference