SPECIMEN
Referencing tables: analysis | attachment | attachment_link | loan_specimen | sample | selection | specimen_description | specimen_history | specimen_identification | specimen_identification_geology | specimen_image | specimen_location | specimen_reference | taxon_type_specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| acronym | varchar | ||
| collection_number | varchar | ||
| coll | int | collection | |
| number | varchar | ||
| specimen_id | varchar | ||
| collection | |||
| specimen_nr | varchar | ||
| number_field | varchar | ||
| parent | int | specimen | |
| type | int | list_specimen_type | |
| subtype_id | int | list_specimen_subtype | |
| fossil | int | list_specimen_kind | |
| kind | int | list_specimen_kind | |
| classification | int | classification | |
| part | varchar | ||
| number_pieces | int | ||
| locality | int | locality | |
| locality_free | varchar | ||
| locality_free_en | varchar | ||
| locality_is_private | tinyint | ||
| depth | double | ||
| depth_interval | double | ||
| sample_number | varchar | ||
| sample | int | sample | |
| remarks_collecting | varchar | ||
| stratigraphy | int | stratigraphy | |
| lithostratigraphy | int | stratigraphy | |
| stratigraphy_free | varchar | ||
| agent_collected | int | agent | |
| agent_collected_free | varchar | ||
| date_collected | date | ||
| date_collected_free | varchar | ||
| acquisition_type | int | ||
| date_acquired | date | ||
| date_acquired_free | varchar | ||
| agent_acquired_id | int | ||
| inventariraamat | varchar | ||
| koguregister | varchar | ||
| registreeritud | date | ||
| remarks | text | ||
| remarks_internal | text | ||
| tags | varchar | ||
| presence | int | list_specimen_presence | |
| location | varchar | ||
| storage | int | location | |
| status | int | list_specimen_status | |
| original_status | int | list_specimen_original_status | |
| selected | tinyint | ||
| classified | tinyint | ||
| is_private | tinyint | ||
| accession | int | accession | |
| deaccession | int | deaccession | |
| database | int | database | |
| uid | int | ||
| gid | int | ||
| permissions | int | ||
| id_tug | int | ||
| id_elm | int | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| specimen_full_number | varchar | ||
| attachments | int | attachment |
