HF004

Properties of Attributes in entity 2 table: Daily streamflow summaries

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
STCODE	N	N	char(5)	enum	nominal
FORMAT	N	N	numeric(2,0)	range	ratio	integer	2.-2.	1.	number
SITECODE	Y	N	char(6)	place	ordinal
WATERYEAR	N	N	numeric(4,0)	range	interval	integer	1950.-2020.	1.	number
DATE	Y	N	datetime	range	datetime		Oct 1 1949-Sep 30 2020		date as date type
MEAN_Q	N	Y	numeric(8,3)	range	ratio	real	0.000-4890.000	0.100	cubic feet per second
MAX_Q	N	Y	numeric(8,3)	range	ratio	real	0.000-8000.000	0.100	cubic feet per second
MIN_Q	N	Y	numeric(8,3)	range	ratio	real	0.000-2415.000	0.100	cubic feet per second
MEAN_Q_AREA	N	Y	numeric(7,3)	range	ratio	real	0.000-202.920	0.100	cubic feet per second per square mile
TOTAL_Q_AREA	N	Y	numeric(7,3)	range	ratio	real	0.000-7.543	0.010	inches
ESTCODE	N	N	char(1)	enum	nominal