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)
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