SP038

Properties of Attributes in entity 21 table: Soil 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	21.-21.	1.	number
SITECODE	Y	N	char(6)	place	nominal
SOILTEMP_METHOD	N	N	char(6)	enum	nominal
DEPTH	N	N	numeric(4,0)	range	ratio	whole	10.-100.	1.	centimeters
QC_LEVEL	N	N	char(2)	enum	nominal
PROBE_CODE	Y	N	char(8)	enum	nominal
DATE	Y	N	datetime	range	datetime		Jun 16 1987-Sep 30 2018		date as date type
SOILTEMP_MEAN_DAY	N	Y	numeric(5,1)	range	interval	real	-1.8-27.5	0.1	degrees Celsius
SOILTEMP_MEAN_FLAG	N	N	char(1)	enum	nominal
SOILTEMP_MAX_DAY	N	Y	numeric(5,1)	range	interval	real	-1.0-36.7	0.1	degrees Celsius
SOILTEMP_MAX_FLAG	N	N	char(1)	enum	nominal
SOILTEMP_MAXTIME	N	Y	char(4)	freetext	nominal
SOILTEMP_MIN_DAY	N	Y	numeric(5,1)	range	interval	real	-2.9-26.8	0.1	degrees Celsius
SOILTEMP_MIN_FLAG	N	N	char(1)	enum	nominal
SOILTEMP_MINTIME	N	Y	char(4)	freetext	nominal
EVENT_CODE	N	N	char(6)	enum	nominal