DATABASE SCHEMA

Explore data model:

LOCALITY_STRATIGRAPHY

Contents: lokaliteedi stratigraafilised piirid

Referencing tables: None


Field Database column Data type Description Referenced table
agent agent_id int piiri fikseerinud isik agent
author_free author_free varchar
current current tinyint kas on valiidne ja kasutatav 0 või 1 (-1)
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
depth_base depth_base double
depth_base_max depth_base_max double
depth_base_min depth_base_min double
depth_top depth_top double
depth_top_max depth_top_max double
depth_top_min depth_top_min double
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
is_private is_private tinyint
locality locality int lokaliteedi kood locality
reference reference int viide piirile reference
remarks remarks text lisainfo
stratigraphy stratigraphy int stratigraafiline üksus stratigraphy
thickness thickness varchar
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record
year year varchar piiri fikseerimise aasta vajadusel lisatakse täht (näit. 1978c)