Magnetics Information Consortium (MagIC) -- Standard MagIC Data Format -- ER

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

Standard MagIC Data Format -- ER_Synthetics Table -- Version 2.0

F	Status	N	Database Field	Variable Name	Units	Required	Description
All Tables Click to expand the Data Model Diagram
P		1	Synthetic Material Name	er_synthetic_name	Text	Required	Name for synthetic material Examples are: STD1546-A1
		2	Synthetic Material Name Alternatives	er_synthetic_alternatives	Text	Optional	Colon-delimited list of alternative names and abbreviations
R		3	Expedition Name	er_expedition_name	Text	Required	Name for seagoing or land expedition Examples are: AVON02MV
R		4	Location Name	er_location_name	Text	Required	Name for location or drill site Examples are: San Francisco Volcanic Province, Site 801
R		5	Formation Name	er_formation_name	Text	Required	Name for formation Examples are: Bluebird Formation
R		6	Member Name	er_member_name	Text	Required	Name for member Examples are: Glasshound Member
R	Deleted	7	Section Name	er_section_name	Text	Required	Name for section or core Examples are: Berkeley Lava Flows, 810C, 1129D
R		8	Site Name	er_site_name	Text	Required	Name for site Examples are: Bas123a
R		9	Sample Name	er_sample_name	Text	Required	Name for sample Examples are: Bas123a-01
R		10	Specimen Name	er_specimen_name	Text	Required	Name for specimen Examples are: Bas123a-01x
R		11	Fossil Name	er_fossil_name	Text	Required	Name for fossil Examples are: AMM43-03
R		12	Mineral Name	er_mineral_name	Text	Required	Name for mineral Examples are: San03-001
		13	Synthetic Material Institution	synthetic_institution	Text	Required	Name for institution that created synthetic material Examples are: IRM, SIO
E		14	Synthetic Material Type	synthetic_type	Text	Required	Synthetic material type Examples are: Rock, Biogenic, Ceramic
E		15	Synthetic Material Assemblage	synthetic_assemblage	Text	Optional	Synthetic material assemblage Examples are: Single Crystal, Mineral Separate, Polycrystalline
		16	Synthetic Material Shape	synthetic_shape	Text	Optional	Synthetic material shape Examples are: Euhedral, Orthorhombic
		17	Synthetic Material Size	synthetic_size	Text	Optional	Synthetic material grain size fraction Examples are: 250-500 ¿m
		18	Synthetic Material Volume	synthetic_volume	Number in m3	Optional	Synthetic material volume
		19	Synthetic Material Weight	synthetic_weight	Number in g	Optional	Synthetic material weight
		20	Synthetic Material Density	synthetic_density	Number in g/m3	Optional	Synthetic material density
		21	Synthetic Material Dope	synthetic_dope_material	Text	Optional	Synthetic dope material
		22	Synthetic Material Description	synthetic_description	Text	Optional	Detailed description
R		23	Method Codes	magic_method_codes	Text	Recommended	Colon-delimited list of method codes Examples are: DE-DC0, FT-F1, LP-DCDMAG
R		24	Research Scientist Names	er_scientist_mail_names	Text	Recommended	Colon-delimited list of names for scientists who prepared synthetic material Examples are: Jim R.D. Hart, Alexis Heard, Bob McIntire
R		25	Citation Names	er_citation_names	Text	Required	Colon-delimited list of citations Examples are: Smith et al. 2003, Hart & Heard 1967, This study
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