Magnetics Information Consortium (MagIC) -- Standard MagIC Data Format -- Data Model -- Version 2.5

Magnetics Information Consortium (MagIC)
Development and Maintenance by the EarthRef.org Database Team

Standard MagIC Data Format -- Data Model -- Version 2.5

N	Table Name	Oracle Name	Geology	Archeology	Drilling	Oceans	Synthetics	Description
Click to expand the Data Model Diagram
1	Contributions	magic_contributions	Contribution	Contribution	Contribution	Contribution	Contribution	Contritubtion upload settings (reference, activation state, group settings)
28	Selection Criteria	rmag_criteria	Criteria	Criteria	Criteria	Criteria	Criteria	Selection criteria used in data selection
27	Results	rmag_results	Derived Data	Derived Data	Derived Data	Derived Data	Derived Data	Summary results and highly derived data products (critical temperatures, etc)
16	Calibrations	magic_calibrations	Description	Description	Description	Description	Description	Calibrations
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
15	Measurements	magic_measurements	Raw Data	Raw Data	Raw Data	Raw Data	Raw Data	Analytical data or measurements
11	Synthetic Materials	er_synthetics	Synthetic Material	Synthetic Material	Synthetic Material	Synthetic Material	Synthetic Material	Synthetic material that is not necessarily related to geology
7	Samples	er_samples	Sample	Object	Sample	Sample		Sample from site
17	Specimen Data	pmag_specimens	Subsample	Pieces	Subsample	Subsample		Specimen from sample
18	Sample Data	pmag_samples	Sample	Object	Sample	Sample		Sample from site
9	Fossils	er_fossils	Fossil		Fossil	Fossil		Taxon or fossil
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
6	Sites	er_sites	Rock Unit	Building / Kiln	Horizon / Layer	Rock Group / Unit		Unique rock unit in terms of geological age
5	Rock Member	er_members	Rock Member					Unique rock member or section
4	Rock Formations	er_formations	Rock Formation					Unique rock formation or sequence
3	Locations	er_locations	Location / Section	Camp / Village	Drill Site	Dredge / Dive Site		Location definition
2	Expeditions	er_expeditions	Fieldwork	Fieldwork	Fieldwork / Cruise	Cruise		Expedition, fieldwork or cruise definition
8	Specimens	er_specimens	Subsample	Pieces	Subsample	Subsample		Specimen from sample
12	Ages Determinations	er_ages	Ages	Ages	Ages	Ages		Ages for discrete samples or horizons in stratigraphic sections or cores
10	Minerals	er_minerals	Mineral		Mineral	Mineral		Naturally occurring minerals
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