AS011

Properties of Attributes in entity 2 table: Stream habitat measuremets

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	2016.-2019.		year (yyyy)
DATE	Y	N	datetime	range	datetime		Jul 29 2016-Aug 15 2019		date as date type
STREAM	Y	N	char(10)	place	ordinal
SITE	Y	N	varchar(30)	enum	nominal
SITE_CODE	Y	N	char(10)	place	ordinal
TRANSECT	Y	N	numeric(3,0)	range	ratio	whole	0.-100.		meters
REACH_SECTION	Y	N	char(1)	enum	nominal
WETTED_WIDTH	N	Y	numeric(4,0)	range	ratio	real	0.-1260.		centimeters
DEPTH_1	N	Y	numeric(5,1)	range	ratio	real	0.0-150.0		centimeters
DEPTH_2	N	Y	numeric(4,1)	range	ratio	real	0.0-150.0		centimeters
DEPTH_3	N	Y	numeric(4,1)	range	ratio	real	0.0-150.0		centimeters
DEPTH_4	N	Y	numeric(4,1)	range	ratio	real	0.0-150.0		centimeters
DEPTH_5	N	Y	numeric(4,1)	range	ratio	real	0.0-150.0		centimeters
MAX_DEPTH	N	Y	numeric(5,1)	range	ratio	real	0.0-150.0		centimeters
REACH_LENGTH	N	Y	numeric(3,0)	range	ratio	natural	45.-100.		meters
NOTES	N	Y	varchar(254)	freetext	nominal