EUROCORE database architecture and components
About
Main data objects
- age
- agent
- agent_type
- alteration_age
- alteration_stage
- alteration_style
- analysis
- analysis_method
- analysis_result
- attachment
- attachment_type
- classification_mineral
- classification_rock
- color
- color_attribute
- dataset
- deposit
- dip
- drillcore
- drillcore_box
- drillcore_interval
- drillcore_diameter
- grain_size
- lab
- lab_instrument
- lithology
- mime_type
- mineralization_alteration
- mineralization_type
- mineral_occurrence
- ore_genetic_type
- ore_metal_group
- ore_metal_subgroup
- parameter
- reference
- reference_type
- rock_occurrence_type
- rqd
- sample
- spectrum
- spectrum_range
- storage
- structure
- structure_type
- teaching_module
- unit
- weathering_degree
reference
Contents:
Description:
Referencing tables: deposit drillcore reference_type
| Field | Database column | Data type | Description | Referenced table |
|---|---|---|---|---|
| id | id | int(auto increment) | ||
| reference | reference | varchar | ||
| author | author | varchar | ||
| year | year | varchar | ||
| reference_type | reference_type | int | reference_type | |
| title | title | text | ||
| title_original | title_original | text | ||
| book | book | varchar | ||
| publisher | publisher | varchar | ||
| publisher_place | publisher_place | varchar | ||
| journal_txt | journal | varchar | ||
| volume | volume | varchar | ||
| number | number | varchar | ||
| pages | pages | varchar | ||
| doi | doi | varchar | ||
| url | url | varchar | ||
| abstract | abstract | text | ||
| tags | tags | varchar | ||
| remarks | remarks | text | ||
| public | public | tinyint | ||
| date_added | date_added | datetime | ||
| date_changed | date_changed | datetime |