TD025

Properties of Attributes in entity 1 table: Water Flow Volumes

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	1.-1.	1.	number
STUDYID	N	N	char(3)	enum	nominal
SITE	Y	N	char(1)	enum	nominal
SPECIES	N	Y	char(4)	taxa	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	32.-505.	1.	number
SDAY	Y	N	numeric(2,0)	range	datetime		1.-31.	1.	day of month
SMONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
SYEAR	Y	N	numeric(4,0)	range	datetime		1985.-2050.	1.	year (yyyy)
EDAY	Y	N	numeric(2,0)	range	datetime		1.-31.	1.	day of month
EMONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
EYEAR	Y	N	numeric(4,0)	range	datetime		1985.-2050.	1.	year (yyyy)
BULKTIME	N	Y	numeric(1,0)	range	ratio	natural	1.-99.	1.	number
FTYPE	Y	N	char(1)	enum	nominal
VOL	N	N	numeric(5,2)	range	ratio	real	0.00-30.00	0.01	liters
COLLAREA	N	N	numeric(5,3)	range	ratio	real	0.032-0.500	0.001	square meters
MSVOL	N	N	numeric(7,2)	range	ratio	real	0.00-700.00	0.01	liters
ESTIM	N	Y	char(1)	enum	nominal