TD022

Properties of Attributes in entity 4 table: Tissue Nutrient Content

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	4.-4.	1.	number
STUDYID	Y	N	char(4)	enum	nominal
STAND	Y	N	char(4)	place	nominal
PLOT	Y	N	char(10)	freetext	nominal
YEAR	Y	N	numeric(4,0)	range	ratio	integer	1982.-1993.	1.	year (yyyy)
SAMPLE_NO	Y	N	numeric(1,0)	range	interval	natural	1.-6.		number
NUMBER	Y	N	char(5)	freetext	nominal
N	N	N	numeric(6,2)	range	ratio	real	0.01-1.63	0.01	percent
TISSUE	Y	N	char(1)	enum	nominal
AL	N	N	numeric(7,1)	range	ratio	real	1.0-2500.0	0.1	parts per million
B	N	N	numeric(6,1)	range	ratio	real	0.5-195.0	0.1	parts per million
CA	N	N	numeric(8,1)	range	ratio	real	225.0-75000.0	0.1	parts per million
CU	N	N	numeric(6,1)	range	ratio	real	0.0-1200.0	0.1	parts per million
FE	N	N	numeric(7,1)	range	ratio	real	2.0-5776.8	0.1	parts per million
K	N	N	numeric(8,0)	range	ratio	integer	66.-37400.	1.	parts per million
MG	N	N	numeric(7,1)	range	ratio	real	13.0-5000.0	0.1	parts per million
MN	N	N	numeric(7,1)	range	ratio	real	0.0-1400.7	0.1	parts per million
P	N	N	numeric(7,1)	range	ratio	real	3.3-5058.7	0.1	parts per million
S	N	N	numeric(6,1)	range	ratio	real	0.0-0.0	0.1	parts per million
ZN	N	N	numeric(8,1)	range	ratio	real	1.0-650.9	0.1	parts per million
NA	N	N	numeric(8,1)	range	ratio	real	0.0-4800.0	0.1	parts per million
LAB	N	N	char(3)	enum	nominal
SAMPLEDATE	Y	N	date	range	datetime		Sep 1 1982-May 19 1993		date as date type