TP088

Properties of Attributes in entity 2 table: Tree measurements

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	freetext	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	2.-2.		number
SITE	Y	N	char(4)	place	nominal
DENSITY	Y	N	char(1)	enum	nominal
TMT	Y	N	char(2)	enum	nominal
GROWTHYR	N	Y	numeric(4,0)	range	ratio	natural	1981.-1981.		year (yyyy)
YEAR	Y	N	numeric(4,0)	range	ratio	natural	1981.-1996.		year (yyyy)
TREENO	Y	N	numeric(3,0)	range	ratio	natural	1.-290.		number
SPECIES	N	Y	char(4)	taxa	nominal
STATE	N	Y	char(1)	enum	nominal
DBH	N	Y	numeric(5,1)	range	ratio	real	0.4-50.5	0.1	centimeters
HEIGHT	N	Y	numeric(4,1)	range	ratio	real	1.2-25.6	0.1	meters
BARK1	N	Y	numeric(3,0)	range	ratio	natural	0.-19.		millimeters
GR1	N	Y	numeric(3,0)	range	ratio	natural	1.-22.		millimeters
PRE1	N	Y	numeric(3,0)	range	ratio	whole	4.-55.		millimeters
TOT1	N	Y	numeric(3,0)	range	ratio	whole	7.-92.		millimeters
SAP1	N	Y	numeric(3,0)	range	ratio	whole	8.-85.		millimeters
BARK2	N	Y	numeric(3,0)	range	ratio	natural	2.-16.		millimeters
GR2	N	Y	numeric(3,0)	range	ratio	natural	1.-50.		millimeters
PRE2	N	Y	numeric(3,0)	range	ratio	whole	0.-55.		millimeters
TOT2	N	Y	numeric(3,0)	range	ratio	whole	2.-116.		millimeters
SAP2	N	Y	numeric(3,0)	range	ratio	whole	2.-90.		millimeters
FLAGBAD	N	Y	char(1)	enum	nominal
MEASDATE	N	Y	char(1)	enum	nominal
COND	N	Y	char(1)	enum	nominal
NOTES	N	Y	varchar(40)	freetext	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Aug 15 1981-Sep 15 1996		date as date type