SA025

Properties of Attributes in entity 3 table: Beetle 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	3.-3.		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	2012.-2014.		year (yyyy)
TRAP_NO	Y	N	numeric(2,0)	range	ratio	natural	1.-13.		number
REP	Y	N	char(1)	enum	nominal
SET_DATE	N	N	datetime	range	datetime		May 3 2012-Jun 25 2014		date as date type
PICKUP_DATE	N	N	datetime	range	datetime		May 9 2012-Jul 2 2014		date as date type
DAYS_SET	N	N	numeric(2,0)	range	ratio	natural	2.-12.		number
TOTAL_BEETLE	N	Y	numeric(3,0)	range	ratio	whole	0.-999.		number
TOTAL_FUNGUS_GNAT	N	Y	numeric(3,0)	range	ratio	whole	0.-818.		number
COMMENTS	N	Y	varchar(100)	freetext	nominal