TD017

Properties of Attributes in entity 1 table: Log Descriptions Including Length, Diameters, Bark Cover

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	freetext	nominal
ENTITY	N	N	numeric(1,0)	range	interval	natural	1.-1.	1.	number
STUDYID	N	N	char(3)	place	nominal
YEAR	Y	N	numeric(4,0)	range	interval	integer	1985.-2015.	1.	number
NUMBER	Y	N	numeric(3,0)	range	ratio	integer	0.-280.	1.	number
SPECIES	N	N	char(4)	taxa	nominal
LOCATION	N	N	char(1)	enum	nominal
POSITION	N	Y	char(3)	freetext	nominal
LENGTH	N	N	numeric(3,0)	range	ratio	integer	150.-270.	1.	centimeters
BARKCOVER	N	N	numeric(3,0)	range	ratio	integer	0.-100.	5.	percent
X0	N	N	numeric(3,0)	range	ratio	integer	0.-0.	1.	centimeters
DM0	N	N	numeric(3,0)	range	ratio	integer	109.-330.	2.	millimeters
X1	N	Y	numeric(3,0)	range	ratio	integer	10.-53.	1.	centimeters
DM1	N	Y	numeric(3,0)	range	ratio	integer	109.-312.	2.	millimeters
X2	N	Y	numeric(3,0)	range	ratio	integer	40.-94.	1.	centimeters
DM2	N	Y	numeric(3,0)	range	ratio	integer	87.-308.	2.	millimeters
X3	N	Y	numeric(3,0)	range	ratio	integer	65.-140.	1.	centimeters
DM3	N	Y	numeric(3,0)	range	ratio	integer	17.-306.	2.	millimeters
X4	N	Y	numeric(3,0)	range	ratio	integer	91.-221.	1.	centimeters
DM4	N	Y	numeric(3,0)	range	ratio	integer	25.-303.	2.	millimeters
X5	N	Y	numeric(3,0)	range	ratio	integer	120.-255.	1.	centimeters
DM5	N	Y	numeric(3,0)	range	ratio	integer	0.-303.	2.	millimeters
X6	N	Y	numeric(3,0)	range	ratio	integer	147.-262.	1.	centimeters
DM6	N	Y	numeric(3,0)	range	ratio	integer	0.-298.	2.	millimeters
X7	N	N	numeric(3,0)	range	ratio	integer	150.-270.	1.	centimeters
DM7	N	N	numeric(3,0)	range	ratio	integer	0.-318.	2.	millimeters
SAMPLEDATE	N	N	datetime	range	datetime		Jun 19 1985-Nov 10 2015		date as date type