CP003

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

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	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	N	numeric(4,0)	range	interval	natural	1970.-1982.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Oct 6 1969 12:00PM-Oct 1 1982 12:00AM		date as datetime type
LABNO	N	Y	char(4)	freetext	nominal
TYPE	N	N	char(2)	enum	nominal
PRECIP_CM	N	Y	numeric(6,2)	range	ratio	real	0.00-81.23	0.02	centimeters
PCODE	N	N	char(1)	enum	nominal
PH	N	Y	numeric(5,1)	range	ratio	real	4.3-7.7	0.1	pH units
PHCODE	N	N	char(1)	enum	nominal
COND	N	Y	numeric(6,1)	range	ratio	real	2.7-47.2	0.4	micro siemens per centimeter
CONDCODE	N	N	char(1)	enum	nominal
ALK	N	Y	numeric(6,2)	range	ratio	real	0.00-18.21	0.02	milligrams per liter
ALKCODE	N	N	char(1)	enum	nominal
SSED	N	Y	numeric(7,2)	range	ratio	real	0.08-82.78	0.01	milligrams per liter
SSEDCODE	N	N	char(1)	enum	nominal
SI	N	Y	numeric(6,2)	range	ratio	real	0.00-2.50	0.05	milligrams per liter
SICODE	N	N	char(1)	enum	nominal
UTP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.092	0.002	milligrams per liter
UTPCODE	N	N	char(1)	enum	nominal
TDP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.078	0.002	milligrams per liter
TDPCODE	N	N	char(1)	enum	nominal
PARTP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.053	0.002	milligrams per liter
PARTPCODE	N	N	char(2)	enum	nominal
PO4P	N	Y	numeric(6,3)	range	ratio	real	0.000-0.078	0.001	milligrams per liter
PO4PCODE	N	N	char(1)	enum	nominal
UTKN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.31	0.00	milligrams per liter
UTKNCODE	N	N	char(1)	enum	nominal
TKN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.47	0.00	milligrams per liter
TKNCODE	N	N	char(1)	enum	nominal
PARTN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.15	0.01	milligrams per liter
PARTNCODE	N	N	char(2)	enum	nominal
DON	N	Y	numeric(6,2)	range	ratio	real	0.00-0.28	0.01	milligrams per liter
DONCODE	N	N	char(2)	enum	nominal
NH3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.439	0.002	milligrams per liter
NH3NCODE	N	N	char(1)	enum	nominal
NO3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.451	0.001	milligrams per liter
NO3NCODE	N	N	char(1)	enum	nominal
NA	N	Y	numeric(6,2)	range	ratio	real	0.00-2.25	0.00	milligrams per liter
NACODE	N	N	char(1)	enum	nominal
K	N	Y	numeric(6,2)	range	ratio	real	0.00-1.02	0.01	milligrams per liter
KCODE	N	N	char(1)	enum	nominal
CA	N	Y	numeric(6,2)	range	ratio	real	0.00-4.13	0.06	milligrams per liter
CACODE	N	N	char(1)	enum	nominal
MG	N	Y	numeric(6,2)	range	ratio	real	0.00-1.52	0.00	milligrams per liter
MGCODE	N	N	char(1)	enum	nominal
SO4S	N	Y	numeric(6,2)	range	ratio	real	0.00-1.20	0.01	milligrams per liter
SO4SCODE	N	N	char(1)	enum	nominal
CL	N	Y	numeric(6,2)	range	ratio	real	0.27-4.13	0.01	milligrams per liter
CLCODE	N	N	char(1)	enum	nominal