DATABASE SCHEMA

Explore data model:

DRILLCORE_STUDY

Contents: studies of drill core

Referencing tables: None


Field Database column Data type Description Referenced table
agent agent int uurija kood agent
aim aim varchar südamiku uurimise eesmärk artikkel, projekt, jne.
database database_id int database
date date date puursüdamiku uurimise aeg
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
depth_end depth_end double
depth_start depth_start double
description description tinyint kirjeldamine (jah / ei)
drillcore drillcore int puursüdamiku kood drillcore
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
number_samples number_samples int proovide arv
observation observation tinyint vaatamine (jah / ei)
ordering ordering tinyint korrastamine (jah / ei)
other_persons other_persons varchar töös osalenud teised uurijad
photography photography tinyint pildistamine (jah / ei)
planned_analyses planned_analyses varchar
remarks remarks text lisainfo vabas vormis
sampling sampling tinyint proovimine (jah / ei)
stratigraphy_free stratigraphy_free varchar
timestamp timestamp datetime ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record