AN006

Properties of Attributes in entity 4 table: N2 & N2O gas sampling: concentrations & 15N labels

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	4.-4.		number
SITEID	Y	N	char(8)	place	ordinal
SAMPLE_DATETIME	Y	N	datetime	range	datetime		May 14 2003 11:46AM-Feb 23 2006 1:00PM		date as datetime type
SAMPLEPERIOD	Y	N	char(9)	enum	ordinal
EXPTIME_ISOTOPE	Y	Y	numeric(6,0)	range	ratio	integer	0.-3000.		number of minutes of time
STATION	Y	N	char(2)	enum	ordinal
DISTANCE	N	Y	numeric(4,0)	range	ratio	real	10.-1872.		meters
ANALYTICALLAB	Y	N	char(4)	enum	nominal
REP_NO	Y	N	char(1)	enum	nominal
VOLUMEWATERSAMPLE	N	N	numeric(3,0)	range	ratio	real	0.-127.		milliliters
VOLUMEHEADSPACE_HE	N	N	numeric(2,0)	range	ratio	real	0.-36.		milliliters
VOLUMEHEADSPACE_INJECTED	N	N	numeric(2,0)	range	ratio	real	0.-87.		milliliters
TEMPERATURE_STREAM	N	N	numeric(4,1)	range	ratio	real	0.0-37.0		degrees Celsius
TEMPERATURE_HEADSPACE	N	N	numeric(4,1)	range	ratio	real	0.0-295.0		degrees Celsius
BAROMETRICPRESSURE	N	N	numeric(6,4)	range	ratio	real	0.0000-1.0210		atmosphere
SPC	N	Y	numeric(6,1)	range	ratio	real	0.3-490.3		micro siemens per centimeter
D15N_N2	N	Y	numeric(4,1)	range	ratio	real	-18.0-97.7		permil
N2_MASS	N	Y	numeric(6,4)	range	ratio	real	-1.2540-1.2420		millimoles
D15N_N2O	N	Y	numeric(6,1)	range	ratio	real	-287.2-11476.0		permil
N2O_MASS	N	Y	numeric(7,4)	range	ratio	real	-5.5890-358.7600		nanomoles
N2O_CONCENTRATION	N	Y	numeric(6,4)	range	ratio	real	-0.0002-0.3938		micromoles per liter
NOTES	N	Y	varchar(185)	freetext	nominal