MS007

Properties of Attributes in entity 1 table: Snow depth and snow water equivalent measurements along road course

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	1.-1.	1.	number
SNOW_YEAR	Y	N	numeric(4,0)	range	interval	whole	1995.-2022.		year (yyyy)
SITECODE	Y	N	char(6)	place	nominal
POSITION	Y	N	numeric(1,0)	range	ratio	natural	1.-3.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Dec 8 1994 12:00AM-Jun 11 2022 12:00PM		date as datetime type
SNOW_DEPTH_METHOD	Y	N	char(1)	enum	nominal
SNOW_DEPTH_INST	N	Y	numeric(4,0)	range	ratio	whole	0.-3414.	15.	millimeters
SNOW_DEPTH_INST_FLAG	N	Y	char(1)	enum	nominal
SNOW_COVER	N	Y	numeric(3,0)	range	ratio	whole	0.-100.	10.	percent
SNOW_COVER_FLAG	N	Y	char(1)	enum	nominal
SNOW_DEPTH_LOW	N	Y	numeric(4,0)	range	ratio	whole	0.-3353.	50.	millimeters
SNOW_DEPTH_LOW_FLAG	N	Y	char(1)	enum	nominal
SNOW_DEPTH_HI	N	Y	numeric(4,0)	range	ratio	whole	0.-3475.	50.	millimeters
SNOW_DEPTH_HI_FLAG	N	Y	char(1)	enum	nominal
SWE_INST	N	Y	numeric(4,0)	range	ratio	whole	0.-1397.	15.	millimeters
SWE_INST_FLAG	N	Y	char(1)	enum	nominal
TUBE_DEPTH	N	Y	numeric(4,0)	range	ratio	whole	0.-3454.	15.	millimeters
TUBE_DEPTH_FLAG	N	Y	char(1)	enum	nominal
NOTES	N	Y	char(254)	freetext	nominal