Explore data model:
- accession
- agent
- agent_type
- analysis
- analysis_results
- analysis_method
- attachment
- attachment_link
- classification
- classification_mineral
- classification_rock
- collection
- conop_distribution
- conop_locality
- database
- dataset
- dataset_analysis
- dataset_author
- dataset_reference
- deaccession
- device
- doi
- doi_agent
- doi_agent_type
- doi_date
- doi_date_type
- doi_geolocation
- doi_related_identifier
- doi_related_identifier_type
- doi_relation_type
- doi_resource_type
- drillcore
- drillcore_box
- drillcore_image
- drillcore_study
- group
- image
- imageset
- journal
- lab
- lab_instrument
- list_asustusyksus
- list_attachment_type
- list_classification_rank
- list_collection_type
- list_coordinate_method
- list_coordinate_precision
- list_country
- list_drillcore_storage
- list_history_type
- list_identification_type
- 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_type
- 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_reference
- locality_stratigraphy
- locality_synonym
- location
- mineral
- preparation
- preparation_taxa
- reference
- reference_keyword
- rock
- rock_classification
- rock_image
- rock_locality
- rock_tree
- rock_type
- rock_rank
- rock_synonym
- rock_mineral
- rock_mineral_type
- rock_property
- rock_type
- rock_reference
- sample
- sample_palaeontology
- sample_reference
- sample_series
- sample_series_reference
- selection
- selection_series
- soil_horizon
- soil_site
- specimen
- specimen_description
- specimen_history
- specimen_identification
- specimen_identification_geology
- specimen_image
- specimen_location
- specimen_reference
- stratigraphy
- stratigraphy_reference
- stratigraphy_stratotype
- stratigraphy_synonym
- taxon
- taxon_common_name
- taxon_description
- taxon_image
- taxon_list
- taxon_occurrence
- taxon_page
- taxon_rank
- taxon_synonym
- taxon_type_specimen
- taxon_type_type
- user_group
- visit
ROCK_MINERAL_TYPE
Referencing tables: rock_mineral |
| Field | Database column | Data type | Description | Referenced table |
|---|---|---|---|---|
| id | id | int(auto increment) | ||
| name | name | varchar | ||
| name_en | name_en | varchar | ||
| remarks | remarks | text |
If not indicated otherwise, content of the these pages may be used, reused and distributed for non-commercial purposes taken that original author and source are cited.
Questions and comments about the database and website: Olle Hints, Institute of Geology at Tallinn University of Technology, olle.hints@ttu.ee