LOCATION
Contents: "address book" for storage locations
Description: This table holds records of various locations for storing physical collection objects (such as samples, specimens, drillcores etc), starting from storage buildings and rooms down to individual boxes, shelves, drawers and even SEM stubs, each of which is numbered by unique code within an institution.
Referencing tables: analysis | attachment_link | drillcore | drillcore_box | image | imageset | preparation | sample | sample_palaeontology | specimen | specimen_location |
| 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 | Timestamp of last change | |
| location | varchar | Unique code for storage location within an institution | |
| location_new | varchar | ||
| location_old | varchar | ||
| location_location | varchar | Parent storage location (e.g., room code where a box is stored) | |
| parent_location | int | location | |
| contents | text | Brief description of what is being stored in this location; especially important if individual objects are not yet electronically catalogued | |
| agent | int | materjali koguja kood kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud | agent |
| date_collected_free | varchar | materjali kogumise aeg kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud | |
| stratigraphy_free | varchar | stratigraafia kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud | |
| number_items | int | Number of items; important if contents not catalogues on item basis | |
| number_items_registered | int | ||
| selected | tinyint | ||
| remarks | text | Notes and information not fitting elsewhere | |
| database | int | database | |
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ||
| attachments | int | attachment |
