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

Standard MagIC Data Format -- ER_Mailinglist Table -- Version 2.3
All Tables
Click to expand the Data Model Diagram
MagIC Data Model
F Status N Database Field Variable Name Units Required Description
12 Personal URL url Text Optional Personal url Examples are: http://jcruiser.fu.edu/home.html
11 Email Address email Text Recommended Email address Examples are: jcruiser@fu.edu
10 Work Fax work_fax Text Recommended Work fax Examples are: 621-345-4567
9 Work Phone work_phone Text Recommended Work phone Examples are: 620-345-4567
8 Country country Text Required Country Examples are: USA
7 Zip Code zip_code Text Recommended Zip code Examples are: CA 92093
6 State state Text Optional State or province Examples are: California
5 City city Text Recommended City Examples are: Amsterdam
4 Address address Text Recommended Street address Examples are: Vessel Blvd. 2345
3 Department Name department Text Recommended Department or faculty name Examples are: Laboratory of Isotope Geology
2 Organization Name organization Text Required Organization or university name Examples are: Free University Amsterdam
P 1 Name er_mail_name Text Required Name Examples are: John A.B. Cruiser
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