TP041

Properties of Attributes in entity 3 table: Tagged tree measurements for all tree sizes including saplings in both microplots and macroplot

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.		number
WATERSHED	N	N	char(4)	place	nominal
PLOTID	Y	N	char(8)	place	nominal
YEAR	Y	N	numeric(4,0)	range	ratio	natural	1976.-2016.	1.	number
PLOT	N	N	numeric(2,0)	range	ratio	natural	1.-36.		number
MICROPLOT	Y	N	char(3)	enum	nominal
STEMTAG	Y	N	char(4)	freetext	nominal
CLUMPTAG	Y	Y	numeric(4,0)	range	ratio	natural	-1.-9974.		number
OLDTAG	N	Y	numeric(4,0)	range	ratio	natural	1.-9971.		number
OLDCLUMP	N	Y	numeric(4,0)	range	ratio	natural	1110.-9823.		number
NEARTAG	N	Y	numeric(4,0)	range	ratio	natural	1.-9999.		number
TREE_SPP	Y	Y	char(6)	taxa	nominal
MEASPNT	Y	N	char(1)	enum	nominal
STEMCOUNT	Y	N	numeric(3,0)	range	interval	natural	1.-100.		number
STATUS	N	Y	char(1)	enum	nominal
VIGOR	N	Y	char(1)	enum	nominal
CLPSTEMS	N	Y	numeric(2,0)	range	ratio	whole	0.-61.		number
BASDIAM	N	Y	numeric(5,1)	range	ratio	real	0.1-20.8	0.1	centimeters
DBH	N	Y	numeric(5,1)	range	ratio	real	0.0-60.0	0.1	centimeters
COMMENTS	N	Y	varchar(210)	freetext	nominal
DB_NOTES	N	Y	char(254)	freetext	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Jul 29 1976-Jul 14 2016		date as date type