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
TAXON
Referencing tables: conop_distribution | preparation | preparation_taxa | specimen_identification | taxon_common_name | taxon_description | taxon_image | taxon_list | taxon_occurrence | taxon_page | taxon_synonym | taxon_type_specimen |
Field | Database column | Data type | Description | Referenced table |
---|---|---|---|---|
author_year | author_year | varchar | ||
date_added | date_added | datetime | ||
date_changed | date_changed | datetime | ||
fossil_group | fossil_group_id | int | taxon | |
hierarchy_string | hierarchy_string | varchar | ||
id | id | int(auto increment) | ||
in_baltoscandia | in_baltoscandia | tinyint | ||
in_estonia | in_estonia | tinyint | ||
is_authorized | is_authorized | tinyint | ||
is_fossil | is_fossil | tinyint | ||
is_fossil_group | is_fossil_group | tinyint | ||
is_private | is_private | tinyint | ||
is_valid | is_valid | tinyint | ||
owner | owner | varchar | ||
parent | parent_id | int | taxon | |
rank | rank | int | taxon_rank | |
rank_original | rank_original | int | taxon_rank | |
reference | reference | int | reference | |
remarks | remarks | text | ||
sort | sort | int | ||
stratigraphy_base | stratigraphy_base | int | stratigraphy | |
stratigraphy_top | stratigraphy_top | int | stratigraphy | |
taxon | taxon | varchar | ||
taxon_epithet | taxon_epithet | varchar | ||
taxon_id_eol | taxon_id_eol | int | ||
taxon_id_nrm | taxon_id_nrm | varchar | ||
taxon_id_pbdb | taxon_id_pbdb | int | ||
taxon_id_plutof | taxon_id_plutof | int | ||
taxon_id_tol | taxon_id_tol | int | ||
taxon_original_name | taxon_original_name | varchar | ||
type_taxon | type_taxon_id | int | taxon | |
type_taxon_free | type_taxon | varchar | ||
user_added | user_added | varchar | ||
user_authorized | user_authorized | varchar | ||
user_changed | user_changed | varchar |