SAMPLE
Referencing tables: analysis | attachment_link | conop_distribution | loan_sample | preparation | preparation_taxa | sample_reference | selection | specimen | taxon_list |
| 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 | |
| locality | int | locality | |
| site | int | site | |
| project | int | project | |
| locality_free | varchar | ||
| soil_site | int | soil_site | |
| 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 | ||
| stratigraphy_bed_thickness | double | ||
| soil_horizon | varchar | ||
| agent_collected | int | agent | |
| agent_collected_free | varchar | ||
| date_collected | date | ||
| date_collected_free | varchar | ||
| sample_type | varchar | ||
| classification_rock | int | rock | |
| rock_id | int | rock | |
| rock | text | ||
| rock_en | varchar | ||
| fossils | text | ||
| palaeontology | tinyint | ||
| analysis | tinyint | ||
| mass | int | ||
| location | varchar | ||
| location_additional | varchar | ||
| storage | int | location | |
| storage_additional | int | location | |
| remarks | text | ||
| remarks_en | text | ||
| custom_field1 | varchar | ||
| custom_field1_value | varchar | ||
| custom_field2 | varchar | ||
| custom_field2_value | varchar | ||
| timestamp_created | datetime | ||
| timestamp_updated | datetime | ||
| database | int | database | |
| owner | int | agent | |
| is_private | tinyint | ||
| public | tinyint | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| id_temp | varchar | ||
| attachments | int | attachment |
