AN006

Properties of Attributes in entity 5 table: Suspended Particulate Organic Material (SPOM)

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	5.-5.		number
SITEID	Y	N	char(8)	place	ordinal
SAMPLEDATE	Y	N	datetime	range	datetime		Jul 9 1933-Jul 9 2013		date as date type
SAMPLEPERIOD	Y	N	char(9)	enum	ordinal
STATION	Y	N	char(2)	enum	ordinal
REP_NO	Y	N	char(1)	enum	nominal
DISTANCE	N	Y	numeric(4,0)	range	ratio	real	-5.-1872.		meters
DRYMASS_CONC	N	Y	numeric(8,4)	range	ratio	real	-7.7918-255.3333		milligrams per liter
AFDM_CONC	N	Y	numeric(8,4)	range	ratio	real	0.0000-93.5385		milligrams per liter
PCT_C	N	Y	numeric(5,2)	range	ratio	real	0.04-101.30		percent
PCT_N	N	Y	numeric(5,2)	range	ratio	real	-9.73-16.89		percent
D13C_SAMPLE	N	Y	numeric(5,1)	range	ratio	real	-32.0--14.5		permil
D15N_SAMPLE	N	Y	numeric(6,1)	range	ratio	real	-4.1-2133.8		permil
NOTES	N	Y	varchar(185)	freetext	nominal