TD014

Properties of Attributes in entity 1 table: Whole Log Descriptions

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	1.-1.	1.	number
SITECODE	Y	N	char(10)	place	nominal
SITE	N	N	char(1)	enum	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	1.-900.	1.	number
LOG_SPECIES	N	N	char(4)	taxa	nominal
TREATMNT	N	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)
DIAM_END1	N	Y	numeric(5,1)	range	ratio	real	35.7-105.0		centimeters
DIAM1	N	Y	numeric(4,1)	range	ratio	real	27.5-58.0	0.1	centimeters
DIST1	N	Y	numeric(3,1)	range	ratio	real	0.2-4.1		meters
DIAM2	N	Y	numeric(4,1)	range	ratio	real	31.5-58.0	0.1	centimeters
DIST2	N	Y	numeric(3,1)	range	ratio	real	0.7-4.8		meters
DIAM_MID	N	Y	numeric(5,1)	range	ratio	real	33.3-68.0		centimeters
DIST_MID	N	Y	numeric(3,1)	range	ratio	real	2.0-3.3		meters
DIAM3	N	Y	numeric(4,1)	range	ratio	real	38.5-55.4	0.1	centimeters
DIST3	N	Y	numeric(3,1)	range	ratio	real	1.6-3.3		meters
DIAM4	N	Y	numeric(5,1)	range	ratio	real	34.8-56.5		centimeters
DIST4	N	Y	numeric(3,1)	range	ratio	real	2.3-4.2		meters
DIAM5	N	Y	numeric(5,1)	range	ratio	real	31.2-57.5		centimeters
DIST5	N	Y	numeric(3,1)	range	ratio	real	3.3-5.4		meters
DIAM_END2	N	Y	numeric(5,1)	range	ratio	real	28.5-122.0		centimeters
EST_DIAM	N	Y	char(1)	enum	nominal
LENGTH	N	Y	numeric(6,2)	range	ratio	real	2.50-6.50	0.01	meters
LENGTHUP	N	Y	numeric(6,1)	range	ratio	real	0.0-8.0	0.1	meters
BARK_MISSING	N	Y	numeric(6,1)	range	ratio	real	0.0-8.5	0.1	square meters
ORIENT	N	Y	numeric(3,0)	range	interval	whole	3.-358.	1.	degrees angle
ASPECT	N	Y	numeric(3,0)	range	interval	whole	0.-357.	1.	degrees azimuth
SLOPE	N	Y	numeric(3,0)	range	interval	whole	0.-290.	1.	percent
BRANCH	N	Y	numeric(3,0)	range	interval	whole	0.-35.	1.	number
VOLUME	N	Y	numeric(7,4)	range	ratio	real	0.4786-3.5770	0.0001	cubic meters
SURFAREA	N	Y	numeric(7,3)	range	ratio	real	6.216-12.832	0.001	square meters
SAMPLEDATE	N	N	datetime	range	datetime		Sep 8 1985-Aug 24 2016		date as date type
MOSS_COVER	N	Y	numeric(3,0)	range	interval	whole	0.-100.		percent
COMMENTS_FIELD	N	Y	char(254)	freetext	nominal