MS005

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	Y	N	char(6)	place	nominal
AIRTEMP_METHOD	N	N	char(6)	enum	nominal
HEIGHT	N	N	numeric(4,0)	range	ratio	whole	60.-500.	1.	centimeters
QC_LEVEL	N	N	char(2)	enum	nominal
PROBE_CODE	Y	N	char(8)	enum	nominal
DATE	Y	N	datetime	range	datetime		Apr 13 1970-Sep 30 2019		date as date type
AIRTEMP_MEAN_DAY	N	Y	numeric(5,1)	range	interval	real	-23.5-32.6	0.1	degrees Celsius
AIRTEMP_MEAN_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MAX_DAY	N	Y	numeric(5,1)	range	interval	real	-20.5-42.9	0.1	degrees Celsius
AIRTEMP_MAX_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MAXTIME	N	Y	char(4)	freetext	ordinal
AIRTEMP_MIN_DAY	N	Y	numeric(5,1)	range	interval	real	-25.1-27.2	0.1	degrees Celsius
AIRTEMP_MIN_FLAG	N	N	char(1)	enum	nominal
AIRTEMP_MINTIME	N	Y	char(4)	freetext	ordinal
EVENT_CODE	N	N	char(6)	enum	nominal