AS006

Properties of Attributes in entity 2 table: Habitat dimensions

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	2.-2.		number
YEAR	Y	Y	numeric(4,0)	range	interval	whole	1987.-2022.		number
SITECODE	Y	Y	char(8)	place	nominal
SECTION	Y	N	char(2)	enum	nominal
REACH	Y	N	char(1)	enum	nominal
UNITNUM	Y	Y	numeric(4,1)	range	ratio	real	1.0-20.0		number
UNITTYPE	Y	Y	char(3)	enum	nominal
LENGTH	N	Y	numeric(4,1)	range	ratio	real	1.0-57.1		meters
WIDTH1	N	Y	numeric(4,1)	range	ratio	real	0.3-9.4		meters
WIDTH2	N	Y	numeric(4,1)	range	ratio	real	0.2-10.9		meters
WIDTH3	N	Y	numeric(4,1)	range	ratio	real	0.1-12.5		meters
WIDTH4	N	Y	numeric(4,1)	range	ratio	real	0.2-11.3		meters
WIDTH5	N	Y	numeric(3,1)	range	ratio	real	0.2-11.0		meters
DEPTH1	N	Y	numeric(4,2)	range	ratio	real	0.01-0.70		meters
DEPTH2	N	Y	numeric(4,2)	range	ratio	real	0.01-0.92		meters
DEPTH3	N	Y	numeric(4,2)	range	ratio	real	0.01-0.68		meters
DEPTH4	N	Y	numeric(4,2)	range	ratio	real	0.01-0.86		meters
DEPTH5	N	Y	numeric(4,2)	range	ratio	real	0.01-0.74		meters
DEPTH6	N	Y	numeric(4,2)	range	ratio	real	0.01-0.88		meters
DEPTH7	N	Y	numeric(4,2)	range	ratio	real	0.01-0.76		meters
DEPTH8	N	Y	numeric(4,2)	range	ratio	real	0.02-0.88		meters
DEPTH9	N	Y	numeric(4,2)	range	ratio	real	0.01-1.02		meters
DEPTH10	N	Y	numeric(4,2)	range	ratio	real	0.01-0.96		meters
DEPTH11	N	Y	numeric(4,2)	range	ratio	real	0.01-0.79		meters
DEPTH12	N	Y	numeric(4,2)	range	ratio	real	0.02-1.02		meters
DEPTH13	N	Y	numeric(4,2)	range	ratio	real	0.01-0.68		meters
DEPTH14	N	Y	numeric(4,2)	range	ratio	real	0.01-0.53		meters
DEPTH15	N	Y	numeric(4,2)	range	ratio	real	0.01-0.59		meters
DEPTH16	N	Y	numeric(4,2)	range	ratio	real	0.03-0.95		meters
DEPTH17	N	Y	numeric(4,2)	range	ratio	real	0.01-0.61		meters
DEPTH18	N	Y	numeric(4,2)	range	ratio	real	0.01-0.60		meters
DEPTH19	N	Y	numeric(4,2)	range	ratio	real	0.01-0.90		meters
DEPTH20	N	Y	numeric(4,2)	range	ratio	real	0.02-1.00		meters
MAXDEPTH	N	Y	numeric(4,2)	range	ratio	real	0.07-1.10		meters
SAMPLEDATE	N	N	datetime	range	datetime		Oct 6 1987-Sep 8 2022		date as date type
NOTES	N	Y	varchar(150)	freetext	nominal