DATABASE SCHEMA

Explore data model:

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 | preparation | sample | specimen | specimen_location |


Field Database column Data type Description Referenced table
agent agent int materjali koguja kood kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud agent
contents contents varchar Brief description of what is being stored in this location; especially important if individual objects are not yet electronically catalogued
database database_id int database
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime Timestamp of last change
date_collected_free date_collected_free varchar materjali kogumise aeg kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
location location varchar Unique code for storage location within an institution
location_location location_location varchar Parent storage location (e.g., room code where a box is stored)
number_items number_items int Number of items; important if contents not catalogues on item basis
remarks remarks text Notes and information not fitting elsewhere
stratigraphy_free stratigraphy_free varchar stratigraafia kasutatakse eriti juhul kui sisu pole eraldi objektidena / proovidena arvele võetud
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record