TP114

Properties of Attributes in entity 1 table: Individual tree remeasurement

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(10)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	1.-1.	1.	number
TREEID	Y	N	char(13)	freetext	nominal
WATERSHED	Y	N	char(10)	place	nominal
PLOTID	Y	N	char(8)	place	nominal
PLOT	N	N	numeric(2,0)	range	ratio	integer	1.-70.	1.	number
SPECIES	Y	N	char(8)	taxa	nominal
TAG	Y	N	numeric(4,0)	range	ratio	integer	1.-1000.	1.	number
YEAR	Y	N	numeric(4,0)	range	ratio	integer	2002.-2050.	1.	year (yyyy)
TREE_STATUS	N	N	char(1)	enum	nominal
DBH	N	N	numeric(5,1)	range	ratio	real	5.0-60.0	0.1	centimeters
DBH_CODE	N	N	char(1)	enum	nominal
CANOPY_CLASS	N	N	char(1)	enum	nominal
TREE_VIGOR	N	N	char(1)	enum	nominal
CROWN_RATIO	N	Y	numeric(3,0)	range	ratio	integer	0.-100.	1.	number
MAIN_STEM	N	N	char(1)	enum	nominal
ROOTING	N	N	char(1)	enum	nominal
CROWN_PCT	N	Y	numeric(3,0)	range	ratio	whole	0.-100.	5.	percent
TREE_PCT	N	Y	numeric(3,0)	range	ratio	whole	0.-100.	5.	percent
LEAN_ANGLE	N	Y	numeric(3,0)	range	ratio	whole	0.-13.	5.	degrees angle
SAMPLEDATE	N	Y	datetime	range	datetime				date as date type
CHECK_NOTES	N	Y	char(250)	freetext	nominal