location

0 rows


Description

Stores information about the various locations that are part

Columns

Column Type Size Nulls Auto Default Children Parents Comments
locationId INT 10 √ null

A unique Id for the branch or location within vuFind

code VARCHAR 75 √ NULL
displayName VARCHAR 60 null

The full name of the location for display to the user

libraryId INT 10 null
library.libraryId Implied Constraint R

A link to the library which the location belongs to

validHoldPickupBranch TINYINT 3 1

Determines if the location can be used as a pickup location if it is not the patrons home location or the location they are in.

nearbyLocation1 INT 10 √ NULL

A secondary location which is nearby and could be used for pickup of materials.

nearbyLocation2 INT 10 √ NULL

A tertiary location which is nearby and could be used for pickup of materials.

scope SMALLINT 5 √ 0
useScope TINYINT 3 √ 0
facetFile VARCHAR 15 'default'

The name of the facet file which should be used while searching use default to not override the file

showHoldButton TINYINT 3 √ 1
isMainBranch BOOLEAN 3 √ 0
showStandardReviews TINYINT 3 √ 1
repeatSearchOption enum('none', 'librarySystem', 'marmot', 'all') 13 'all'

Where to allow repeating search. Valid options are: none, librarySystem, marmot, all

facetLabel VARCHAR 75 √ ''
repeatInInnReach TINYINT 3 √ 0
repeatInWorldCat TINYINT 3 √ 0
systemsToRepeatIn VARCHAR 255 √ ''
homeLink VARCHAR 255 'default'
ptypesToAllowRenewals VARCHAR 128 '*'
automaticTimeoutLength INT 10 √ 90
automaticTimeoutLengthLoggedOut INT 10 √ 450
restrictSearchByLocation BOOLEAN 3 √ 0
suppressHoldings BOOLEAN 3 √ 0
additionalCss LONGTEXT 2147483647 √ NULL
repeatInOnlineCollection INT 10 √ 1
econtentLocationsToInclude VARCHAR 255 √ NULL
showInLocationsAndHoursList INT 10 √ 1
showShareOnExternalSites INT 10 √ 1
showEmailThis INT 10 √ 1
showFavorites INT 10 √ 1
showComments INT 10 √ 1
showGoodReadsReviews INT 10 √ 1
showStaffView INT 10 √ 1
address LONGTEXT 2147483647 √ NULL
phone VARCHAR 25 √ ''
showDisplayNameInHeader TINYINT 3 √ 0
headerText LONGTEXT 2147483647 √ NULL
availabilityToggleLabelSuperScope VARCHAR 50 √ 'Entire Collection'
availabilityToggleLabelLocal VARCHAR 50 √ '{display name}'
availabilityToggleLabelAvailable VARCHAR 50 √ 'Available Now'
subLocation VARCHAR 50 √ NULL
overDriveScopeId INT 10 √ -2
publicListsToInclude BOOLEAN 3 √ 6
includeAllLibraryBranchesInFacets TINYINT 3 √ 1
additionalLocationsToShowAvailabilityFor VARCHAR 100 ''
includeAllRecordsInShelvingFacets TINYINT 3 √ 0
includeAllRecordsInDateAddedFacets TINYINT 3 √ 0
availabilityToggleLabelAvailableOnline VARCHAR 50 √ ''
baseAvailabilityToggleOnLocalHoldingsOnly BOOLEAN 3 √ 0
includeOnlineMaterialsInAvailableToggle BOOLEAN 3 √ 1
subdomain VARCHAR 25 √ ''
includeLibraryRecordsToInclude BOOLEAN 3 √ 0
useLibraryCombinedResultsSettings BOOLEAN 3 √ 1
enableCombinedResults BOOLEAN 3 √ 0
combinedResultsLabel VARCHAR 255 √ 'Combined Results'
defaultToCombinedResults BOOLEAN 3 √ 0
footerTemplate VARCHAR 40 'default'
homePageWidgetId VARCHAR 50 √ ''
theme INT 10 √ 1
hooplaScopeId INT 10 √ -1
axis360ScopeId INT 10 √ -1
historicCode VARCHAR 20 √ ''
tty VARCHAR 25 √ NULL
description LONGTEXT 2147483647 √ NULL
createSearchInterface BOOLEAN 3 √ 1
showInSelectInterface BOOLEAN 3 √ 0
enableAppAccess BOOLEAN 3 √ 0
latitude VARCHAR 75 √ '0'
longitude VARCHAR 75 √ '0'
unit VARCHAR 3 √ NULL
appReleaseChannel BOOLEAN 3 √ 0
browseCategoryGroupId INT 10 √ -1
groupedWorkDisplaySettingId INT 10 √ -1
contactEmail VARCHAR 250 √ NULL
showOnDonationsPage BOOLEAN 3 √ 1
curbsidePickupInstructions VARCHAR 255 √ NULL
ebscohostSettingId INT 10 √ -2
ebscohostSearchSettingId INT 10 √ -2
vdxLocation VARCHAR 50 √ NULL
vdxFormId INT 10 √ NULL
lidaLocationSettingId INT 10 √ -1
validSelfRegistrationBranch TINYINT 3 1
useLibraryThemes BOOLEAN 3 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc locationId
code Must be unique Asc/Asc code + subLocation
libraryId Performance Asc libraryId
ValidHoldPickupBranch Performance Asc validHoldPickupBranch
ValidSelfRegistrationBranch Performance Asc validSelfRegistrationBranch

Relationships