CP002

Properties of Attributes in entity 6 table: Precipitation water sample log sheet: field and laboratory comments

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
STCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	6.-6.	1.	number
SITECODE	Y	N	char(6)	place	nominal
WATERYEAR	N	N	numeric(4,0)	range	interval	natural	1969.-2022.	1.	number
DATE_TIME	Y	N	datetime	range	datetime		Oct 9 1968 9:52AM-Jun 28 2022 6:55PM		date as datetime type
LABNO	N	Y	char(4)	freetext	nominal
TYPE	N	N	char(2)	enum	nominal
QCCODE	N	N	char(2)	enum	nominal
QA_SAMPLE	N	Y	char(6)	freetext	nominal
SAMPLER_TYPE	N	N	char(2)	enum	nominal
LOW_VOLUME	N	N	char(1)	enum	nominal
FIELD_COMMENTS	N	Y	char(254)	freetext	nominal
LAB_COMMENTS	N	Y	char(254)	freetext	nominal
SEQ_INDEX	N	N	numeric(5,0)	range	ratio	natural	1.-9711.	1.	number