TD021

Properties of Attributes in entity 3 table: Wet chemistry 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	3.-3.	1.	number
SITE	Y	N	char(3)	place	nominal
TIME	Y	N	numeric(2,0)	range	ratio	integer	0.-0.	1.	number of years
SPECIES	Y	N	char(4)	taxa	nominal
SIZE	Y	N	char(2)	enum	nominal
SOURCE	Y	N	char(2)	enum	nominal
SAMPLE_NO	Y	N	numeric(1,0)	range	ratio	integer	1.-8.	1.	number
DATE	N	N	datetime	range	datetime		Jan 10 1998-Jan 24 1998		date as date type
NIR_NUM	N	N	numeric(5,0)	range	ratio	integer	90046.-94457.	1.	number
ASH	N	Y	numeric(6,2)	range	ratio	real	0.43-2.07	0.01	percent
NPE	N	Y	numeric(6,2)	range	ratio	real	0.45-9.88	0.01	percent
WS	N	Y	numeric(6,2)	range	ratio	real	4.06-13.29	0.01	percent
ACIDSOL	N	Y	numeric(6,2)	range	ratio	real	34.71-65.38	0.01	percent
LIGNIN	N	Y	numeric(6,2)	range	ratio	real	28.28-57.28	0.01	percent
TANNIN	N	Y	numeric(6,2)	range	ratio	real	0.12-4.32	0.01	percent
WSCARB	N	Y	numeric(6,2)	range	ratio	real	0.72-3.62	0.01	percent
ASCARB	N	Y	numeric(6,2)	range	ratio	real	4.55-37.01	0.01	percent
NITROGEN	N	Y	numeric(6,2)	range	ratio	real	0.03-0.23	0.01	percent
LAB	N	N	char(3)	enum	nominal