DATABASE SCHEMA

Explore data model:

DRILLCORE

Contents: drill cores

Referencing tables: drillcore_box | drillcore_study |


Field Database column Data type Description Referenced table
agent agent int puurimise eest vastutav isiku/asutuse kood agent
box_numbers box_numbers varchar kastide numbrid
boxes boxes int kastide arv
database database_id int database
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
depository storage int säilituskoht, kodeeritud valik: (Särghaua, Arbavere, ...) list_drillcore_storage
depth depth varchar sügavuste intervallid
direction_lr direction_lr tinyint
drillcore drillcore varchar
drillcore_en drillcore_en varchar
gid gid int
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
is_private is_private tinyint
locality locality_id int locality
location location varchar südamiku asukoha kood säilituskohas enamasti hoidla (näit. h6a)
number_meters number_meters int meetrite arv kastis (keskmine), kasutada juhul kui kastid ühe kaupa arvele võtmata
remarks remarks text lisainfo vabas vormis
storage storage_id int location
timestamp timestamp datetime ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor
uid uid int
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record
year year varchar puurimise aasta