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

STRATIGRAPHY

Contents: stratigraphic classifications

Referencing tables: classification | collection | drillcore_box | list_stratigraphy_rank | list_stratigraphy_scope | list_stratigraphy_status | list_stratigraphy_type | locality | locality_description | locality_stratigraphy | reference | rock | sample | sample_series | specimen | stratigraphy_reference | stratigraphy_stratotype | stratigraphy_synonym | taxon | taxon_occurrence | taxon_type_specimen |


Field Data type Description Referenced table
stratigraphy varchar name of stratigraphic unit, to avoid confusion it is always used together with unit except for system and higher rank units
stratigraphy_en varchar name of stratigraphic unit in English
stratigraphy_original varchar name in original publication
author_free varchar
year int Year of the name given, does not necessarily coincide with original publication
etymon varchar
etymon_en varchar
original_locality varchar
original_rank varchar
index_main varchar Unit index in HTML format, Schmidt index when using Estonian schema
index_main_html varchar
index_additional varchar Additional index for stratigraphic unit in HTML format, EGK index when using Estonian schema
index_additional_html varchar
index_old varchar
color_code_cgmw varchar
color_code_additional varchar hexadecimal RGB color code (for example white - ffffff, yellow - ffff00), for international units alternative USGS color palette is used
hierarchy_string varchar
parent int hierarchy code for unit one rank higher (parent) stratigraphy
type int type of unit, with options: chronostratigraphy, lithostratigraphy, biostratigraphy etc list_stratigraphy_type
rank int rank in hierarchy depending on type of stratigraphy, available options when using lithostratigraphic unit: group, formation, member, bed list_stratigraphy_rank
scope int geographic extent of the unit and its usability; available options: global, basin (paleocontinent), regional (region on a continent), local (limited area) list_stratigraphy_scope
status int status of the unit, available options: formally defined (global units defined by GSSP), formally approved, list_stratigraphy_status
region varchar üksuse kasutatavuse piirkond
region_en varchar
lithology varchar litoloogia lühiiseloomustus
lithology_en varchar
max_thickness double
description text üksuse lühikirjeldus, tutvustus või iseloomustus
description_en text
definition text üksuse definitsioon
definition_en text
age_base double alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega- aastad (Ma, miljon aastat)
age_top double alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega- aastad (Ma, miljon aastat)
age_precision double alumise piiri vanus, kasutatakse ainult kronostratigraafiliste üksuste puhul, ühikuks mega-aastad (Ma, miljon aastat)
age_reference int viide antud vanusemäärangule reference
age_chronostratigraphy int vanus, lito- jm. ühikute puhul. väikseima mahuga kronostrt. üksus kuhu antud üksus mahub stratigraphy
sort_within_parent int
approved_ics tinyint
approved_esk tinyint
maaamet_kood int
is_private tinyint
remarks text lisainfo vabas vormis
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
id int(auto increment) Automatically generated unique sequential primary key (record ID)