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