Database structure

Table	Description
tblRockGeoData	Main Table containing a single record for each rock sample with fields describing the sample, the IDs, the submitter, the location, and the site. Every record is identified by a unique LAB_ID value.
xtbMajorChem	Analytical data by LAB_ID for major element oxide analyses plus forms-of-carbon, forms-of-sulfur, chlorine, and fluorine data.
xtbXrfChem	Analytical data by LAB_ID for minor and trace elements determined by X-ray fluorescence spectrometry.
xtbNaaChem	Analytical data by LAB_ID for major, minor, and trace elements determined by instrumental neutron activation analysis or delayed neutron activation analysis.
xtbIcpaesChem	Analytical data by LAB_ID for major, minor, and trace elements determined by inductively coupled plasma-atomic emission spectrometry with separate fields for total and partial digestion analyses.
xtbIcpmsChem	Analytical data by LAB_ID for major, minor, and trace elements determined by inductively coupled-mass spectrometry with separate fields for total and partial digestion analyses.
xtbEsChem	Analytical data by LAB_ID for major, minor, and trace elements determined by emission spectroscopy.
xtbOtherChem	Analytical data by LAB_ID for major, minor, and trace elements determined by atomic absorption spectrometry, colorimetry, ion selective electrode (except Cl & F), fluorometry, or fire assay with separate fields for total and partial digestion analyses.
xtbUnknownChem	Analytical data by LAB_ID for major, minor, and trace elements determined by analytical methods currently unspecified in the database.

Sample identification	10
Processing information	4
Geographic location	7
Site characteristics	6
Sample characteristics	12
Analyses for major elements	190
Analyses by XRF	82
Analyses by NAA	129
Analyses by DNA	6
Miscellaneous analyses	12
Analyses by ICP-AES	118
Analyses by ICP-AES Partial Chem	78
Analyses by ICP-MS	128
Analyses by Emission Spectroscopy	138
Analyses by AA	83
Analyses by AA Partial Chem	32
Analyses by Colorimetry	34
Analyses by Colorimetry Partial Chem	16
Analyses by Fluorometry	4
Analyses by Fire Assay Methods	15
Analyses by Unspecified Methods	196
Analyses by Unspecified Partial Chem Methods	10

Database structure

Database field categories