SARV: geoscience data and collections

Database Schema

Explore schema:

accession
agent
agent_type
analysis
analysis_method
analysis_parameter
analysis_results
archive
area
area_egf
area_type
attachment
attachment_keyword
attachment_link
classification
classification_mineral
classification_rock
collection
conop_distribution
conop_locality
conop_stratigraphy
database
dataset
dataset_analysis
dataset_author
dataset_geolocation
dataset_reference
deaccession
description_parameter
device
doi
doi_agent
doi_agent_type
doi_date
doi_date_type
doi_geolocation
doi_link
doi_publisher
doi_related_identifier
doi_related_identifier_type
doi_relation_type
doi_resource_type
drillcore
drillcore_box
drillcore_image
drillcore_study
ermas_analysis
ermas_analysis_results
ermas_locality
ermas_locality_reference
ermas_locality_summary
ermas_reference
ermas_sample
ermas_taxon_occurrence
file_collection
image
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_category
list_image_type
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_subtype
list_specimen_type
list_stratigraphy_rank
list_stratigraphy_scope
list_stratigraphy_status
list_stratigraphy_type
list_stratotype_type
list_unit
list_vald
list_visibility
loan
loan_sample
loan_specimen
locality
locality_description
locality_description_extension
locality_image
locality_parameter
locality_reference
locality_reference_egf
locality_sarv_ma
locality_stratigraphy
locality_summary
locality_synonym
locality_taxon
location
log
maavara_koondbilanss
maavara_maardla
maavara_maeeraldis
maavara_plokk
maavara_uuringuala
peat_analysis
peat_area
peat_sample
peat_site
preparation
preparation_taxa
project
project_agent
project_site
project_type
reference
reference_author
reference_category
reference_egf
reference_keyword
reference_keyword_egf
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_palaeontology
sample_reference
sample_series
sample_series_reference
sample_summary
sarv_fields
sarv_tables
selection
selection_series
site
site_groundwater
site_summary
site_type
soil_horizon
soil_site
specimen
specimen_description
specimen_history
specimen_identification
specimen_identification_geology
specimen_image
specimen_location
specimen_reference
specimen_union
specimen_union_image
stratigraphy
stratigraphy_reference
stratigraphy_stratotype
stratigraphy_synonym
taxon
taxon_character
taxon_character_key
taxon_character_state
taxon_common_name
taxon_description
taxon_image
taxon_list
taxon_occurrence
taxon_opinion
taxon_opinion_type
taxon_page
taxon_pbdb
taxon_rank
taxon_search
taxon_simple_search
taxon_synonym
taxon_type_specimen
taxon_type_type
visit

DATASET_ANALYSIS

Referencing tables: None


Field Data type Description Referenced table
user_added varchar
date_added datetime
user_changed varchar
date_changed datetime
dataset int dataset
analysis int analysis
remarks text
id int(auto increment)
timestamp datetime