Referencing tables: None
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| number | varchar | ||
| number_additional | varchar | ||
| number_field | varchar | ||
| series_id | int | ||
| parent_sample_id | int | ||
| parent_specimen_id | int | ||
| sample_purpose | int | ||
| locality_id | int | ||
| locality_free | varchar | ||
| soil_site_id | int | ||
| latitude1 | double | ||
| longitude1 | double | ||
| x1 | int | ||
| y1 | int | ||
| epsg | int | ||
| coordinate_accuracy | int | ||
| depth | double | ||
| depth_interval | double | ||
| stratigraphy_id | int | ||
| lithostratigraphy_id | int | ||
| stratigraphy_free | varchar | ||
| stratigraphy_bed | varchar | ||
| stratigraphy_bed_thickness | double | ||
| soil_horizon | varchar | ||
| agent_collected_id | int | ||
| agent_collected_free | varchar | ||
| date_collected | date | ||
| date_collected_free | varchar | ||
| sample_type | varchar | ||
| classification_rock_id | int | ||
| rock | text | ||
| rock_en | varchar | ||
| fossils | text | ||
| palaeontology | int | ||
| analysis | int | ||
| mass | int | ||
| location | varchar | ||
| location_additional | varchar | ||
| remarks | text | ||
| remarks_en | text | ||
| database_id | int | ||
| owner_id | int | ||
| public | int | ||
| timestamp | datetime | ||
| id_temp | varchar | ||
| stratigraphy | varchar | ||
| lithostratigraphy | varchar | ||
| link | varchar |