SA001

Properties of Attributes in entity 1 table: List of Insects and other Arthropods from Parson's et al.

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
STCODE	N	N	char(5)	freetext	nominal
FORMAT	N	N	numeric(1,0)	range	interval	natural	1.-1.	1.	number
CLASS	Y	N	varchar(30)	freetext	nominal
TAX_ORDER	Y	N	varchar(25)	freetext	nominal
FAMILY	Y	N	varchar(35)	freetext	nominal
SCI_NAME	Y	N	varchar(55)	taxa	nominal
AUTHOR	N	Y	varchar(25)	freetext	nominal
ADULT_HAB	N	Y	char(4)	enum	nominal
IMMAT_HAB	N	Y	char(4)	enum	nominal
ADULT_FUNC	N	Y	char(2)	enum	nominal
IMMAT_FUNC	N	Y	char(2)	enum	nominal
HOSTTYPE	N	Y	char(1)	enum	nominal
HOST	N	Y	char(7)	enum	nominal
ABUNDANCE	N	Y	char(1)	enum	nominal
COLLECTION	N	Y	char(2)	enum	nominal
REFERENCE	N	Y	char(15)	enum	nominal