TP073

Properties of Attributes in entity 3 table: Tagged trees: diameter, vigor, and status including mortality

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.	1.	number
YEAR	Y	N	numeric(4,0)	range	interval	natural	1979.-2021.	1.	number
PLOTID	Y	Y	char(6)	place	nominal
WATERSHED	N	N	char(4)	place	nominal
UNIT	N	N	char(2)	enum	nominal
TRANSECT	N	N	char(1)	enum	ordinal
PLOT	N	N	numeric(2,0)	range	ratio	integer	1.-27.	1.	number
QUARTER	Y	N	numeric(1,0)	range	ratio	natural	1.-4.		number
TAG	Y	Y	numeric(5,0)	range	ratio	natural	1.-10000.	1.	number
CLUMP	Y	Y	numeric(5,0)	range	ratio	natural	2.-9988.		number
NEARTAG	N	Y	numeric(5,0)	range	ratio	natural	1.-10000.		number
OLDTAG	N	Y	numeric(5,0)	range	ratio	natural	1.-10000.		number
TREE_SPP	Y	N	char(6)	taxa	nominal
CLPCLASS	Y	Y	char(1)	enum	nominal
STEMCOUNT	N	Y	numeric(3,0)	range	ratio	whole	0.-30.		number
BDIA	N	Y	numeric(5,1)	range	ratio	real	0.2-27.0	0.1	centimeters
HDIA	N	Y	numeric(5,1)	range	ratio	real	0.3-140.0	0.1	centimeters
VIGOR	N	Y	char(1)	enum	nominal
STATUS	N	Y	char(1)	enum	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Jun 21 1979-Nov 3 2021		date as date type
COMMENTS	N	Y	varchar(200)	freetext	nominal