Click to expand the Data Model Diagram
|
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
|