CP002

Properties of Attributes in entity 1 table: Precipitation water sample nutrient concentrations

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
STCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	1.-1.	1.	number
SITECODE	Y	N	char(6)	place	nominal
WATERYEAR	N	Y	numeric(4,0)	range	interval	natural	1969.-2019.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Oct 9 1968 9:52AM-May 22 2019 4:10PM		date as datetime type
LABNO	N	Y	char(4)	freetext	nominal
TYPE	N	N	char(2)	enum	nominal
PRECIP_CM	N	Y	numeric(7,2)	range	ratio	real	0.00-61.87	0.01	centimeters
PCODE	N	Y	char(1)	enum	nominal
PH	N	Y	numeric(5,1)	range	ratio	real	3.0-7.4	0.1	pH units
PHCODE	N	Y	char(1)	enum	nominal
COND	N	Y	numeric(6,1)	range	ratio	real	0.0-576.4	0.4	micro siemens per centimeter
CONDCODE	N	Y	char(1)	enum	nominal
ALK	N	Y	numeric(6,2)	range	ratio	real	0.00-15.37	0.02	milligrams per liter
ALKCODE	N	Y	char(1)	enum	nominal
SSED	N	Y	numeric(7,2)	range	ratio	real	0.00-796.00	0.01	milligrams per liter
SSEDCODE	N	Y	char(1)	enum	nominal
SI	N	Y	numeric(6,2)	range	ratio	real	0.00-8.91	0.05	milligrams per liter
SICODE	N	Y	char(1)	enum	nominal
UTP	N	Y	numeric(8,3)	range	ratio	real	0.000-1483.000	0.002	milligrams per liter
UTPCODE	N	Y	char(1)	enum	nominal
TDP	N	Y	numeric(6,3)	range	ratio	real	0.000-6.050	0.002	milligrams per liter
TDPCODE	N	Y	char(1)	enum	nominal
PARTP	N	Y	numeric(8,3)	range	ratio	real	0.000-1482.600	0.002	milligrams per liter
PARTPCODE	N	Y	char(2)	enum	nominal
PO4P	N	Y	numeric(6,3)	range	ratio	real	0.000-5.993	0.001	milligrams per liter
PO4PCODE	N	Y	char(1)	enum	nominal
UTN	N	Y	numeric(6,2)	range	ratio	real	0.00-15.99	0.01	milligrams per liter
UTNCODE	N	Y	char(2)	enum	nominal
TDN	N	Y	numeric(6,2)	range	interval	real	0.00-14.37	0.01	milligrams per liter
TDNCODE	N	Y	char(2)	enum	nominal
DON	N	Y	numeric(6,2)	range	ratio	real	0.00-10.87	0.01	milligrams per liter
DONCODE	N	Y	char(2)	enum	nominal
PARTN	N	Y	numeric(6,2)	range	ratio	real	0.00-5.10	0.01	milligrams per liter
PARTNCODE	N	Y	char(2)	enum	nominal
UTKN	N	Y	numeric(6,2)	range	ratio	real	0.00-2.67	0.01	milligrams per liter
UTKNCODE	N	Y	char(1)	enum	nominal
TKN	N	Y	numeric(6,2)	range	ratio	real	0.00-14.31	0.01	milligrams per liter
TKNCODE	N	Y	char(1)	enum	nominal
NH3N	N	Y	numeric(6,3)	range	ratio	real	0.000-3.916	0.003	milligrams per liter
NH3NCODE	N	Y	char(1)	enum	nominal
NO3N	N	Y	numeric(6,3)	range	ratio	real	0.000-1.880	0.001	milligrams per liter
NO3NCODE	N	Y	char(1)	enum	nominal
NA	N	Y	numeric(6,2)	range	ratio	real	0.00-18.23	0.01	milligrams per liter
NACODE	N	Y	char(1)	enum	nominal
K	N	Y	numeric(6,2)	range	ratio	real	0.00-18.20	0.03	milligrams per liter
KCODE	N	Y	char(1)	enum	nominal
CA	N	Y	numeric(6,2)	range	ratio	real	0.00-5.56	0.06	milligrams per liter
CACODE	N	Y	char(1)	enum	nominal
MG	N	Y	numeric(6,2)	range	ratio	real	0.00-15.95	0.02	milligrams per liter
MGCODE	N	Y	char(1)	enum	nominal
SO4S	N	Y	numeric(6,2)	range	ratio	real	0.00-4.89	0.02	milligrams per liter
SO4SCODE	N	Y	char(1)	enum	nominal
CL	N	Y	numeric(6,2)	range	ratio	real	0.00-47.20	0.01	milligrams per liter
CLCODE	N	Y	char(1)	enum	nominal
DOC	N	Y	numeric(6,2)	range	ratio	real	0.00-26.80	0.05	milligrams per liter
DOCCODE	N	Y	char(1)	enum	nominal
PVOL	N	Y	numeric(7,3)	range	ratio	real	0.008-19.980	0.001	kilograms
PVOLCODE	N	Y	char(1)	enum	nominal
ANCA	N	Y	numeric(5,2)	range	ratio	real	0.12-6.95	0.10	number
ANCACODE	N	Y	char(2)	enum	nominal