CF002

Properties of Attributes in entity 1 table: Proportional stream 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	N	numeric(4,0)	range	interval	natural	1969.-2019.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Oct 9 1968 12:00PM-May 22 2019 2:55PM		date as datetime type
LABNO	N	Y	char(4)	freetext	nominal
TYPE	N	N	char(2)	enum	nominal
INTERVAL	N	Y	numeric(6,2)	range	ratio	real	0.00-114.00	0.02	number
MEAN_LPS	N	Y	numeric(8,2)	range	ratio	real	0.00-19578.00	0.10	liters per second
Q_AREA_CM	N	Y	numeric(6,2)	range	ratio	real	0.00-116.31	0.02	centimeters
QCODE	N	Y	char(1)	enum	nominal
PH	N	Y	numeric(5,1)	range	ratio	real	4.2-8.4	0.1	pH units
PHCODE	N	Y	char(1)	enum	nominal
COND	N	Y	numeric(6,1)	range	ratio	real	14.4-98.0	0.4	micro siemens per centimeter
CONDCODE	N	Y	char(1)	enum	nominal
ALK	N	Y	numeric(6,2)	range	ratio	real	0.00-41.75	0.02	milligrams per liter
ALKCODE	N	Y	char(1)	enum	nominal
SSED	N	Y	numeric(7,2)	range	ratio	real	0.00-5411.01	0.01	milligrams per liter
SSEDCODE	N	Y	char(1)	enum	nominal
SI	N	Y	numeric(6,2)	range	ratio	real	0.15-15.00	0.05	milligrams per liter
SICODE	N	Y	char(1)	enum	nominal
UTP	N	Y	numeric(6,3)	range	ratio	real	0.005-0.492	0.002	milligrams per liter
UTPCODE	N	Y	char(1)	enum	nominal
TDP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.493	0.002	milligrams per liter
TDPCODE	N	Y	char(1)	enum	nominal
PARTP	N	Y	numeric(6,3)	range	ratio	real	0.000-0.478	0.002	milligrams per liter
PARTPCODE	N	Y	char(2)	enum	nominal
PO4P	N	Y	numeric(6,3)	range	ratio	real	0.000-0.109	0.001	milligrams per liter
PO4PCODE	N	Y	char(1)	enum	nominal
UTN	N	Y	numeric(6,2)	range	interval	real	0.00-2.79	0.01	milligrams per liter
UTNCODE	N	Y	char(2)	enum	nominal
TDN	N	Y	numeric(6,2)	range	ratio	real	0.00-1.01	0.01	milligrams per liter
TDNCODE	N	Y	char(2)	enum	nominal
DON	N	Y	numeric(6,2)	range	ratio	real	0.00-0.25	0.01	milligrams per liter
DONCODE	N	Y	char(2)	enum	nominal
PARTN	N	Y	numeric(6,2)	range	ratio	real	0.00-2.69	0.01	milligrams per liter
PARTNCODE	N	Y	char(2)	enum	nominal
UTKN	N	Y	numeric(6,2)	range	ratio	real	0.00-2.76	0.01	milligrams per liter
UTKNCODE	N	Y	char(1)	enum	nominal
TKN	N	Y	numeric(6,2)	range	ratio	real	0.00-0.28	0.01	milligrams per liter
TKNCODE	N	Y	char(1)	enum	nominal
NH3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.749	0.003	milligrams per liter
NH3NCODE	N	Y	char(1)	enum	nominal
NO3N	N	Y	numeric(6,3)	range	ratio	real	0.000-0.534	0.001	milligrams per liter
NO3NCODE	N	Y	char(1)	enum	nominal
NA	N	Y	numeric(6,2)	range	ratio	real	0.02-6.19	0.01	milligrams per liter
NACODE	N	Y	char(1)	enum	nominal
K	N	Y	numeric(6,2)	range	ratio	real	0.00-9.50	0.03	milligrams per liter
KCODE	N	Y	char(1)	enum	nominal
CA	N	Y	numeric(6,2)	range	ratio	real	0.08-10.86	0.06	milligrams per liter
CACODE	N	Y	char(1)	enum	nominal
MG	N	Y	numeric(6,2)	range	ratio	real	0.31-13.11	0.02	milligrams per liter
MGCODE	N	Y	char(1)	enum	nominal
SO4S	N	Y	numeric(6,2)	range	ratio	real	0.00-1.67	0.02	milligrams per liter
SO4SCODE	N	Y	char(1)	enum	nominal
CL	N	Y	numeric(6,2)	range	ratio	real	0.02-19.28	0.01	milligrams per liter
CLCODE	N	Y	char(1)	enum	nominal
DOC	N	Y	numeric(6,2)	range	ratio	real	0.19-4.27	0.05	milligrams per liter
DOCCODE	N	Y	char(1)	enum	nominal
PVOL	N	Y	numeric(7,3)	range	ratio	real	0.534-49.343	0.001	kilograms
PVOLCODE	N	Y	char(1)	enum	nominal
ANCA	N	Y	numeric(5,2)	range	ratio	real	0.32-2.06	0.10	number
ANCACODE	N	Y	char(2)	enum	nominal