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

Standard MagIC Data Format -- Data Model -- Version 2.5
Click to expand the Data Model Diagram
MagIC Data Model
N Table Name Oracle Name Geology Archeology Drilling Oceans Synthetics Description
1 Contributions magic_contributions Contribution Contribution Contribution Contribution Contribution Contritubtion upload settings (reference, activation state, group settings)
2 Expeditions er_expeditions Fieldwork Fieldwork Fieldwork / Cruise Cruise Expedition, fieldwork or cruise definition
3 Locations er_locations Location / Section Camp / Village Drill Site Dredge / Dive Site Location definition
4 Rock Formations er_formations Rock Formation Unique rock formation or sequence
5 Rock Member er_members Rock Member Unique rock member or section
6 Sites er_sites Rock Unit Building / Kiln Horizon / Layer Rock Group / Unit Unique rock unit in terms of geological age
7 Samples er_samples Sample Object Sample Sample Sample from site
8 Specimens er_specimens Subsample Pieces Subsample Subsample Specimen from sample
9 Fossils er_fossils Fossil Fossil Fossil Taxon or fossil
10 Minerals er_minerals Mineral Mineral Mineral Naturally occurring minerals
11 Synthetic Materials er_synthetics Synthetic Material Synthetic Material Synthetic Material Synthetic Material Synthetic Material Synthetic material that is not necessarily related to geology
12 Ages Determinations er_ages Ages Ages Ages Ages Ages for discrete samples or horizons in stratigraphic sections or cores
13 Plots er_plots Plots Plots Plots Plots Plots List of plots
14 Images er_images Images Images Images Images Images List of images and photographs
15 Measurements magic_measurements Raw Data Raw Data Raw Data Raw Data Raw Data Analytical data or measurements
16 Calibrations magic_calibrations Description Description Description Description Description Calibrations
17 Specimen Data pmag_specimens Subsample Pieces Subsample Subsample Specimen from sample
18 Sample Data pmag_samples Sample Object Sample Sample Sample from site
19 Site Data pmag_sites Rock Unit Building / Kiln Horizon / Layer Horizon / Layer Unique rock unit in terms of magnetization and geological age
20 Results pmag_results Derived Data Derived Data Derived Data Derived Data Summary results and highly derived data products (stacks, poles, etc)
21 Rotation Data pmag_rotations Rotation Data Rotation Data Rotation Data Rotation Data Data used to perform complex rotations between coordinate systems
22 Selection Criteria pmag_criteria Criteria Criteria Criteria Criteria Selection criteria used in data selection
23 Susceptibility Experiments rmag_susceptibility Experiment Data Experiment Data Experiment Data Experiment Data Experiment Data Experiment for susceptibility parameters
24 Remanence Experiments rmag_remanence Experiment Data Experiment Data Experiment Data Experiment Data Experiment Data Experiment for magnetic remanence: ARM, IRM, TRM, CRM, VRM and DRM
25 Hysteresis Experiments rmag_hysteresis Experiment Data Experiment Data Experiment Data Experiment Data Experiment Data Experiment for hysteresis loops and FORCs
26 Anisotropy Experiments rmag_anisotropy Experiment Data Experiment Data Experiment Data Experiment Data Experiment Data Experiment for anisotropy parameters
27 Results rmag_results Derived Data Derived Data Derived Data Derived Data Derived Data Summary results and highly derived data products (critical temperatures, etc)
28 Selection Criteria rmag_criteria 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