CP002

Properties of Attributes in entity 2 table: Precipitation water nutrient inflow in kg/ha

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	2.-2.	1.	number
SITECODE	Y	N	char(6)	place	nominal
WATERYEAR	N	Y	numeric(4,0)	range	interval	natural	1969.-2018.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Oct 21 1968 10:45AM-Oct 1 2018 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-140.89	0.02	centimeters
PCODE	N	Y	char(1)	enum	nominal
ALK_INPUT	N	Y	numeric(6,2)	range	ratio	real	0.00-19.46	0.05	kilograms per hectare
ALKCODE	N	Y	char(1)	enum	nominal
SSED_INPUT	N	Y	numeric(7,2)	range	ratio	real	0.00-54.83	0.05	kilograms per hectare
SSEDCODE	N	Y	char(1)	enum	nominal
SI_INPUT	N	Y	numeric(6,2)	range	ratio	real	0.00-9.98	0.05	kilograms per hectare
SICODE	N	Y	char(1)	enum	nominal
UTP_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-0.472	0.005	kilograms per hectare
UTPCODE	N	Y	char(1)	enum	nominal
TDP_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-0.427	0.005	kilograms per hectare
TDPCODE	N	Y	char(1)	enum	nominal
PARTP_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-0.259	0.005	kilograms per hectare
PARTPCODE	N	Y	char(2)	enum	nominal
PO4P_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-0.476	0.005	kilograms per hectare
PO4PCODE	N	Y	char(1)	enum	nominal
UTN_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-1.40	0.01	kilograms per hectare
UTNCODE	N	Y	char(2)	enum	nominal
TDN_INPUT	N	Y	numeric(5,2)	range	interval	real	0.00-5.00	0.01	kilograms per hectare
TDNCODE	N	Y	char(2)	enum	nominal
DON_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-3.78	0.01	kilograms per hectare
DONCODE	N	Y	char(2)	enum	nominal
PARTN_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-1.19	0.01	kilograms per hectare
PARTNCODE	N	Y	char(2)	enum	nominal
UTKN_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-1.35	0.01	kilograms per hectare
UTKNCODE	N	Y	char(1)	enum	nominal
TKN_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-4.98	0.01	kilograms per hectare
TKNCODE	N	Y	char(1)	enum	nominal
NH3N_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-1.196	0.005	kilograms per hectare
NH3NCODE	N	Y	char(1)	enum	nominal
NO3N_INPUT	N	Y	numeric(5,3)	range	ratio	real	0.000-0.394	0.005	kilograms per hectare
NO3NCODE	N	Y	char(1)	enum	nominal
NA_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-2.84	0.02	kilograms per hectare
NACODE	N	Y	char(1)	enum	nominal
K_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-1.41	0.02	kilograms per hectare
KCODE	N	Y	char(1)	enum	nominal
CA_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-3.63	0.06	kilograms per hectare
CACODE	N	Y	char(1)	enum	nominal
MG_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-1.16	0.02	kilograms per hectare
MGCODE	N	Y	char(1)	enum	nominal
SO4S_INPUT	N	Y	numeric(6,2)	range	ratio	real	0.00-4.38	0.02	kilograms per hectare
SO4SCODE	N	Y	char(1)	enum	nominal
CL_INPUT	N	Y	numeric(6,2)	range	ratio	real	0.00-5.97	0.02	kilograms per hectare
CLCODE	N	Y	char(1)	enum	nominal
DOC_INPUT	N	Y	numeric(5,2)	range	ratio	real	0.00-7.48	0.02	kilograms per hectare
DOCCODE	N	Y	char(1)	enum	nominal