DATABASE SCHEMA

Explore data model:

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: attachment_link | sample | specimen_description | specimen_history | specimen_identification | specimen_identification_geology | specimen_image | specimen_location | specimen_reference | taxon_type_specimen |


Field Database column Data type Description Referenced table
accession akt_vastuvott_id int accession
agent_collected agent_collected int collector agent
agent_collected_free agent_collected_free varchar
classification class_id 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
classified classified int determines if object's data is available for public usage or not (value is 0 or -1 (or 1)) list_visibility
coll coll_id int collection
collection collection_id int collection number where the object belongs to
database database_id int database
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
date_collected date_collected date date of collection when exact date is known
date_collected_free date_collected_free varchar date of collection when approximate date is known
deaccession akt_mahakandmine_id int deaccession
depth 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 depth_interval double depth of measured cross section in case interval is used
fossil fossil int list_specimen_kind
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
lithostratigraphy lithostratigraphy_id int stratigraphy
locality locality int locality from localities that are saved in table locality locality
locality_free locality_free varchar additional information about locality or independent locality that is not included in table locality
location location varchar location of object within institution/museum (cabinet, drawer, repository etc)
number_field number_field varchar
original_status original_status int type of original (holotype, neotype etc) list_specimen_original_status
part part varchar additional information about object's name or type, generally classification of part (of fossil), valve, elements etc
presence presence int information about specimen presence (present, lost, destroyed etc) list_specimen_presence
remarks remarks text additional information about specimen
remarks_collecting remarks_collecting varchar
remarks_internal remarks_internal text
sample sample int sample
sample_number sample_number varchar sample number when object originates from numbered sample
specimen_id 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.
specimen_nr specimen_nr varchar former number of the object if it exists
status status int status of object (no special status, original) list_specimen_status
storage storage_id int location
stratigraphy stratigraphy_id int stratigraphic unit from hierarchical system stratigraphy
stratigraphy_free stratigraphy_free varchar
tags tags varchar
type type int nature of the object: complete, complete but as parts, partially complete, thin section list_specimen_type
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record