Magnetics Information Consortium (MagIC)
Development and Maintenance by the EarthRef.org Database Team

Standard MagIC Data Format -- Data Model -- Version 2.3
Click to expand the Data Model Diagram
MagIC Data Model
N Table Name Oracle Name Geology Archeology Drilling Oceans Description
1 Expeditions ER_Expeditions Fieldwork Fieldwork Fieldwork / Cruise Cruise Expedition, fieldwork or cruise definition
2 Locations ER_Locations Location / Section Camp / Village Drill Site Dredge / Dive Site Location definition
3 Rock Formations ER_Formations Rock Formation Unique rock formation or sequence
4 Rock Member ER_Members Rock Member Unique rock member or section
5 Sites ER_Sites Rock Unit Building / Kiln Horizon / Layer Rock Group / Unit Unique rock unit in terms of geological age
6 Samples ER_Samples Sample Object Sample Sample Sample from site
7 Specimens ER_Specimens Subsample Pieces Subsample Subsample Specimen from sample
8 Fossils ER_Fossils Fossil Fossil Fossil Taxon or fossil
9 Minerals ER_Minerals Mineral Mineral Mineral Naturally occurring minerals
10 Synthetic Materials ER_Synthetics Synthetic material that is not necessarily related to geology
11 Ages Determinations ER_Ages Ages Ages Ages Ages Ages for discrete samples or horizons in stratigraphic sections or cores
12 Citations List ER_Citations Reference Reference Reference Reference List of references
13 Mailing List Contributors ER_Mailinglist Name / Address Name / Address Name / Address Name / Address List of addresses
14 Images ER_Images Images Images Images Images List of images and photographs
15 Measurements MAGIC_Measurements Raw Data Raw Data Raw Data Raw Data Analytical data or measurements
16 Methods MAGIC_Methods Description Description Description Description Controlled vocabulary of sampling, laboratory and statistical techniques
17 Instruments MAGIC_Instruments Description Description Description Description Instrument info based on institute, year of build and instrument name
18 Calibrations MAGIC_Calibrations Description Description Description Description Calibrations
19 Specimen Data PMAG_Specimens Subsample Pieces Subsample Subsample Specimen from sample
20 Sample Data PMAG_Samples Sample Object Sample Sample Sample from site
21 Site Data PMAG_Sites Rock Unit Building / Kiln Horizon / Layer Horizon / Layer Unique rock unit in terms of magnetization and geological age
22 Results PMAG_Results Derived Data Derived Data Derived Data Derived Data Summary results and highly derived data products (stacks, poles, etc)
23 Rotation Data PMAG_Rotations Rotation Data Rotation Data Rotation Data Rotation Data Data used to perform complex rotations between coordinate systems
24 Selection Criteria PMAG_Criteria Criteria Criteria Criteria Criteria Selection criteria used in data selection
25 Susceptibility Experiments RMAG_Susceptibility Experiment Data Experiment Data Experiment Data Experiment Data Experiment for susceptibility parameters
26 Remanence Experiments RMAG_Remanence Experiment Data Experiment Data Experiment Data Experiment Data Experiment for magnetic remanence: ARM, IRM, TRM, CRM, VRM and DRM
27 Hysteresis Experiments RMAG_Hysteresis Experiment Data Experiment Data Experiment Data Experiment Data Experiment for hysteresis loops and FORCs
28 Anisotropy Experiments RMAG_Anisotropy Experiment Data Experiment Data Experiment Data Experiment Data Experiment for anisotropy parameters
29 Results RMAG_Results Derived Data Derived Data Derived Data Derived Data Summary results and highly derived data products (critical temperatures, etc)
30 Selection Criteria RMAG_Criteria Criteria Criteria Criteria Criteria Selection criteria used in data selection
Standard MagIC Data Format v2.0
Standard MagIC Data Format v2.1
Standard MagIC Data Format v2.2
Standard MagIC Data Format v2.3
Standard MagIC Data Format v2.4
Standard MagIC Data Format v2.5
Standard MagIC Data Format v3.0
Click to return to previous page