LOCALITY_DESCRIPTION
Referencing tables: attachment_link | locality_description_extension |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| locality | int | locality | |
| site | int | site | |
| depth_base | double | ||
| depth_base_interval | double | ||
| depth_base_min | double | ||
| depth_base_max | double | ||
| depth_top | double | ||
| depth_top_interval | double | ||
| depth_top_min | double | ||
| depth_top_max | double | ||
| thickness | varchar | ||
| zero_level | varchar | ||
| has_reversed_scale | tinyint | ||
| rock | int | rock | |
| rock_name | varchar | ||
| rock_name_en | varchar | ||
| description | text | ||
| keywords | varchar | ||
| language | int | list_language | |
| stratigraphy | int | stratigraphy | |
| stratigraphy_free | varchar | ||
| agent | int | agent | |
| author_free | varchar | ||
| year | varchar | ||
| reference | int | reference | |
| remarks | text | ||
| is_preferred | tinyint | ||
| is_private | tinyint | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment |
