AN008

Properties of Attributes in entity 3 table: Water chemistry of treatment reach

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	3.-3.		number
YEAR	N	N	numeric(4,0)	range	interval	natural	2014.-2016.		year (yyyy)
SITE_NUMBER	Y	N	char(8)	place	ordinal
REACH_TREATMENT	Y	N	char(1)	enum	nominal
SAMPLING_DATE	Y	N	datetime	range	datetime		Sep 2 2014-Aug 9 2016		date as date type
SAMPLE_TIMING	Y	N	char(5)	enum	nominal
UTN	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter
NH4_N	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter
NO3_N	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter
UTP	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter
PO4_P	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter
DOC	N	Y	numeric(5,3)	range	ratio	real	0.001-1.000		milligrams per liter