TV010

Properties of Attributes in entity 2 table: Individual tree remeasurement

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	whole	2.-2.	1.	number
TREEID	N	N	char(13)	freetext	nominal
PSP_STUDYID	Y	N	char(4)	place	nominal
STANDID	Y	N	char(4)	place	nominal
PLOTNUMBER	Y	N	numeric(4,0)	range	interval	natural	0.-1005.		number	9999
QUARTER	N	N	char(1)	enum	ordinal
SPECIES	N	N	char(6)	taxa	nominal
TAG	Y	N	numeric(7,0)	range	interval	whole	0.-9999999.	1.	number	99999
YEAR	Y	N	numeric(4,0)	range	interval	natural	1910.-2023.	1.	number
TREE_STATUS	N	N	char(1)	enum	nominal
DBH	N	Y	numeric(6,1)	range	ratio	real	0.1-625.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	whole	0.-100.	1.	percent
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.-130.	5.	degrees angle
SAMPLEDATE	N	N	datetime	range	datetime		Feb 1 1910-Aug 1 2023		date as date type
CHECK_NOTES	N	Y	varchar(250)	freetext	nominal
DB_NOTES	N	Y	char(254)	freetext	nominal