CP003

Properties of Attributes in entity 3 table: Precipitation water nutrient mean annual 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	3.-3.	1.	number
SITECODE	Y	N	char(6)	place	nominal
WATERYEAR	Y	N	numeric(4,0)	range	interval	natural	1970.-1982.	1.	number
PRECIP_YR	N	Y	numeric(6,2)	range	ratio	real	29.36-329.75	0.25	centimeters
PCODE_YR	N	N	char(1)	enum	nominal
PH_YR	N	Y	numeric(5,1)	range	ratio	real	5.1-6.4	0.1	pH units
PHCODE_YR	N	N	char(2)	enum	nominal
COND_YR	N	Y	numeric(6,1)	range	ratio	real	3.9-29.4	0.4	micro siemens per centimeter
CONDCODE_YR	N	N	char(2)	enum	nominal
ALK_YR	N	Y	numeric(6,2)	range	ratio	real	0.63-2.63	0.02	milligrams per liter
ALKCODE_YR	N	N	char(2)	enum	nominal
SSED_YR	N	Y	numeric(6,2)	range	ratio	real	0.49-17.82	0.01	milligrams per liter
SSEDCODE_YR	N	N	char(2)	enum	nominal
SI_YR	N	Y	numeric(6,2)	range	ratio	real	0.05-0.71	0.05	milligrams per liter
SICODE_YR	N	N	char(2)	enum	nominal
UTP_YR	N	Y	numeric(6,3)	range	ratio	real	0.007-0.020	0.002	milligrams per liter
UTPCODE_YR	N	N	char(2)	enum	nominal
TDP_YR	N	Y	numeric(6,3)	range	ratio	real	0.003-0.042	0.002	milligrams per liter
TDPCODE_YR	N	N	char(2)	enum	nominal
PARTP_YR	N	Y	numeric(6,3)	range	ratio	real	0.003-0.012	0.002	milligrams per liter
PARTPCODE_YR	N	N	char(3)	enum	nominal
PO4P_YR	N	Y	numeric(6,3)	range	ratio	real	0.001-0.031	0.001	milligrams per liter
PO4PCODE_YR	N	N	char(2)	enum	nominal
UTKN_YR	N	Y	numeric(6,2)	range	ratio	real	0.03-0.18	0.00	milligrams per liter
UTKNCODE_YR	N	N	char(2)	enum	nominal
TKN_YR	N	Y	numeric(6,2)	range	ratio	real	0.02-0.12	0.00	milligrams per liter
TKNCODE_YR	N	N	char(2)	enum	nominal
PARTN_YR	N	Y	numeric(6,2)	range	ratio	real	0.01-0.08	0.01	milligrams per liter
PARTNCODE_YR	N	N	char(3)	enum	nominal
DON_YR	N	Y	numeric(6,2)	range	ratio	real	0.01-0.08	0.01	milligrams per liter
DONCODE_YR	N	N	char(3)	enum	nominal
NH3N_YR	N	Y	numeric(6,3)	range	ratio	real	0.004-0.056	0.002	milligrams per liter
NH3NCODE_YR	N	N	char(2)	enum	nominal
NO3N_YR	N	Y	numeric(6,3)	range	ratio	real	0.006-0.077	0.001	milligrams per liter
NO3NCODE_YR	N	N	char(2)	enum	nominal
NA_YR	N	Y	numeric(6,2)	range	ratio	real	0.11-0.86	0.00	milligrams per liter
NACODE_YR	N	N	char(2)	enum	nominal
K_YR	N	Y	numeric(6,2)	range	ratio	real	0.01-0.25	0.01	milligrams per liter
KCODE_YR	N	N	char(2)	enum	nominal
CA_YR	N	Y	numeric(6,2)	range	ratio	real	0.03-0.50	0.06	milligrams per liter
CACODE_YR	N	N	char(2)	enum	nominal
MG_YR	N	Y	numeric(6,2)	range	ratio	real	0.02-0.36	0.00	milligrams per liter
MGCODE_YR	N	N	char(2)	enum	nominal
SO4S_YR	N	Y	numeric(6,2)	range	ratio	real	0.01-0.50	0.01	milligrams per liter
SO4SCODE_YR	N	N	char(2)	enum	nominal
CL_YR	N	Y	numeric(6,2)	range	ratio	real	0.46-4.13	0.01	milligrams per liter
CLCODE_YR	N	N	char(2)	enum	nominal