Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||
| name | VARCHAR | 50 | null |
|
|
|||
| marcPath | VARCHAR | 100 | null |
|
|
|||
| marcEncoding | enum('MARC8', 'UTF8', 'UNIMARC', 'ISO8859_1', 'BESTGUESS') | 9 | 'MARC8' |
|
|
|||
| individualMarcPath | VARCHAR | 100 | null |
|
|
|||
| groupingClass | VARCHAR | 100 | 'MarcRecordGrouper' |
|
|
|||
| indexingClass | VARCHAR | 50 | null |
|
|
|||
| recordDriver | VARCHAR | 100 | 'MarcRecord' |
|
|
|||
| recordUrlComponent | VARCHAR | 25 | 'Record' |
|
|
|||
| formatSource | enum('bib', 'item', 'specified') | 9 | 'bib' |
|
|
|||
| recordNumberTag | CHAR | 3 | null |
|
|
|||
| recordNumberPrefix | VARCHAR | 10 | null |
|
|
|||
| suppressItemlessBibs | BOOLEAN | 3 | 1 |
|
|
|||
| itemTag | CHAR | 3 | null |
|
|
|||
| itemRecordNumber | CHAR | 1 | √ | NULL |
|
|
||
| useItemBasedCallNumbers | BOOLEAN | 3 | 1 |
|
|
|||
| callNumberPrestamp | CHAR | 1 | √ | NULL |
|
|
||
| callNumber | CHAR | 1 | √ | NULL |
|
|
||
| callNumberCutter | CHAR | 1 | √ | NULL |
|
|
||
| callNumberPoststamp | VARCHAR | 1 | √ | NULL |
|
|
||
| location | CHAR | 1 | √ | NULL |
|
|
||
| locationsToSuppress | VARCHAR | 255 | √ | NULL |
|
|
||
| subLocation | CHAR | 1 | √ | NULL |
|
|
||
| shelvingLocation | CHAR | 1 | √ | NULL |
|
|
||
| volume | VARCHAR | 1 | √ | NULL |
|
|
||
| itemUrl | CHAR | 1 | √ | NULL |
|
|
||
| barcode | CHAR | 1 | √ | NULL |
|
|
||
| status | CHAR | 1 | √ | NULL |
|
|
||
| statusesToSuppress | VARCHAR | 255 | √ | NULL |
|
|
||
| totalCheckouts | CHAR | 1 | √ | NULL |
|
|
||
| lastYearCheckouts | CHAR | 1 | √ | NULL |
|
|
||
| yearToDateCheckouts | CHAR | 1 | √ | NULL |
|
|
||
| totalRenewals | CHAR | 1 | √ | NULL |
|
|
||
| iType | CHAR | 1 | √ | NULL |
|
|
||
| dueDate | CHAR | 1 | √ | NULL |
|
|
||
| dateCreated | CHAR | 1 | √ | NULL |
|
|
||
| dateCreatedFormat | VARCHAR | 20 | √ | NULL |
|
|
||
| iCode2 | CHAR | 1 | √ | NULL |
|
|
||
| useICode2Suppression | BOOLEAN | 3 | 1 |
|
|
|||
| format | CHAR | 1 | √ | NULL |
|
|
||
| eContentDescriptor | CHAR | 1 | √ | NULL |
|
|
||
| orderTag | CHAR | 3 | √ | NULL |
|
|
||
| orderStatus | CHAR | 1 | √ | NULL |
|
|
||
| orderLocation | CHAR | 1 | √ | NULL |
|
|
||
| orderCopies | CHAR | 1 | √ | NULL |
|
|
||
| orderCode3 | CHAR | 1 | √ | NULL |
|
|
||
| collection | CHAR | 1 | √ | NULL |
|
|
||
| catalogDriver | VARCHAR | 50 | √ | NULL |
|
|
||
| nonHoldableITypes | VARCHAR | 600 | √ | NULL |
|
|
||
| nonHoldableStatuses | VARCHAR | 255 | √ | NULL |
|
|
||
| nonHoldableLocations | VARCHAR | 512 | √ | NULL |
|
|
||
| lastCheckinFormat | VARCHAR | 20 | √ | NULL |
|
|
||
| lastCheckinDate | CHAR | 1 | √ | NULL |
|
|
||
| orderLocationSingle | CHAR | 1 | √ | NULL |
|
|
||
| specifiedFormat | VARCHAR | 50 | √ | NULL |
|
|
||
| specifiedFormatCategory | VARCHAR | 50 | √ | NULL |
|
|
||
| specifiedFormatBoost | INT | 10 | √ | NULL |
|
|
||
| filenamesToInclude | VARCHAR | 250 | √ | '.*\\.ma?rc' |
|
|
||
| collectionsToSuppress | VARCHAR | 100 | √ | '' |
|
|
||
| numCharsToCreateFolderFrom | INT | 10 | √ | 4 |
|
|
||
| createFolderFromLeadingCharacters | BOOLEAN | 3 | √ | 1 |
|
|
||
| dueDateFormat | VARCHAR | 20 | √ | 'yyMMdd' |
|
|
||
| doAutomaticEcontentSuppression | BOOLEAN | 3 | √ | 1 |
|
|
||
| iTypesToSuppress | VARCHAR | 100 | √ | NULL |
|
|
||
| iCode2sToSuppress | VARCHAR | 100 | √ | NULL |
|
|
||
| bCode3sToSuppress | VARCHAR | 100 | √ | NULL |
|
|
||
| sierraRecordFixedFieldsTag | CHAR | 3 | √ | NULL |
|
|
||
| bCode3 | CHAR | 1 | √ | NULL |
|
|
||
| recordNumberField | CHAR | 1 | √ | 'a' |
|
|
||
| recordNumberSubfield | CHAR | 1 | √ | 'a' |
|
|
||
| runFullUpdate | BOOLEAN | 3 | √ | 0 |
|
|
||
| lastUpdateOfChangedRecords | INT | 10 | √ | 0 |
|
|
||
| lastUpdateOfAllRecords | INT | 10 | √ | 0 |
|
|
||
| lastUpdateFromMarcExport | INT | 10 | √ | 0 |
|
|
||
| lastVolumeExportTimestamp | INT | 10 | √ | 0 |
|
|
||
| regroupAllRecords | BOOLEAN | 3 | √ | 0 |
|
|
||
| treatUnknownLanguageAs | VARCHAR | 50 | √ | 'English' |
|
|
||
| treatUndeterminedLanguageAs | VARCHAR | 50 | √ | 'English' |
|
|
||
| checkRecordForLargePrint | BOOLEAN | 3 | √ | 1 |
|
|
||
| determineAudienceBy | TINYINT | 3 | √ | 0 |
|
|
||
| audienceSubfield | CHAR | 1 | √ | NULL |
|
|
||
| includeLocationNameInDetailedLocation | BOOLEAN | 3 | √ | 1 |
|
|
||
| lastUpdateOfAuthorities | INT | 10 | √ | 0 |
|
|
||
| fullMarcExportRecordIdThreshold | BIGINT | 19 | √ | 0 |
|
|
||
| lastChangeProcessed | INT | 10 | √ | 0 |
|
|
||
| noteSubfield | CHAR | 1 | √ | '' |
|
|
||
| treatUnknownAudienceAs | VARCHAR | 10 | √ | 'General' |
|
|
||
| suppressRecordsWithUrlsMatching | VARCHAR | 512 | √ | 'overdrive.com|contentreserve.com|hoopla|yourcloudlibrary|axis360.baker-taylor.com' |
|
|
||
| determineLiteraryFormBy | TINYINT | 3 | √ | 0 |
|
|
||
| literaryFormSubfield | CHAR | 1 | √ | '' |
|
|
||
| hideUnknownLiteraryForm | TINYINT | 3 | √ | 1 |
|
|
||
| hideNotCodedLiteraryForm | TINYINT | 3 | √ | 1 |
|
|
||
| fallbackFormatField | VARCHAR | 5 | √ | NULL |
|
|
||
| treatLibraryUseOnlyGroupedStatusesAsAvailable | TINYINT | 3 | √ | 1 |
|
|
||
| customMarcFieldsToIndexAsKeyword | VARCHAR | 255 | √ | '' |
|
|
||
| processRecordLinking | BOOLEAN | 3 | √ | 0 |
|
|
||
| evergreenOrgUnitSchema | BOOLEAN | 3 | √ | 1 |
|
|
||
| index856Links | BOOLEAN | 3 | 0 |
|
|
|||
| includePersonalAndCorporateNamesInTopics | BOOLEAN | 3 | 1 |
|
|
|||
| orderRecordsStatusesToInclude | VARCHAR | 25 | √ | 'o|1' |
|
|
||
| hideOrderRecordsForBibsWithPhysicalItems | BOOLEAN | 3 | √ | 0 |
|
|
||
| orderRecordsToSuppressByDate | VARCHAR | 1 | √ | NULL |
|
|
||
| checkSierraMatTypeForFormat | TINYINT | 3 | √ | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| name | Must be unique | Asc | name |
Relationships
Close relationships within degrees of separation
