Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| locality | varchar | ||
| locality_en | varchar | ||
| number | varchar | ||
| code | varchar | ||
| type | int | ||
| parent_id | int | ||
| coord_x | int | ||
| coord_y | int | ||
| coord_system | varchar | ||
| x | int | ||
| y | int | ||
| latitude | double | ||
| longitude | double | ||
| elevation | double | ||
| coord_det_precision | int | ||
| coord_det_method | int | ||
| coord_det_agent | int | ||
| extent | int | ||
| country_id | int | ||
| maakond_id | int | ||
| vald_id | int | ||
| asustusyksus_id | int | ||
| remarks_location | varchar | ||
| depth | double | ||
| stratigraphy_base | int | ||
| stratigraphy_top | int | ||
| stratigraphy_base_free | varchar | ||
| stratigraphy_top_free | varchar | ||
| stratigraphy_start | varchar | ||
| stratigraphy_end | varchar | ||
| stratigraphy_id_start | int | ||
| stratigraphy_id_end | int | ||
| stratigraphy_free_start | varchar | ||
| stratigraphy_free_end | varchar | ||
| eelis | varchar | ||
| maaamet_pa_id | int | ||
| remarks | text | ||
| timestamp | datetime | ||
| locality_extent | varchar | ||
| locality_precision | varchar | ||
| country | varchar | ||
| stratigraphy_top_txt | varchar | ||
| stratigraphy_base_txt | varchar | ||
| link | varchar |