SP038

Properties of Attributes in entity 6 table: Soil moisture potential (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	6.-6.	1.	number
SITECODE	Y	N	char(6)	place	nominal
SOILMP_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-Nov 13 2002		date as date type
SOILMP_MEAN_DAY	N	Y	numeric(5,2)	range	ratio	real	0.00-15.00	0.01	pressure in bars
SOILMP_MEAN_FLAG	N	N	char(1)	enum	nominal
SOILMP_MAX_DAY	N	Y	numeric(5,2)	range	ratio	real	0.10-15.00	0.10	pressure in bars
SOILMP_MAX_FLAG	N	N	char(1)	enum	nominal
SOILMP_MAXTIME	N	Y	char(4)	freetext	ordinal				time in military hours and minutes
SOILMP_MIN_DAY	N	Y	numeric(5,2)	range	ratio	real	0.00-15.00	0.01	pressure in bars
SOILMP_MIN_FLAG	N	N	char(1)	enum	nominal
SOILMP_MINTIME	N	Y	char(4)	freetext	ordinal				time in military hours and minutes
EVENT_CODE	N	N	char(6)	enum	nominal