TD021

Properties of Attributes in entity 4 table: Nutrient content data

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	4.-4.	1.	number
SITE	Y	N	char(3)	place	nominal
TIME	Y	Y	numeric(2,0)	range	ratio	integer	0.-10.	1.	number of years
SPECIES	Y	N	char(4)	taxa	nominal
SIZE	Y	N	char(2)	enum	nominal
SAMPLE_NO	Y	N	numeric(1,0)	range	ratio	integer	1.-6.	1.	number
DATE	N	N	datetime	range	datetime		Mar 9 1989-Feb 20 1994		date as date type
N	N	Y	numeric(4,2)	range	ratio	real	0.20-2.27		number
AL	N	Y	numeric(4,0)	range	ratio	real	3.-2157.		parts per million
B	N	Y	numeric(2,0)	range	ratio	real	2.-95.		parts per million
CA	N	Y	numeric(6,0)	range	ratio	real	1000.-100000.		parts per million
CU	N	Y	numeric(3,1)	range	ratio	real	1.0-8.9		parts per million
FE	N	Y	numeric(4,0)	range	ratio	real	5.-2000.		parts per million
K	N	Y	numeric(5,0)	range	ratio	real	400.-45900.		parts per million
MG	N	Y	numeric(5,0)	range	ratio	real	300.-17000.		parts per million
MN	N	Y	numeric(3,0)	range	ratio	real	1.-140.		parts per million
P	N	Y	numeric(4,0)	range	ratio	real	30.-3430.		parts per million
ZN	N	Y	numeric(3,0)	range	ratio	real	1.-101.		parts per million
NA	N	Y	numeric(4,0)	range	ratio	real	88.-1472.		parts per million
OSU_NO	N	Y	numeric(4,0)	range	ratio	integer	1.-4459.	1.	number