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