SA025

Properties of Attributes in entity 4 table: Aquatic Insect Emergence Genus 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	4.-4.		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	2011.-2011.		year (yyyy)
TRAP_NO	Y	N	numeric(2,0)	range	ratio	natural	1.-26.		number
SET_DATE	Y	N	datetime	range	datetime		Apr 5 2011-Jul 5 2011		date as date type
PICKUP_DATE	N	N	datetime	range	datetime		Apr 11 2011-Jul 8 2011		date as date type
DAYS_SET	Y	N	numeric(2,0)	range	ratio	natural	2.-6.		number
TRAPS_PICKED_UP	N	N	numeric(3,1)	range	ratio	real	3.0-4.0		number
AREA_SAMPLED	N	N	numeric(4,2)	range	ratio	real	0.90-1.20		square meters
TAXON	Y	N	char(25)	taxa	nominal
TAXON_COUNT	N	N	numeric(3,0)	range	ratio	natural	1.-150.		number
COMMENTS	N	Y	varchar(100)	freetext	nominal