grouped_work_display_settings

6 rows


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 BOOLEAN 3 √ 1
includeOnlineMaterialsInAvailableToggle BOOLEAN 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 BOOLEAN 3 √ 1
facetCountsToShow TINYINT 3 √ 1
alwaysFlagNewTitles BOOLEAN 3 √ 0
showRelatedRecordLabels BOOLEAN 3 √ 1
sortOwnedEditionsFirst BOOLEAN 3 √ 0
showSearchToolsAtTop BOOLEAN 3 √ 0
showEditionCovers BOOLEAN 3 √ 0

Indexes

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

Relationships