HS005

Properties of Attributes in entity 1 table: Nutrient and microbial data

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	1.-1.		number
REFNAME	Y	N	char(4)	freetext	nominal
SAMPLEDATE	Y	N	datetime	range	datetime		Aug 9 1995-May 12 1996		date as date type
TREAT	N	Y	char(2)	enum	nominal
ELEV	N	Y	char(1)	enum	nominal
ASPEC	N	Y	char(1)	enum	nominal
RESPS	N	N	numeric(6,2)	range	ratio	real	1.98-213.42	0.01	micrograms per gram per hour
DENPOT	N	N	numeric(6,2)	range	ratio	real	0.00-180.70	0.01	micrograms per gram per hour
EXTR_AMM	N	N	numeric(6,2)	range	ratio	real	0.00-54.52	0.01	micrograms per gram per day
MIN_N	N	Y	numeric(5,0)	range	ratio	real	0.-562.	1.	micrograms per gram per day
N2FS	N	Y	numeric(6,1)	range	ratio	real	0.0-7345.2	0.1	micromoles per gram per hour
CARBOS	N	Y	numeric(5,0)	range	ratio	real	50.-773.	1.	micrograms per gram per hour
ORGANICP	N	Y	numeric(6,3)	range	ratio	real	-0.010-3.480	0.001	micrograms per gram per day
C_N_RATIO	N	N	numeric(2,0)	range	ratio	real	11.-33.	1.	number
BETAG	N	N	numeric(6,2)	range	ratio	real	3.36-396.15	0.01	micromoles per gram per hour
PHOS	N	Y	numeric(6,1)	range	ratio	real	19.9-490.7	0.1	micromoles per gram per hour