EUROCORE database architecture and components

analysis

Contents:

Description:

Referencing tables: agent analysis_method analysis_result attachment dataset drillcore lab lab_instrument sample spectrum



Field Database column Data type Description Referenced table
id id int(auto increment)
number number varchar
sample sample int sample
analysis_method method int analysis_method
lab_method_code lab_method_code varchar
lab lab_id int lab
instrument instrument_id int lab_instrument
acquisition_params acquisition_params json
drillcore drillcore int drillcore
depth depth double
end_depth end_depth double
remarks remarks text
date date datetime
date_free date_free varchar
agent agent int agent
upload upload file
public public tinyint
date_added date_added datetime
date_changed date_changed datetime
attachment attachment int attachment