AS010

Properties of Attributes in entity 2 table: Invertebrate raw data (ID and measurements) from surber sample surveys

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	ratio	natural	2.-2.		number
SITE	Y	N	char(6)	place	ordinal
REACH_TYPE	Y	N	char(2)	enum	nominal
DATE	Y	N	datetime	range	datetime		Jul 10 2014-Jul 29 2014		date as date type
INVERT_NO	Y	N	numeric(4,0)	range	ratio	natural	1.-555.		number
LR_SUB	N	N	char(3)	enum	nominal
SUBSAMPLE_AREA	N	N	numeric(6,4)	range	ratio	real	0.0469-0.3750		square meters
SUBSAMPLE_PROPORTION	N	N	numeric(6,4)	range	ratio	real	0.1250-1.0000		number
TAXA	N	N	varchar(30)	taxa	ordinal
TAXA_RANK	N	N	char(10)	enum	ordinal
INV_LIFESTAGE	N	N	char(1)	enum	ordinal
MAG	N	N	numeric(4,2)	range	ratio	real	0.63-6.00		number
INVERT_LENGTH	N	N	numeric(4,1)	range	ratio	real	0.2-34.0		millimeters
CONVERTED_LENGTH	N	N	numeric(5,2)	range	ratio	real	0.10-34.00		millimeters
TOT_CNT	N	N	numeric(2,0)	range	ratio	real	1.-88.		number