sideloads

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
library_sideload_scopes.sideLoadScopeId Implied Constraint R
location_sideload_scopes.sideLoadScopeId Implied Constraint R
name VARCHAR 50 null
marcPath VARCHAR 100 null
filenamesToInclude VARCHAR 250 '.*\\.ma?rc'
marcEncoding enum('MARC8', 'UTF8', 'UNIMARC', 'ISO8859_1', 'BESTGUESS') 9 'MARC8'
groupingClass VARCHAR 100 'SideLoadedRecordGrouper'
indexingClass VARCHAR 50 'SideLoadedEContentProcessor'
recordDriver VARCHAR 100 'SideLoadedRecord'
recordUrlComponent VARCHAR 25 'DefineThis'
recordNumberTag CHAR 3 '001'
recordNumberSubfield CHAR 1 'a'
recordNumberPrefix VARCHAR 10 ''
itemTag CHAR 3 ''
itemRecordNumber CHAR 1 NULL
location CHAR 1 NULL
locationsToSuppress VARCHAR 255 NULL
itemUrl CHAR 1 NULL
format CHAR 1 NULL
formatSource enum('bib', 'item', 'specified') 9 'bib'
specifiedFormat VARCHAR 50 NULL
specifiedFormatCategory VARCHAR 50 NULL
specifiedFormatBoost INT 10 NULL
runFullUpdate TINYINT 3 0
lastUpdateOfChangedRecords INT 10 0
lastUpdateOfAllRecords INT 10 0
treatUnknownLanguageAs VARCHAR 50 'English'
treatUndeterminedLanguageAs VARCHAR 50 'English'
deletedRecordsIds LONGTEXT 2147483647 NULL
accessButtonLabel VARCHAR 50 'Access Online'
showStatus TINYINT 3 1
includePersonalAndCorporateNamesInTopics TINYINT 3 1
convertFormatToEContent TINYINT 3 1
useLinkTextForButtonLabel TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
sideloads_s_pk Primary key Asc id
name Must be unique Asc name
PRIMARY Must be unique Asc id

Relationships