SP038

Properties of Attributes in entity 23 table: Soil water content (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	23.-23.	1.	number
SITECODE	Y	N	char(6)	place	nominal
SOILWC_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 4 1998-Sep 30 2018		date as date type
SOILWC_MEAN_DAY	N	Y	numeric(5,2)	range	ratio	real	0.00-0.90	0.02	number
SOILWC_MEAN_FLAG	N	N	char(1)	enum	nominal
SOILWC_MAX_DAY	N	Y	numeric(5,2)	range	ratio	real	0.02-0.90	0.02	number
SOILWC_MAX_FLAG	N	N	char(1)	enum	nominal
SOILWC_MAXTIME	N	Y	char(4)	freetext	ordinal				time in military hours and minutes
SOILWC_MIN_DAY	N	Y	numeric(5,2)	range	ratio	real	0.00-0.90	0.02	number
SOILWC_MIN_FLAG	N	N	char(1)	enum	nominal
SOILWC_MINTIME	N	Y	char(4)	freetext	ordinal				time in military hours and minutes
EVENT_CODE	N	N	char(6)	enum	nominal