SAMPLE
Referencing tables: agent | analysis | attachment | attachment_link | database | loan_sample | locality | location | preparation | project | rock | schema_sampleuserobjectpermission | schema_samplegroupobjectpermission | sample_reference | sample_series | list_sample_purpose | site | specimen | stratigraphy | taxon_list | selection |
| 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 | ||
| igsn | varchar | ||
| series | int | sample_series | |
| parent_sample | int | sample | |
| parent_specimen | int | specimen | |
| sample_purpose | int | list_sample_purpose | |
| sample_type | varchar | ||
| locality | int | locality | |
| site | int | site | |
| project | int | project | |
| locality_free | varchar | ||
| latitude1 | double | ||
| longitude1 | double | ||
| x1 | int | ||
| y1 | int | ||
| epsg | int | ||
| coordinate_accuracy | int | ||
| depth | double | ||
| depth_interval | double | ||
| stratigraphy | int | stratigraphy | |
| lithostratigraphy | int | stratigraphy | |
| stratigraphy_free | varchar | ||
| stratigraphy_bed | varchar | ||
| soil_horizon | varchar | ||
| agent_collected | int | agent | |
| agent_collected_free | varchar | ||
| date_collected | date | ||
| date_collected_free | varchar | ||
| classification_rock | int | rock | |
| rock | varchar | ||
| rock_en | varchar | ||
| fossils | varchar | ||
| palaeontology | tinyint | ||
| analysis | tinyint | ||
| mass | int | ||
| location | varchar | ||
| location_additional | varchar | ||
| storage | int | location | |
| storage_additional | int | location | |
| remarks | text | ||
| owner | int | agent | |
| is_private | tinyint | ||
| database | int | database | |
| id | int(auto increment) | ||
| attachments | int | attachment |
