CF011

Properties of Attributes in entity 2 table: Storm Data

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	2.-2.		number
SITECODE	N	N	char(5)	place	ordinal
WELL	N	N	char(6)	enum	nominal
RUN	N	N	char(3)	enum	nominal
SAMPLE_ID	Y	N	char(8)	freetext	nominal
SAMPLE_DATETIME	N	N	datetime	range	datetime		Nov 15 2013 8:31AM-Nov 17 2013 4:35PM		date as datetime type
PH	N	Y	numeric(3,1)	range	interval	real	4.0-7.5		pH units
PHCODE	N	N	char(1)	enum	nominal
TEMPERATURE	N	Y	numeric(4,1)	range	interval	real	7.3-11.1		degrees Celsius
TEMPCODE	N	N	char(1)	enum	nominal
ALKALINITY_CACO3	N	N	numeric(4,1)	range	ratio	real	17.6-22.4		milligrams per liter
ALKCODE	N	N	char(1)	enum	nominal
DIC	N	N	numeric(5,2)	range	ratio	real	4.64-8.04		milligrams per liter
DICCODE	N	N	char(1)	enum	nominal
DOC	N	N	numeric(4,2)	range	ratio	real	0.19-3.85		milligrams per liter
DOCCODE	N	N	char(1)	enum	nominal
MG	N	N	numeric(4,2)	range	ratio	real	0.90-1.45		milligrams per liter
MGCODE	N	N	char(1)	enum	nominal
CA	N	N	numeric(4,2)	range	ratio	real	4.22-6.02		milligrams per liter
CACODE	N	N	char(1)	enum	nominal
K	N	N	numeric(4,2)	range	ratio	real	0.08-0.26		milligrams per liter
KCODE	N	N	char(1)	enum	nominal
NA	N	N	numeric(4,2)	range	ratio	real	2.07-2.85		milligrams per liter
NACODE	N	N	char(1)	enum	nominal
PO4	N	N	numeric(4,2)	range	ratio	real	0.04-0.10		milligrams per liter
PO4CODE	N	N	char(1)	enum	nominal
NO3	N	N	numeric(4,2)	range	ratio	real	0.01-7.47		milligrams per liter
NO3CODE	N	N	char(1)	enum	nominal
SO4	N	N	numeric(4,2)	range	ratio	real	0.30-0.75		milligrams per liter
SO4CODE	N	N	char(1)	enum	nominal
CL	N	N	numeric(4,2)	range	ratio	real	0.54-1.20		milligrams per liter
CLCODE	N	N	char(1)	enum	nominal