SA025

Properties of Attributes in entity 1 table: Malaise Trap data

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	interval	natural	1.-1.		number
SAMPLE_ID	N	N	char(10)	freetext	nominal
TRAP_TYPE	Y	N	char(1)	enum	ordinal
SITE_ID	Y	N	char(5)	place	nominal
YEAR	Y	N	numeric(4,0)	range	interval	natural	2009.-2014.		year (yyyy)
TRAP_NO	Y	N	numeric(2,0)	range	ratio	natural	1.-14.		number
SET_DATE	N	N	datetime	range	datetime		May 5 2009-Jun 25 2014		date as date type
PICKUP_DATE	N	N	datetime	range	datetime		May 7 2009-Jul 2 2014		date as date type
DAYS_SET	N	N	numeric(2,0)	range	ratio	natural	2.-24.		number
TOTAL_WINGED	N	Y	numeric(4,0)	range	ratio	whole	0.-9999.		number
SCELLUS	N	N	numeric(2,0)	range	ratio	whole	0.-99.		number
BOLBOMYIA	N	N	numeric(2,0)	range	ratio	whole	0.-99.		number
ANASPIS	N	N	numeric(2,0)	range	ratio	whole	0.-99.		number
COMMENTS	N	Y	varchar(100)	freetext	nominal