TD026

Properties of Attributes in entity 2 table: Water Stores

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
STCODE	N	N	char(5)	freetext	nominal
FORMAT	N	N	numeric(1,0)	range	interval	natural	2.-2.	1.	number
STID	N	N	char(3)	enum	nominal
DAY	Y	N	numeric(2,0)	range	datetime		1.-31.	1.	day of month
MONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
YEAR	Y	N	numeric(4,0)	range	datetime		1985.-2050.	1.	year (yyyy)
SITE	Y	N	numeric(1,0)	range	interval	natural	1.-6.	1.	number
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	1.-9999.	1.	number
SPECIES	N	N	char(4)	taxa	nominal
OBWATER	N	Y	numeric(8,3)	range	ratio	real	0.000-200.000	0.001	kilograms
IBWATER	N	Y	numeric(8,3)	range	ratio	real	0.000-200.000	0.001	kilograms
SAPWATER	N	Y	numeric(8,3)	range	ratio	real	0.000-1000.000	0.001	kilograms
HWATER	N	Y	numeric(8,3)	range	ratio	real	0.000-500.000	0.001	kilograms
TWATER	N	Y	numeric(8,3)	range	ratio	real	0.000-2000.000	0.001	kilograms
TMOIST	N	Y	numeric(6,1)	range	ratio	real	0.0-500.0	0.1	percent
OBMASS	N	Y	numeric(8,3)	range	ratio	real	0.000-500.000	0.001	kilograms
IBMASS	N	Y	numeric(8,3)	range	ratio	real	0.000-500.000	0.001	kilograms
SAPMASS	N	Y	numeric(8,3)	range	ratio	real	0.000-500.000	0.001	kilograms
HMASS	N	Y	numeric(8,3)	range	ratio	real	0.000-500.000	0.001	kilograms
TMASS	N	Y	numeric(8,3)	range	ratio	real	0.000-700.000	0.001	kilograms