SS001

Properties of Attributes in entity 1 table: Record of Public Communications at the HJ Andrews Experimental Forest

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
PUB_NO	Y	N	numeric(5,0)	range	interval	whole	2283.-3638.		number
YEAR	N	N	numeric(4,0)	range	interval	whole	1980.-2002.		year (yyyy)
AUTHOR	N	N	varchar(75)	freetext	nominal
TITLE	N	N	varchar(254)	freetext	nominal
WORKFORM	N	N	char(1)	enum	nominal
CONTEXT	N	N	char(8)	enum	nominal
OUTLET	N	N	char(18)	enum	nominal
OUTLET_SUM	N	N	char(9)	enum	nominal
OUT_COMM	N	Y	char(50)	freetext	nominal
SITE	N	N	varchar(4)	enum	nominal
SITE_PTS	N	N	numeric(1,0)	range	interval	whole	0.-3.		number
SITE_COMM	N	Y	varchar(75)	freetext	nominal
PERSONL	N	N	char(4)	enum	nominal
PERS_PTS	N	N	numeric(1,0)	range	interval	whole	0.-3.		number
PERS_COMM	N	Y	varchar(90)	freetext	nominal
INIT	N	Y	char(23)	enum	nominal
INIT_SUM	N	N	char(18)	enum	nominal
INIT_COMM	N	Y	char(100)	freetext	nominal
TOT_PTS	N	Y	numeric(1,0)	range	interval	whole	0.-6.		number