TS015

Properties of Attributes in entity 1 table: Insect counts and tree characteristics

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DATACODE	N	N	char(10)	enum	nominal
FORMAT	N	N	numeric(1,0)	range	ratio	integer	1.-1.	1.	number
SAMPLE_DATE	Y	Y	datetime	range	datetime		Jun 21 1986-Oct 11 1986		date as date type
SITE	Y	N	char(2)	enum	nominal
TRT	Y	N	char(1)	enum	nominal
SPECIES	Y	N	char(1)	enum	nominal
CANOPYL	Y	N	char(1)	enum	nominal
HEIGHT	N	Y	numeric(3,0)	range	ratio	integer	0.-69.	1.	meters
FOLWT	N	N	numeric(5,1)	range	ratio	real	2.0-127.4	0.1	grams
LICHENWT	N	Y	numeric(4,2)	range	ratio	real	0.00-7.86	0.01	grams
TWDEBWT	N	N	numeric(5,1)	range	ratio	real	1.1-138.0	0.1	grams
ADELGES	N	Y	numeric(3,0)	range	ratio	integer	0.-999.	1.	number
APHIDS	N	Y	numeric(2,0)	range	ratio	integer	0.-38.	1.	number
SCALES	N	Y	numeric(2,0)	range	ratio	integer	0.-63.	1.	number
PUTO	N	Y	numeric(1,0)	range	ratio	integer	0.-8.	1.	number
LEAFHOP	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
KLADOCE	N	Y	numeric(2,0)	range	ratio	integer	0.-26.	1.	number
MIRID	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
GASTRODES	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
THRIPS	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
PENTATOM	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
PSYLLID	N	Y	numeric(3,0)	range	ratio	integer	0.-110.	1.	number
ZEIRAPHE	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
BUDWORM	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
GEOMETR	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
BARBARA	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
DIORYCTR	N	Y	numeric(1,0)	range	ratio	integer	0.-0.	1.	number
GELECH	N	Y	numeric(1,0)	range	ratio	integer	0.-2.	1.	number
OLETHR_U	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
LEPTOGLO	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
TACHINID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
CECIDOM	N	Y	numeric(1,0)	range	ratio	integer	0.-4.	1.	number
CHIRONOM	N	Y	numeric(1,0)	range	ratio	integer	0.-2.	1.	number
SYRPHID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
NABID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
OLETHR_A	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
NEUROPT	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
MYCETOPH	N	Y	numeric(1,0)	range	ratio	integer	0.-0.	1.	number
ELATERID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
COCCINEL	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
SCOLYTID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
COLLEMBOL	N	Y	numeric(1,0)	range	ratio	integer	0.-2.	1.	number
PSOCOPTR	N	Y	numeric(2,0)	range	ratio	integer	0.-27.	1.	number
PAR_HYM	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
SAWFLY	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
ANT	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
OPILIONID	N	Y	numeric(1,0)	range	ratio	integer	0.-1.	1.	number
CAMISIA	N	Y	numeric(2,0)	range	ratio	integer	0.-21.	1.	number
OROBATID	N	Y	numeric(1,0)	range	ratio	integer	0.-8.	1.	number
BDELLID	N	Y	numeric(1,0)	range	ratio	integer	0.-5.	1.	number
ERYTHR	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
THOMISED	N	Y	numeric(1,0)	range	ratio	integer	0.-4.	1.	number
SALTICID	N	Y	numeric(1,0)	range	ratio	integer	0.-2.	1.	number
ARANEID	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number
OTHSPIDER	N	Y	numeric(1,0)	range	ratio	integer	0.-3.	1.	number