SS009

Properties of Attributes in entity 1 table: Inventory of oral history collections - interviews regarding the HJ Andrews Experimental Forest, the Northwest Forest Plan, and miscellaneous topics

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	1.-1.	1.	number
COLLECTION	Y	N	char(10)	enum	nominal
INTERVIEW_CODE	Y	N	char(20)	freetext	nominal
YEAR	N	Y	numeric(4,0)	range	interval	natural	1991.-2017.	1.	year (yyyy)
DATE	N	Y	datetime	range	datetime		Nov 22 1991-Feb 17 2018		date as date type
INTERVIEWEE	N	N	char(35)	freetext	nominal
ROLE	N	N	char(25)	enum	nominal
INSTITUTION	N	N	char(10)	enum	nominal
INTERVIEWER	N	N	char(8)	enum	nominal
EDITOR	N	N	char(15)	enum	nominal
TRANSCRIBER	N	N	char(8)	enum	nominal
MEDIA_TYPE	N	N	char(5)	enum	nominal
TRANSCRIPT_PAGES	N	Y	numeric(3,0)	range	ratio	whole	0.-55.		number
TRANSCRIPT_WORDS	N	Y	numeric(6,0)	range	ratio	whole	0.-35000.		number
FILE_NAME	N	Y	char(35)	freetext	nominal
NOTES	N	Y	char(254)	freetext	nominal