AN008

Properties of Attributes in entity 2 table: Measurements of macroconsumers within treatment reach

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
YEAR	N	N	numeric(4,0)	range	interval	natural	2014.-2016.		year (yyyy)
SITE_NUMBER	Y	N	char(8)	place	ordinal
REACH_TREATMENT	Y	N	char(1)	enum	nominal
SAMPLING_DATE	Y	N	datetime	range	datetime		Aug 14 2014-Aug 17 2016		date as date type
DAY_OF_EXPERIMENT	N	N	numeric(2,0)	range	ratio	natural	1.-50.		number
PASS	Y	N	numeric(2,0)	range	interval	natural	1.-11.		number
DIRECTION	Y	N	char(1)	enum	nominal
SPECIES	Y	N	char(3)	taxa	nominal
VERT_INDEX	Y	N	numeric(3,0)	range	ratio	natural	1.-172.		number
LENGTH2_AMPHIBS	N	Y	numeric(4,0)	range	ratio	real	1.-200.		millimeters
LENGTH	N	Y	numeric(4,0)	range	ratio	real	1.-300.		millimeters
WEIGHT	N	Y	numeric(7,1)	range	ratio	real	0.1-200.0		grams
FROG_DEV_STAGE	N	N	char(3)	enum	nominal
NOTES	N	Y	varchar(200)	freetext	nominal
QA_NOTES	N	Y	varchar(200)	freetext	nominal