MS001

Properties of Attributes in entity 1 table: Air temperature (daily)

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	1.-1.	1.	number
SITECODE	N	N	char(6)	place	nominal
AIRTEMP_METHOD	N	N	char(6)	enum	nominal
HEIGHT	N	N	numeric(4,0)	range	ratio	whole	50.-480.	1.	centimeters
QC_LEVEL	N	N	char(2)	enum	nominal
PROBE_CODE	Y	N	char(8)	enum	nominal
DATE	Y	N	datetime	range	datetime		Feb 3 1958-Mar 25 2019		date as date type
AIRTEMP_MEAN_DAY	N	Y	numeric(5,1)	range	interval	real	-21.2-29.1	0.1	degrees Celsius
AIRTEMP_MEAN_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MAX_DAY	N	Y	numeric(5,1)	range	interval	real	-18.3-43.7	0.1	degrees Celsius
AIRTEMP_MAX_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MAXTIME	N	Y	char(4)	freetext	ordinal				time in military hours and minutes
AIRTEMP_MIN_DAY	N	Y	numeric(5,1)	range	interval	real	-23.7-24.2	0.1	degrees Celsius
AIRTEMP_MIN_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MINTIME	N	Y	char(4)	freetext	nominal
EVENT_CODE	N	N	char(6)	enum	nominal