SAMPLE
Contents: rock and sediment samples
Description: This tables holds data on various rock, sediment and environmental samples, collected for different purposes, e.g., microfossil extraction or geochemical analysis. In many cases the original sample material may not be present any more. However, there may be various derivatives such as microfossil preparations, individual numbered specimens, analytical data results etc. Partly the SAMPLE table copies SPECIMEN, however, the physical objects in the latter are meant for perpetual storage, have unique number and names.
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 | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| number | varchar | proovi number | |
| number_additional | varchar | proovi eelmine number | |
| 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 | leiukoht tabelis locality salvestatud lokaliteetide hulgast | locality |
| site | int | site | |
| project | int | project | |
| locality_free | varchar | leiukoha täiendav info või iseseisev lokaliteet mis ei sisaldu tabelis locality | |
| soil_site | int | soil_site | |
| latitude1 | double | ||
| longitude1 | double | ||
| x1 | int | ||
| y1 | int | ||
| epsg | int | ||
| coordinate_accuracy | int | ||
| depth | double | ||
| depth_interval | double | sügavus mõõdetud läbilõike korral kui kasutatakse intervalli | |
| stratigraphy | int | stratigraafiline üksus hierarhilisest süsteemist | stratigraphy |
| lithostratigraphy | int | litostratigraafilise üksuse ID | stratigraphy |
| stratigraphy_free | varchar | ||
| stratigraphy_bed | varchar | ||
| stratigraphy_bed_thickness | double | ||
| soil_horizon | varchar | ||
| agent_collected | int | collector | agent |
| agent_collected_free | varchar | ||
| date_collected | date | kogumise aeg kui on teada täpne kuupäev | |
| date_collected_free | varchar | kogumise aeg kui on teada umbmäärane aeg | |
| sample_type | varchar | ||
| classification_rock | int | formal rock or sediment name from list | rock |
| rock_id | int | rock | |
| rock | text | kivimi tüüp, lühiiseloomustus | |
| rock_en | varchar | ||
| fossils | text | fauna lühiiseloomustus | |
| palaeontology | tinyint | kas on tehtud paleonltoloogiline uuring (ei (0) või jah (-1)) | |
| analysis | tinyint | kas on tehtud mineral., litol. keemil. vm uuring (ei (0) või jah (-1)) | |
| mass | int | Weight of physical sample still present (in grams) | |
| location | varchar | storage location | |
| location_additional | varchar | ||
| storage | int | location | |
| storage_additional | int | location | |
| remarks | text | any additional information | |
| 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) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor | |
| id_temp | varchar | ||
| attachments | int | attachment |
