MS004

Properties of Attributes in entity 1 table: Rain gauge inventory

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	Y	char(5)	enum	nominal
ENTITY	N	Y	numeric(2,0)	range	interval	natural	1.-1.	1.	number
SITECODE	N	Y	char(6)	place	nominal
SITENAME	N	Y	char(40)	freetext	nominal
LATITUDE	N	Y	numeric(9,6)	range	ratio	real	44.1568-44.3440	0.000010	degrees latitude or longitude
LONGITUDE	N	Y	numeric(11,6)	range	ratio	real	-122.3442--122.1062	0.000010	degrees latitude or longitude
GAGE_TYPE	N	N	char(1)	enum	nominal
RAIN_NETWORK	N	N	char(1)	enum	nominal
PROBE_CODE	Y	N	char(8)	enum	nominal
INSTRUM_CODE	N	N	char(10)	enum	nominal
DATE_BEGIN	N	N	date	range	datetime		Nov 21 1951-Feb 1 2011		date as date type
DATE_END	N	N	date	range	datetime		Mar 20 1953-Jan 1 2020		date as date type
ONGOING	N	N	char(3)	enum	nominal
DB_XREF	N	N	char(5)	enum	nominal
AVAILABILITY	N	Y	char(140)	freetext	nominal
DESCRIPTION	N	Y	char(125)	freetext	nominal