TD025

Properties of Attributes in entity 3 table: Bulk Cations

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	3.-3.	1.	number
STUDYID	N	N	char(3)	enum	nominal
SMONTH	Y	N	numeric(2,0)	range	datetime		1.-12.	1.	month of year
SYEAR	Y	N	numeric(4,0)	range	datetime		1987.-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		1987.-2050.	1.	year (yyyy)
BULKTIME	N	N	numeric(1,0)	range	ratio	natural	1.-99.	1.	number
SPECIES	N	Y	char(4)	taxa	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	32.-505.	1.	number
FTYPE	Y	N	char(1)	enum	nominal
AL	N	N	numeric(6,2)	range	interval	real	0.00-20.00	0.01	parts per million
B	N	N	numeric(5,2)	range	ratio	real	0.00-2.00	0.01	parts per million
CA	N	N	numeric(6,2)	range	ratio	real	0.00-10.00	0.01	parts per million
CU	N	N	numeric(4,2)	range	ratio	real	0.00-2.00	0.01	parts per million
FE	N	N	numeric(4,2)	range	ratio	real	0.00-2.00	0.01	parts per million
K	N	N	numeric(5,2)	range	ratio	real	0.00-15.00	0.01	parts per million
MG	N	N	numeric(5,2)	range	ratio	real	0.00-10.00	0.01	parts per million
MN	N	N	numeric(6,4)	range	ratio	real	0.0000-10.0000	0.0001	parts per million
NA	N	Y	numeric(5,2)	range	ratio	real	0.00-10.00	0.01	parts per million
P	N	N	numeric(6,2)	range	ratio	real	0.00-10.00	0.01	parts per million
S	N	N	numeric(5,2)	range	ratio	real	0.00-10.00	0.01	parts per million
ZN	N	N	numeric(4,2)	range	ratio	real	0.00-10.00	0.01	parts per million