MS004

Properties of Attributes in entity 2 table: Periodic precipitation from standard and storage rain and snow gauges

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	2.-2.	1.	number
SITECODE	N	N	char(6)	place	nominal
PROBE_CODE	Y	N	char(8)	enum	nominal
DATETIME_BEGIN	Y	N	datetime	range	datetime		Nov 21 1951 12:00PM-Nov 30 2016 9:50AM		date as datetime type
DATETIME_END	N	N	datetime	range	datetime		Nov 29 1951 9:00AM-Dec 21 2016 10:53AM		date as datetime type
PERIOD_LENGTH	N	N	numeric(4,0)	range	ratio	natural	0.-578.	1.	number of days
PRECIP_TOT_PERIOD	N	Y	numeric(6,1)	range	ratio	real	0.0-3474.0	0.2	millimeters
PRECIP_TOT_FLAG	N	N	char(1)	enum	nominal
PROBE_CODE_REC	N	N	char(8)	enum	nominal
PRECIP_REC_PERIOD	N	Y	numeric(6,1)	range	ratio	real	0.0-3535.0	0.2	millimeters
PRECIP_REC_FLAG	N	N	char(1)	enum	nominal
COMMENT	N	Y	char(120)	freetext	nominal