AN006

Properties of Attributes in entity 2 table: Conditions & standards for isotope release (15N Solute Info)

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	2.-2.		number
SITEID	Y	N	char(8)	place	ordinal
N15_BEGIN	N	N	datetime	range	datetime		May 14 2003 1:05PM-Feb 22 2006 12:50PM		date as datetime type
N15_END	N	N	datetime	range	datetime		May 15 2003 1:05PM-Feb 23 2006 1:58PM		date as datetime type
WEATHER	N	Y	varchar(90)	freetext	nominal
PAR_N15_RELEASE	N	Y	numeric(7,4)	range	ratio	real	0.0000-70.0000		moles quanta per square meter per day
REACHLENGTH_ISOTOPE	N	N	numeric(4,0)	range	ratio	real	100.-1850.		meters
MEANWETWIDTH_ISOTOPE	N	N	numeric(5,2)	range	ratio	real	0.55-6.70		meters
INJECTIONTIME_ISOTOPE	N	N	numeric(4,0)	range	ratio	real	414.-1568.		number of minutes of time
INJECTIONRATE_ISOTOPE	N	N	numeric(5,1)	range	ratio	real	11.6-186.3		milliliters per minute
TRACER_SOLUTE	N	N	char(6)	enum	nominal
TRACER_STOCKCONC	N	N	numeric(11,1)	range	ratio	real	434.6-172190000.0		milligrams per liter
TOTAL_15N_ADDED	N	Y	numeric(8,3)	range	ratio	real	0.035-1522.080		grams
HIGH_NO3_SPIKE_CONCENTRATION_1	N	Y	numeric(7,1)	range	ratio	real	0.0-184000.0		micrograms per liter
HIGH_NO3_SPIKE_CONCENTRATION_2	N	Y	numeric(7,1)	range	ratio	real	0.0-50000.0		micrograms per liter
HIGH_NO3_SPIKE_CONCENTRATION_3	N	Y	numeric(7,1)	range	ratio	real	0.0-50000.0		micrograms per liter
HIGH_NO3_SPIKE_CONCENTRATION_4	N	Y	numeric(7,1)	range	ratio	real	0.0-50000.0		micrograms per liter
HIGH_NO3_SPIKE_CONCENTRATION_5	N	Y	numeric(7,1)	range	ratio	real	0.0-50000.0		micrograms per liter
HIGH_D15NO3_SPIKE_1	N	Y	numeric(4,1)	range	ratio	real	-4.9-35.6		micrograms per liter
HIGH_D15NO3_SPIKE_2	N	Y	numeric(4,1)	range	ratio	real	-5.1-27.9		micrograms per liter
HIGH_D15NO3_SPIKE_3	N	Y	numeric(4,1)	range	ratio	real	-0.5-60.8		micrograms per liter
HIGH_D15NO3_SPIKE_4	N	Y	numeric(4,1)	range	ratio	real	-3.4-22.8		micrograms per liter
HIGH_D15NO3_SPIKE_5	N	Y	numeric(4,1)	range	ratio	real	-5.9-8.5		micrograms per liter
LOW_NO3_SPIKE_CONCENTRATION_1	N	Y	numeric(6,1)	range	ratio	real	0.0-2000.0		micrograms per liter
LOW_NO3_SPIKE_CONCENTRATION_2	N	Y	numeric(6,1)	range	ratio	real	0.0-2000.0		micrograms per liter
LOW_NO3_SPIKE_CONCENTRATION_3	N	Y	numeric(6,1)	range	ratio	real	0.0-122.9		micrograms per liter
LOW_NO3_SPIKE_CONCENTRATION_4	N	Y	numeric(6,1)	range	ratio	real	0.0-40.0		micrograms per liter
LOW_D15NO3_SPIKE_1	N	Y	numeric(4,1)	range	ratio	real	-0.1-21.0		permil
LOW_D15NO3_SPIKE_2	N	Y	numeric(4,1)	range	ratio	real	-1.2-24.2		permil
LOW_D15NO3_SPIKE_3	N	Y	numeric(4,1)	range	ratio	real	-0.5-9.7		permil
LOW_D15NO3_SPIKE_4	N	Y	numeric(4,1)	range	ratio	real	0.0-2.1		permil
DEVARDAS_DATE	N	Y	datetime	range	datetime		Apr 23 2003-Feb 8 2015		date as date type
DEVARDAS_NO3_STANDARD_1	N	Y	numeric(3,0)	range	ratio	real	2.-50.		micrograms per deciliter
DEVARDAS_NO3_STANDARD_2	N	Y	numeric(3,0)	range	ratio	real	50.-75.		micrograms per deciliter
DEVARDAS_NO3_STANDARD_3	N	Y	numeric(3,0)	range	ratio	real	100.-100.		micrograms per deciliter
DEVARDAS_NO3_STANDARD_4	N	Y	numeric(3,0)	range	ratio	real	140.-150.		micrograms per deciliter
DEVARDAS_NO3_STANDARD_5	N	Y	numeric(3,0)	range	ratio	real	0.-200.		micrograms per deciliter
DEVARDAS_NO3_MASS_1	N	Y	numeric(5,1)	range	ratio	real	20.6-57.0		micrograms per liter
DEVARDAS_NO3_MASS_2	N	Y	numeric(5,1)	range	ratio	real	49.9-107.1		micrograms per liter
DEVARDAS_NO3_MASS_3	N	Y	numeric(5,1)	range	ratio	real	96.9-134.0		micrograms per liter
DEVARDAS_NO3_MASS_4	N	Y	numeric(5,1)	range	ratio	real	105.0-181.2		micrograms per liter
DEVARDAS_NO3_MASS_5	N	Y	numeric(5,1)	range	ratio	real	155.0-239.4		micrograms per liter
DEVARDAS_DN15_1	N	Y	numeric(4,1)	range	ratio	real	-7.5-4.4		permil
DEVARDAS_DN15_2	N	Y	numeric(4,1)	range	ratio	real	-4.5-5.0		permil
DEVARDAS_DN15_3	N	Y	numeric(4,1)	range	ratio	real	-2.5-4.4		permil
DEVARDAS_DN15_4	N	Y	numeric(4,1)	range	ratio	real	-3.3-4.4		permil
DEVARDAS_DN15_5	N	Y	numeric(4,1)	range	ratio	real	-3.3-5.1		permil
MEASURED_STANDARD_D15NO3_1	N	Y	numeric(6,1)	range	ratio	real	20.0-3443.0		permil
MEASURED_STANDARD_D15NO3_2	N	Y	numeric(6,1)	range	ratio	real	20.0-3414.9		permil
EXPECTED_STANDARD_D15NO3_1	N	Y	numeric(6,1)	range	ratio	real	27.1-2057.0		permil
EXPECTED_STANDARD_D15NO3_2	N	Y	numeric(6,1)	range	ratio	real	25.6-2057.0		permil
FRACTIONATION_HIGH_DNH4_TRUE_1	N	Y	numeric(5,1)	range	ratio	real	-2.4-3.2		permil
FRACTIONATION_HIGH_DNH4_TRUE_2	N	Y	numeric(5,1)	range	ratio	real	-12.1-7.5		permil
FRACTIONATION_HIGH_DNH4_TRUE_3	N	Y	numeric(5,1)	range	ratio	real	-1.9-5.3		permil
FRACTIONATION_HIGH_DNH4_TRUE_4	N	Y	numeric(5,1)	range	ratio	real	-1.9-2.8		permil
FRACTIONATION_HIGH_DNH4_TRUE_5	N	Y	numeric(5,1)	range	ratio	real	-1.5-2.3		permil
FRACTIONATION_TRUEMASS_NH4_1	N	Y	numeric(5,1)	range	ratio	real	0.0-200.0		micrograms
FRACTIONATION_TRUEMASS_NH4_2	N	Y	numeric(5,1)	range	ratio	real	0.0-200.0		micrograms
FRACTIONATION_TRUEMASS_NH4_3	N	Y	numeric(5,1)	range	ratio	real	0.0-200.0		micrograms
FRACTIONATION_TRUEMASS_NH4_4	N	Y	numeric(5,1)	range	ratio	real	0.0-199.5		micrograms
FRACTIONATION_MEASMASS_NH4_1	N	Y	numeric(5,1)	range	ratio	real	0.0-144.6		micrograms
FRACTIONATION_MEASMASS_NH4_2	N	Y	numeric(5,1)	range	ratio	real	0.0-145.8		micrograms
FRACTIONATION_MEASMASS_NH4_3	N	Y	numeric(5,1)	range	ratio	real	0.0-143.1		micrograms
FRACTIONATION_MEASMASS_NH4_4	N	Y	numeric(5,1)	range	ratio	real	0.0-139.7		micrograms
FRACTIONATION_D15NH4_1	N	Y	numeric(5,1)	range	ratio	real	-16.1-9.8		permil
FRACTIONATION_D15NH4_2	N	Y	numeric(5,1)	range	ratio	real	-9.7-23.6		permil
FRACTIONATION_D15NH4_3	N	Y	numeric(5,1)	range	ratio	real	-11.8-24.1		permil
FRACTIONATION_D15NH4_4	N	Y	numeric(5,1)	range	ratio	real	-10.8-12.7		permil
SPIKE_CONCENTRATION_NH4_1	N	Y	numeric(4,1)	range	ratio	real	0.0-40.0		micrograms per liter
SPIKE_CONCENTRATION_NH4_2	N	Y	numeric(4,1)	range	ratio	real	0.0-40.0		micrograms per liter
SPIKE_CONCENTRATION_NH4_3	N	Y	numeric(4,1)	range	ratio	real	0.0-41.0		micrograms per liter
SPIKE_CONCENTRATION_NH4_4	N	Y	numeric(4,1)	range	ratio	real	0.0-40.0		micrograms per liter
SPIKE_D15NH4_1	N	Y	numeric(4,1)	range	ratio	real	-9.4-2.4		permil
SPIKE_D15NH4_2	N	Y	numeric(4,1)	range	ratio	real	-8.5-2.4		permil
SPIKE_D15NH4_3	N	Y	numeric(4,1)	range	ratio	real	-11.0-2.4		permil
SPIKE_D15NH4_4	N	Y	numeric(4,1)	range	ratio	real	-8.6-1.4		permil
NOTES	N	Y	varchar(185)	freetext	nominal