HF018

Properties of Attributes in entity 3 table: Monthly streamflow summaries

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	3.-3.	1.	number
SITECODE	Y	N	char(6)	place	ordinal
WATERYEAR	N	N	numeric(4,0)	range	interval	integer	1959.-1973.	1.	number
YEAR	Y	N	numeric(4,0)	range	interval	integer	1958.-1973.	1.	number
MONTH	Y	N	numeric(2,0)	range	interval	integer	1.-12.	1.	number
MEAN_Q	N	Y	numeric(8,3)	range	ratio	real	0.016-27.830	0.100	cubic feet per second
MAX_Q	N	Y	numeric(8,3)	range	ratio	real	0.036-208.680	0.100	cubic feet per second
MIN_Q	N	Y	numeric(8,3)	range	ratio	real	0.005-10.480	0.100	cubic feet per second
MEAN_Q_AREA	N	Y	numeric(7,3)	range	ratio	real	0.058-28.400	0.100	cubic feet per second per square mile
TOTAL_Q_AREA	N	Y	numeric(7,3)	range	ratio	real	0.065-32.750	0.010	inches
ESTCODE	N	N	char(1)	enum	nominal
ESTDAYS	N	N	numeric(3,0)	range	ratio	integer	0.-31.	1.	number of days
TOTAL_DAYS	N	N	numeric(3,0)	range	ratio	integer	14.-31.	1.	number of days
MEAN_Q_USGS	N	Y	numeric(6,2)	range	ratio	real	0.02-30.29	1.00	cubic feet per second
ESTCODE_USGS	N	N	char(1)	enum	nominal