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