TD025

Properties of Attributes in entity 2 table: Bulk Nitrogen and DOC

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
STUDYID	N	N	char(3)	enum	nominal
SITE	N	N	char(1)	enum	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	32.-505.	1.	number
SPECIES	N	Y	char(4)	taxa	nominal
FTYPE	Y	N	char(1)	enum	nominal
SMONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
SYEAR	Y	N	numeric(4,0)	range	datetime		1950.-2050.	1.	year (yyyy)
EMONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
EYEAR	Y	N	numeric(4,0)	range	datetime		1950.-2050.	1.	year (yyyy)
BULKTIME	N	N	numeric(1,0)	range	ratio	natural	1.-99.	1.	number
DOC	N	Y	numeric(7,2)	range	ratio	real	0.00-200.00	0.01	parts per million
TKN	N	Y	numeric(6,3)	range	ratio	real	0.010-2.000	0.001	parts per million
NO3	N	Y	numeric(6,4)	range	ratio	real	0.0001-0.0500	0.0001	parts per million