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