LOCALITY_STRATIGRAPHY
Contents: lokaliteedi stratigraafilised piirid
Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| locality | int | lokaliteedi kood | locality |
| depth_base | double | ||
| depth_base_min | double | ||
| depth_base_max | double | ||
| depth_top | double | ||
| depth_top_min | double | ||
| depth_top_max | double | ||
| depth | double | piiri taseme sügavus (m) | |
| thickness | varchar | ||
| stratigraphy | int | stratigraafiline üksus | stratigraphy |
| current | tinyint | kas on valiidne ja kasutatav 0 või 1 (-1) | |
| agent | int | piiri fikseerinud isik | agent |
| author_free | varchar | ||
| year | varchar | piiri fikseerimise aasta vajadusel lisatakse täht (näit. 1978c) | |
| reference | int | viide piirile | reference |
| remarks | text | lisainfo | |
| is_private | tinyint | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor |
