SPECIMEN
Contents: objects, specimens, museum objects
Description: the most important table of the database, corresponds to museum's main catalog, contains information about main objects.
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 | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| acronym | varchar | ||
| collection_number | varchar | ||
| coll | int | collection | |
| number | varchar | ||
| specimen_id | varchar | unique number of object. First part of the number is taken form the collection number where object belongs to and second part from the serial number of the object within that collection. They are separated by minus sign. If the same number is used to describe several specimens it is normally acceptable to expand the two part number (separated again by - sign, for example 225-14-1). If one specimen has several separate parts it is acceptable to expand the number, separated by # sign, for example 225-14#1. | |
| collection | collection number where the object belongs to | ||
| specimen_nr | varchar | former number of the object if it exists | |
| number_field | varchar | ||
| parent | int | specimen | |
| type | int | nature of the object: complete, complete but as parts, partially complete, thin section | list_specimen_type |
| subtype_id | int | list_specimen_subtype | |
| fossil | int | list_specimen_kind | |
| kind | int | list_specimen_kind | |
| classification | int | object type, its rank in hierarchical classification. Classification that has to be used is inserted in required detail, for fossils the lowest rank is family (subfamily). | classification |
| part | varchar | additional information about object's name or type, generally classification of part (of fossil), valve, elements etc | |
| number_pieces | int | ||
| locality | int | locality from localities that are saved in table locality | locality |
| locality_free | varchar | additional information about locality or independent locality that is not included in table locality | |
| locality_free_en | varchar | ||
| locality_is_private | tinyint | ||
| depth | double | depth of measured cross section. In case of drill holes by default traditional positive depth is used, in case of outcrops depth can also be negative, depending on the position of the benchmark. The position of the benchmark is written in outcrop's description (in table locality) or remarks box (remarks_collection) | |
| depth_interval | double | depth of measured cross section in case interval is used | |
| sample_number | varchar | sample number when object originates from numbered sample | |
| sample | int | sample | |
| remarks_collecting | varchar | ||
| stratigraphy | int | stratigraphic unit from hierarchical system | stratigraphy |
| lithostratigraphy | int | stratigraphy | |
| stratigraphy_free | varchar | ||
| agent_collected | int | collector | agent |
| agent_collected_free | varchar | ||
| date_collected | date | date of collection when exact date is known | |
| date_collected_free | varchar | date of collection when approximate date is known | |
| acquisition_type | int | how the specimen was acquired (collected, gotten as gift, bought) | |
| date_acquired | date | date of specimen acquisition when exact date is known | |
| date_acquired_free | varchar | date of specimen acquisition (collected, gotten as gift, bought) when exact date is known | |
| agent_acquired_id | int | who gave the specimen, for example donator | |
| inventariraamat | varchar | ||
| koguregister | varchar | ||
| registreeritud | date | ||
| remarks | text | additional information about specimen | |
| remarks_internal | text | ||
| tags | varchar | ||
| presence | int | information about specimen presence (present, lost, destroyed etc) | list_specimen_presence |
| location | varchar | location of object within institution/museum (cabinet, drawer, repository etc) | |
| storage | int | location | |
| status | int | status of object (no special status, original) | list_specimen_status |
| original_status | int | type of original (holotype, neotype etc) | list_specimen_original_status |
| selected | tinyint | selection of object can be either selected (-1) or not (0). This option is necessary for example when printing labels for individual objects | |
| classified | tinyint | determines if object's data is available for public usage or not (value is 0 or -1 (or 1)) | |
| 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) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | timestamp that also reflects date when data was last saved, generated by database engine | |
| specimen_full_number | varchar | ||
| attachments | int | attachment |
