AN008

Properties of Attributes in entity 5 table: Stream habitat measurements (depth and substrate size)

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	5.-5.		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		Sep 3 2014-Jul 22 2016		date as date type
TRANSECT_M	Y	N	char(2)	enum	ordinal
SAMPLE_PT	Y	N	numeric(2,0)	range	ratio	natural	1.-56.		number
SUBSTRATE_MM	N	Y	numeric(7,1)	range	ratio	real	0.1-2000.0		millimeters
DEPTH_CM	N	Y	numeric(7,1)	range	ratio	real	0.0-1000.0		centimeters
NOTES	N	Y	varchar(200)	freetext	nominal