TD014

Properties of Attributes in entity 3 table: Sample volume, moisture, and density

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	3.-3.	1.	number
SITECODE	N	Y	char(10)	place	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	1.-900.	1.	number
LOG_SPECIES	N	Y	char(4)	taxa	nominal
SECTION	Y	N	char(1)	enum	nominal
TIME	Y	N	numeric(3,0)	range	ratio	whole	0.-30.	1.	number of years
YEAR	N	N	numeric(4,0)	range	interval	integer	1985.-2016.	1.	year (yyyy)
SUBTYPE	Y	N	char(1)	enum	nominal
RADPOS	Y	Y	numeric(2,0)	range	ratio	whole	0.-45.	1.	number
SHAPE	N	Y	char(1)	enum	nominal
D1	N	Y	numeric(5,1)	range	ratio	real	1.0-293.0	0.1	millimeters
D2	N	Y	numeric(6,1)	range	ratio	real	1.0-1757.0	0.1	millimeters
D3	N	Y	numeric(5,1)	range	ratio	real	15.0-703.0	0.1	millimeters
D4	N	Y	numeric(4,1)	range	ratio	real	0.0-90.0		degrees angle
VOL1	N	Y	numeric(5,1)	range	ratio	real	2.0-1449.0	0.1	milliliters
VOL2	N	Y	numeric(5,1)	range	ratio	real	0.2-774.0	0.1	milliliters
AIRAREA	N	Y	numeric(5,1)	range	ratio	real	0.0-1990.0	10.0	square millimeters
WETWT	N	Y	numeric(6,2)	range	ratio	real	0.00-567.60	0.10	grams
DRYWT	N	Y	numeric(6,2)	range	ratio	real	0.01-492.00	0.10	grams
MOIST	N	Y	numeric(5,1)	range	ratio	real	0.0-1422.2	0.1	percent
DEN1	N	Y	numeric(5,3)	range	ratio	real	0.001-36.040	0.000	grams per milliliter
DEN2	N	Y	numeric(5,3)	range	ratio	real	0.153-1.128	0.000	grams per milliliter
KNOTVOL	N	Y	numeric(3,0)	range	ratio	natural	0.-80.	1.	percent
SAMPLEDATE	Y	N	datetime	range	datetime		Jan 15 1985-Oct 1 2016		date as date type
COMMENTS_LAB	N	Y	char(254)	freetext	nominal