DATABASE SCHEMA

Explore data model:

DRILLCORE_BOX

Contents: detailed information of drill core by boxes

Referencing tables: drillcore_image |


Field Database column Data type Description Referenced table
database database_id int database
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
depth_end depth_end double
depth_other depth_other varchar referentssügavus näit. birka, proovi jms tase, kasut. juhul kui dep ja dep1 puuduvad
depth_start depth_start double
diameter diameter int
drillcore drillcore int FK drillcore(id) drillcore
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
location location varchar südamiku asukoha kood säilituskohas enamasti hoidla (näit. h6a)
number number varchar
number_meters number_meters int
remarks remarks text lisainfo vabas vormis
storage storage_id int location
stratigraphy_base stratigraphy_base int stratigraphy
stratigraphy_base_free stratigraphy_base_free varchar
stratigraphy_free stratigraphy_free varchar stratigraafilised piirid mis jäävad kasti piiridesse mitte seotud tabeliga STRAT
stratigraphy_top stratigraphy_top int stratigraphy
stratigraphy_top_free stratigraphy_top_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