AN006

Properties of Attributes in entity 8 table: Well or tributary samples (Chemistry)

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	8.-8.		number
SITEID	Y	N	char(8)	place	ordinal
SAMPLEDATE	N	Y	datetime	range	datetime		May 14 2003-Feb 22 2006		date as date type
SAMPLENUMBER	Y	N	numeric(2,0)	range	interval	whole	0.-19.		number
LOCATION	N	Y	varchar(50)	freetext	nominal
NH4_N	N	Y	numeric(6,1)	range	ratio	real	0.5-2982.0		micrograms per liter
NO3_N	N	Y	numeric(6,1)	range	ratio	real	2.0-35569.0		micrograms per liter
NOTES	N	Y	varchar(185)	freetext	nominal