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

Standard MagIC Data Format -- ER_Synthetics Table -- Version 2.5
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
2 Synthetic Material Name Alternatives er_synthetic_alternatives Text Optional Colon-delimited list of alternative names and abbreviations
R 26 Citation Names er_citation_names Text Required Colon-delimited list of citation DOIs Examples are: 10.1029/92JB01202, 10.1029/2003GC000635:This study, "10.1023/A:1015035228810":This study
R 24 Method Codes magic_method_codes Text Recommended Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R 25 Research Scientist Names er_scientist_mail_names Text Recommended Colon-delimited list of names and emails for scientists who prepared synthetic material Examples are: Jim R.D. Hart , Alexis Heard :Bob McIntire
23 Synthetic Material Description synthetic_description Text Optional Detailed description
22 Synthetic Material IGSN Number synthetic_igsn Text Optional International Geological Sample Number (IGSN) Examples are: SIO0A0987, SIO001317
R 5 Formation Name er_formation_name Text Optional Name for formation Examples are: Bluebird Formation
R 10 Fossil Name er_fossil_name Text Optional Name for fossil Examples are: AMM43-03
13 Synthetic Material Institution synthetic_institution Text Required Name for institution that created synthetic material Examples are: IRM, SIO
R 4 Location Name er_location_name Text Optional Name for location, dredge or drill site Examples are: San Francisco Volcanic Province, Dredge AMAT02-D12, Site 801
R 6 Member Name er_member_name Text Optional Name for member Examples are: Glasshound Member
R 11 Mineral Name er_mineral_name Text Optional Name for mineral Examples are: San03-001
12 Synthetic Material Parent Sampling synthetic_parent_sample Text Required Name for parent sample used Examples are: STD1546-A1
R 8 Sample Name er_sample_name Text Optional Name for sample Examples are: Bas123a-01
R 3 Expedition Name er_expedition_name Text Optional Name for seagoing or land expedition Examples are: AVON02MV
R 7 Site Name er_site_name Text Optional Name for site Examples are: Bas123a
R 9 Specimen Name er_specimen_name Text Optional Name for specimen Examples are: Bas123a-01x
P 1 Synthetic Material Name er_synthetic_name Text Required Name for synthetic material Examples are: STD1546-A1
21 Synthetic Material Dope synthetic_dope_material Text Optional Synthetic dope material Examples are: Ti, Al, Mn, Mg
E 15 Synthetic Material Assemblage synthetic_assemblage Text Optional Synthetic material assemblage Examples are: Single Crystal, Mineral Separate, Polycrystalline
20 Synthetic Material Density synthetic_density Number in kg/m3 Optional Synthetic material density
17 Synthetic Material Size synthetic_size Text Optional Synthetic material grain size fraction Examples are: 250-500 ¿m
16 Synthetic Material Shape synthetic_shape Text Optional Synthetic material shape Examples are: Euhedral, Orthorhombic
E 14 Synthetic Material Type synthetic_type Text Required Synthetic material type Examples are: Rock, Biogenic, Ceramic
18 Synthetic Material Volume synthetic_volume Number in m3 Optional Synthetic material volume
19 Synthetic Material Weight synthetic_weight Number in kg Optional Synthetic material weight
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
Click to return to previous page