DATABASE SCHEMA

Explore data model:

STRATIGRAPHY_REFERENCE

Contents: viited stratigraafilistele üksustele

Referencing tables: None


Field Database column Data type Description Referenced table
age_base age_base double
age_base_error age_base_error double
age_top age_top double
content content varchar
content_en content_en varchar
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
figures figures varchar joonised
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
is_preferred_age is_preferred_age tinyint
pages pages varchar leheküljed
reference reference int viite (publikatsiooni, käsikirja vms) kood reference
remarks remarks text lisainfo vabas vormis
stratigraphy stratigraphy int stratigraafilise üksuse unikaalne kood stratigraphy
type type int
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record