ANALYSIS
Referencing tables: analysis_results | attachment_link | dataset_analysis | preparation | selection | taxon_list |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| sample | int | sample | |
| sample_id_temp | varchar | ||
| specimen | int | specimen | |
| dataset | int | dataset | |
| reference | int | reference | |
| locality | int | locality | |
| depth | double | ||
| depth_interval | double | ||
| analysis_method | int | analysis_method | |
| method_details | varchar | ||
| method_details_en | varchar | ||
| parent_analysis_id | int | ||
| material | varchar | ||
| mass | double | ||
| mass_unit | varchar | ||
| counts | int | ||
| date | date | ||
| date_end | date | ||
| date_free | varchar | ||
| lab | int | lab | |
| lab_txt | varchar | ||
| lab_sample_number | varchar | ||
| lab_analysis_number | varchar | ||
| instrument | int | lab_instrument | |
| instrument_txt | varchar | ||
| agent | int | agent | |
| agent_txt | varchar | ||
| owner | int | agent | |
| private | int | ||
| is_private | tinyint | ||
| location | varchar | ||
| storage | int | location | |
| remarks | text | ||
| database | int | database | |
| id | int(auto increment) | ||
| id_sample_palaeontology | int | ||
| timestamp | datetime | ||
| acquisition_params | |||
| attachments | int | attachment |
