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