CF003

Properties of Attributes in entity 1 table: Proportional stream 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
Q_AREA_CM	N	Y	numeric(6,2)	range	ratio	real	0.00-56.49	0.02	centimeters
QCODE	N	N	char(1)	enum	nominal
PH	N	Y	numeric(5,1)	range	ratio	real	5.2-8.8	0.1	pH units
PHCODE	N	N	char(1)	enum	nominal
COND	N	Y	numeric(6,1)	range	ratio	real	9.2-322.6	0.4	micro siemens per centimeter
CONDCODE	N	N	char(1)	enum	nominal
ALK	N	Y	numeric(6,2)	range	ratio	real	2.08-93.84	0.02	milligrams per liter
ALKCODE	N	N	char(1)	enum	nominal
SSED	N	Y	numeric(7,2)	range	ratio	real	0.00-2200.00	0.01	milligrams per liter
SSEDCODE	N	N	char(1)	enum	nominal
SI	N	Y	numeric(6,2)	range	ratio	real	0.00-16.60	0.05	milligrams per liter
SICODE	N	N	char(1)	enum	nominal
UTP	N	Y	numeric(6,3)	range	ratio	real	0.002-0.252	0.002	milligrams per liter
UTPCODE	N	N	char(1)	enum	nominal
TDP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.205	0.002	milligrams per liter
TDPCODE	N	N	char(1)	enum	nominal
PARTP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.201	0.002	milligrams per liter
PARTPCODE	N	N	char(2)	enum	nominal
PO4P	N	Y	numeric(6,3)	range	ratio	real	0.000-0.126	0.001	milligrams per liter
PO4PCODE	N	N	char(1)	enum	nominal
UTKN	N	Y	numeric(6,2)	range	ratio	real	0.02-0.42	0.01	milligrams per liter
UTKNCODE	N	N	char(1)	enum	nominal
TKN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.27	0.01	milligrams per liter
TKNCODE	N	N	char(1)	enum	nominal
PARTN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.29	0.01	milligrams per liter
PARTNCODE	N	N	char(2)	enum	nominal
DON	N	Y	numeric(6,2)	range	ratio	real	0.00-0.25	0.01	milligrams per liter
DONCODE	N	N	char(2)	enum	nominal
NH3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.170	0.002	milligrams per liter
NH3NCODE	N	N	char(1)	enum	nominal
NO3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.510	0.001	milligrams per liter
NO3NCODE	N	N	char(1)	enum	nominal
NA	N	Y	numeric(6,2)	range	ratio	real	0.30-24.60	0.00	milligrams per liter
NACODE	N	N	char(1)	enum	nominal
K	N	Y	numeric(6,2)	range	ratio	real	0.00-3.20	0.01	milligrams per liter
KCODE	N	N	char(1)	enum	nominal
CA	N	Y	numeric(6,2)	range	ratio	real	0.10-14.88	0.06	milligrams per liter
CACODE	N	N	char(1)	enum	nominal
MG	N	Y	numeric(6,2)	range	ratio	real	0.00-4.27	0.00	milligrams per liter
MGCODE	N	N	char(1)	enum	nominal
SO4S	N	Y	numeric(6,2)	range	ratio	real	0.00-3.53	0.01	milligrams per liter
SO4SCODE	N	N	char(1)	enum	nominal
CL	N	Y	numeric(6,2)	range	ratio	real	0.55-2.41	0.01	milligrams per liter
CLCODE	N	N	char(1)	enum	nominal