TD022

Properties of Attributes in entity 1 table: Log and Snag 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
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	1980.-2001.	1.	year (yyyy)
NUMBER	Y	N	char(5)	freetext	nominal
SPECIES	N	N	char(4)	taxa	nominal
POSITION	N	N	char(1)	enum	nominal
DECAY	N	Y	char(1)	enum	nominal
AGE	N	Y	numeric(3,0)	range	ratio	integer	0.-500.	1.	number of years
METHOD	N	Y	char(1)	enum	nominal
CAUSE	N	N	char(2)	enum	nominal
DBH	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
BD	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
TD	N	Y	numeric(3,0)	range	ratio	integer	1.-100.	1.	centimeters
LENGTH	N	Y	numeric(4,1)	range	ratio	real	0.1-60.0	0.1	meters
BCOVER	N	Y	numeric(3,0)	range	ratio	integer	0.-100.	1.	percent
VOLMISS	N	Y	numeric(9,6)	range	ratio	real	0.0000-0.8200	0.005000	cubic centimeters
DS1	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
HS1	N	Y	numeric(4,1)	range	ratio	real	0.1-50.0	0.1	meters
DS2	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
HS2	N	Y	numeric(4,1)	range	ratio	real	0.1-50.0	0.1	meters
DS3	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
HS3	N	Y	numeric(4,1)	range	ratio	real	0.1-50.0	0.1	meters
DS4	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
HS4	N	Y	numeric(4,1)	range	ratio	real	0.1-50.0	0.1	meters
DS5	N	Y	numeric(3,0)	range	ratio	integer	1.-200.	1.	centimeters
HS5	N	Y	numeric(4,1)	range	ratio	real	0.1-50.0	0.1	meters
CURVOL	N	Y	numeric(9,6)	range	ratio	real	0.0100-50.0000	0.000000	cubic centimeters
ORIGVOL	N	Y	numeric(9,6)	range	ratio	real	0.0100-50.0000	0.000000	cubic centimeters
SAMPLEDATE	N	N	date	range	datetime		Sep 1 1982-Jun 24 1994		date as date type