SPECIMEN
Referencing tables: accession | agent | analysis | attachment | attachment_link | classification | collection | database | deaccession | loan_specimen | locality | location | sample | schema_specimenuserobjectpermission | schema_specimengroupobjectpermission | specimen_description | specimen_history | specimen_identification | specimen_identification_geology | specimen_image | specimen_location | specimen_reference | list_specimen_kind | list_specimen_original_status | list_specimen_presence | list_specimen_status | list_specimen_type | list_specimen_subtype | stratigraphy | taxon_type_specimen | selection |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| specimen_id | varchar | ||
| specimen_full_number | varchar | ||
| collection | int | ||
| coll | int | collection | |
| specimen_nr | varchar | ||
| number_field | varchar | ||
| 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 | |
| parent | int | specimen | |
| 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 | ||
| remarks | text | ||
| remarks_internal | text | ||
| tags | varchar | ||
| presence | int | list_specimen_presence | |
| storage | int | location | |
| location | varchar | ||
| status | int | list_specimen_status | |
| original_status | int | list_specimen_original_status | |
| is_private | tinyint | ||
| database | int | database | |
| id | int(auto increment) | ||
| accession | int | accession | |
| deaccession | int | deaccession | |
| attachments | int | attachment |
