SS008

Properties of Attributes in entity 3 table: HJA The Man; scanned historical records of the personal history of Horace Justin Andrews

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
BOOK	Y	N	char(2)	enum	nominal
TOPIC	Y	N	char(3)	enum	nominal
DOCUMENT_NO	Y	N	numeric(4,0)	range	ratio	natural	1.-152.		number
TOPIC_DESCRIPTION	N	N	char(254)	freetext	nominal
DOCUMENT_CODE	Y	N	varchar(20)	freetext	nominal
TITLE	N	N	varchar(100)	freetext	nominal
DESCRIPTION	N	0	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	1.-34.		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
FILE_URL	N	Y	char(90)	freetext	nominal