Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||
| name | VARCHAR | 255 | null |
|
|
|||
| applyNumberOfHoldingsBoost | TINYINT | 3 | √ | 1 |
|
|
||
| showSearchTools | TINYINT | 3 | √ | 1 |
|
|
||
| showQuickCopy | TINYINT | 3 | √ | 1 |
|
|
||
| showInSearchResultsMainDetails | VARCHAR | 512 | √ | 'a:5:{i:0;s:10:"showSeries";i:1;s:13:"showPublisher";i:2;s:19:"showPublicationDate";i:3;s:13:"showLanguages";i:4;s:10:"showArInfo";}' |
|
|
||
| alwaysShowSearchResultsMainDetails | TINYINT | 3 | √ | 0 |
|
|
||
| availabilityToggleLabelSuperScope | VARCHAR | 50 | √ | 'Entire Collection' |
|
|
||
| availabilityToggleLabelLocal | VARCHAR | 50 | √ | '{display name}' |
|
|
||
| availabilityToggleLabelAvailable | VARCHAR | 50 | √ | 'Available Now' |
|
|
||
| availabilityToggleLabelAvailableOnline | VARCHAR | 50 | √ | 'Available Online' |
|
|
||
| baseAvailabilityToggleOnLocalHoldingsOnly | TINYINT | 3 | √ | 1 |
|
|
||
| includeOnlineMaterialsInAvailableToggle | TINYINT | 3 | √ | 1 |
|
|
||
| includeAllRecordsInShelvingFacets | TINYINT | 3 | √ | 0 |
|
|
||
| includeAllRecordsInDateAddedFacets | TINYINT | 3 | √ | 0 |
|
|
||
| includeOutOfSystemExternalLinks | TINYINT | 3 | √ | 0 |
|
|
||
| facetGroupId | INT | 10 | √ | 0 |
|
|
||
| showStandardReviews | TINYINT | 3 | √ | 1 |
|
|
||
| showGoodReadsReviews | TINYINT | 3 | √ | 1 |
|
|
||
| preferSyndeticsSummary | TINYINT | 3 | √ | 1 |
|
|
||
| showSimilarTitles | TINYINT | 3 | √ | 1 |
|
|
||
| showSimilarAuthors | TINYINT | 3 | √ | 1 |
|
|
||
| showRatings | TINYINT | 3 | √ | 1 |
|
|
||
| showComments | TINYINT | 3 | √ | 1 |
|
|
||
| hideCommentsWithBadWords | TINYINT | 3 | √ | 0 |
|
|
||
| show856LinksAsTab | TINYINT | 3 | √ | 1 |
|
|
||
| showCheckInGrid | TINYINT | 3 | √ | 1 |
|
|
||
| showStaffView | TINYINT | 3 | √ | 1 |
|
|
||
| showLCSubjects | TINYINT | 3 | √ | 1 |
|
|
||
| showBisacSubjects | TINYINT | 3 | √ | 1 |
|
|
||
| showFastAddSubjects | TINYINT | 3 | √ | 1 |
|
|
||
| showOtherSubjects | TINYINT | 3 | √ | 1 |
|
|
||
| showInMainDetails | VARCHAR | 500 | √ | NULL |
|
|
||
| defaultAvailabilityToggle | VARCHAR | 20 | √ | 'global' |
|
|
||
| isDefault | TINYINT | 3 | √ | 0 |
|
|
||
| showItemDueDates | TINYINT | 3 | √ | 1 |
|
|
||
| facetCountsToShow | TINYINT | 3 | √ | 1 |
|
|
||
| alwaysFlagNewTitles | TINYINT | 3 | √ | 0 |
|
|
||
| showRelatedRecordLabels | TINYINT | 3 | √ | 1 |
|
|
||
| sortOwnedEditionsFirst | TINYINT | 3 | √ | 0 |
|
|
||
| show856LinksAsAccessOnlineButtons | TINYINT | 3 | √ | 0 |
|
|
||
| showSearchToolsAtTop | TINYINT | 3 | √ | 0 |
|
|
||
| showEditionCovers | TINYINT | 3 | √ | 0 |
|
|
||
| searchSpecVersion | TINYINT | 3 | √ | 2 |
|
|
||
| limitBoosts | TINYINT | 3 | √ | 1 |
|
|
||
| maxTotalBoost | INT | 10 | √ | 500 |
|
|
||
| maxPopularityBoost | INT | 10 | √ | 25 |
|
|
||
| maxFormatBoost | INT | 10 | √ | 25 |
|
|
||
| maxHoldingsBoost | INT | 10 | √ | 25 |
|
|
||
| showItemNotes | TINYINT | 3 | √ | 1 |
|
|
||
| formatSortingGroupId | INT | 10 | √ | 1 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| grouped_work_display_settings_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
