Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||||||||
| 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
Close relationships within degrees of separation
