SARV: geoscience data and collections

Database Schema

Explore schema:

accession
agent
agent_type
analysis
analysis_method
analysis_parameter
analysis_results
area
area_type
attachment
attachment_keyword
attachment_link
classification
collection
conop_distribution
conop_locality
conop_stratigraphy
database
dataset
dataset_analysis
dataset_author
dataset_geolocation
dataset_reference
deaccession
device
doi
doi_agent
doi_agent_type
doi_date
doi_date_type
doi_geolocation
doi_publisher
doi_related_identifier
doi_related_identifier_type
doi_relation_type
doi_resource_type
drillcore
drillcore_box
drillcore_study
imageset
journal
keyword
keyword_category
keyword_relation
keyword_relation_type
lab
lab_instrument
library
library_agent
library_reference
list_asustusyksus
list_attachment_type
list_classification_rank
list_collection_type
list_coordinate_method
list_coordinate_precision
list_country
list_drillcore_storage
list_element
list_history_type
list_identification_type
list_image_type
list_image_category
list_language
list_licence
list_loan_delivery_method
list_loan_type
list_locality_extent
list_locality_reference_type
list_locality_type
list_maakond
list_mime_type
list_palaeontology_method
list_reference_type
list_sample_purpose
list_specimen_kind
list_specimen_original_status
list_specimen_presence
list_specimen_status
list_specimen_type
list_specimen_subtype
list_stratigraphy_rank
list_stratigraphy_scope
list_stratigraphy_status
list_stratigraphy_type
list_stratotype_type
list_unit
list_vald
list_visibility
loan
loan_specimen
loan_sample
locality
locality_description
locality_reference
locality_stratigraphy
locality_summary
locality_synonym
location
log
preparation
project
project_agent
project_site
project_type
reference
reference_keyword
rock
rock_classification
rock_element
rock_image
rock_locality
rock_mineral
rock_mineral_type
rock_property
rock_property_type
rock_rank
rock_reference
rock_synonym
rock_tree
rock_type
sample
sample_reference
sample_series
sample_series_reference
selection
selection_series
site
site_groundwater
site_type
soil_horizon
soil_site
specimen
specimen_description
specimen_history
specimen_identification
specimen_identification_geology
specimen_image
specimen_location
specimen_reference
specimen_union
stratigraphy
stratigraphy_reference
stratigraphy_stratotype
stratigraphy_synonym
taxon
taxon_common_name
taxon_description
taxon_image
taxon_list
taxon_occurrence
taxon_opinion
taxon_opinion_type
taxon_page
taxon_rank
taxon_search
taxon_simple_search
taxon_synonym
taxon_type_specimen
taxon_type_type
visit
web_counter
web_news

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: accession | agent | analysis | attachment | attachment_link | classification | collection | database | deaccession | list_specimen_kind | list_specimen_original_status | list_specimen_presence | list_specimen_status | list_specimen_type | list_specimen_subtype | loan_specimen | locality | location | sample | selection | specimen_description | specimen_history | specimen_identification | specimen_identification_geology | specimen_image | specimen_location | specimen_reference | stratigraphy | taxon_type_specimen |


Field Data type Description Referenced table
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 int collection number where the object belongs to
coll int collection
specimen_nr varchar former number of the object if it exists
number_field varchar
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
parent int specimen
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
remarks text additional information about specimen
remarks_internal text
tags varchar
presence int information about specimen presence (present, lost, destroyed etc) list_specimen_presence
storage int location
location varchar location of object within institution/museum (cabinet, drawer, repository etc)
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
is_private tinyint
accession int accession
deaccession int deaccession
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
database int database
id int(auto increment) Automatically generated unique sequential primary key (record ID)