SA025

Properties of Attributes in entity 2 table: Aquatic Insect Emergence 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	2.-2.		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.-26.		number
SET_DATE	N	N	datetime	range	datetime		Apr 9 2009-Jun 26 2014		date as date type
PICKUP_DATE	N	N	datetime	range	datetime		Apr 15 2009-Jun 30 2014		date as date type
DAYS_SET	N	N	numeric(2,0)	range	ratio	natural	2.-12.		number
TRAPS_PICKED_UP	N	Y	numeric(3,1)	range	ratio	real	1.0-4.0		number
AREA_SAMPLED	N	Y	numeric(4,2)	range	ratio	real	0.30-1.20		square meters
TOTAL_AQUATIC_ADULTS	N	Y	numeric(3,0)	range	ratio	natural	1.-724.		number
ALLOPERLA_FRATERNA	N	N	numeric(2,0)	range	ratio	whole	0.-77.		number
DOLOPHILODES_DORCUS	N	N	numeric(2,0)	range	ratio	whole	0.-17.		number
PARALEPTOPHLEBIA_TEMPORALIS	N	N	numeric(2,0)	range	ratio	whole	0.-32.		number
MOSELIA_INFUSCATA	N	N	numeric(2,0)	range	ratio	whole	0.-84.		number
COMMENTS	N	Y	varchar(100)	freetext	nominal