SS008

Properties of Attributes in entity 2 table: HJA The Forest; scanned historical records concerning the forest itself

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	3.-3.		number
MASTER_FOLDER	Y	N	char(2)	enum	nominal
SUB_FOLDER	Y	N	char(10)	enum	nominal
DOCUMENT_NO	Y	N	numeric(4,0)	range	ratio	natural			number
TOPIC_DESCRIPTION	N	N	char(254)	freetext	nominal
DOCUMENT_CODE	N	N	varchar(20)	freetext	nominal
TITLE	N	N	varchar(100)	freetext	nominal
DESCRIPTION	N	N	varchar(254)	freetext	nominal
AUTHOR	N	N	varchar(75)	freetext	nominal
ORIGIN_DATE	N	N	varchar(50)	freetext	nominal
INSTITUTION	N	N	varchar(150)	freetext	nominal
PAGES	N	N	numeric(3,0)	range	ratio	natural			number
ORIGINAL_FORMAT_SIZE	N	N	varchar(25)	freetext	nominal
DIGITAL_FILE_NAME	N	N	varchar(25)	freetext	nominal
DIGITAL_FILE_SIZE	N	N	varchar(20)	freetext	nominal
DIGITAL_FILE_LOCATION	N	N	varchar(254)	freetext	nominal
DATE_SCANNED	N	N	datetime	range	datetime		0-0		date as year, month, day
PHYSICAL_LOCATION	N	N	varchar(75)	freetext	nominal
KEYWORDS	N	N	varchar(254)	freetext	nominal
DIGITIZATION_PROJECT	N	N	varchar(100)	freetext	nominal
FORMAT	N	N	varchar(50)	freetext	nominal
SCAN_SETTINGS	N	N	char(10)	freetext	nominal
RESOLUTION	N	N	char(5)	freetext	nominal
STORAGE_MEDIUM	N	N	varchar(25)	freetext	nominal
POST_PRODUCTION_WORK	N	N	char(5)	freetext	nominal
DIGITIZATION_PURPOSE	N	N	char(15)	freetext	nominal
PIXEL_ARRAY	N	N	char(5)	freetext	nominal
COLOR_SPACE	N	N	char(5)	freetext	nominal
BIT_DEPTH	N	N	char(5)	freetext	nominal
COPYRIGHT	N	N	varchar(35)	freetext	nominal
ARCHIVE_LOCATION	N	N	varchar(200)	freetext	nominal
NOTES	N	Y	varchar(254)	freetext	nominal