location

1 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 100 null
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 TINYINT 3 √ 0
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 TINYINT 3 √ 0
suppressHoldings TINYINT 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
address LONGTEXT 2147483647 √ NULL
phone VARCHAR 25 √ ''
showDisplayNameInHeader TINYINT 3 √ 0
headerText LONGTEXT 2147483647 √ NULL
subLocation VARCHAR 50 √ NULL
publicListsToInclude TINYINT 3 √ 6
includeAllLibraryBranchesInFacets TINYINT 3 √ 1
additionalLocationsToShowAvailabilityFor VARCHAR 100 ''
subdomain VARCHAR 25 √ ''
includeLibraryRecordsToInclude TINYINT 3 √ 0
useLibraryCombinedResultsSettings TINYINT 3 √ 1
enableCombinedResults TINYINT 3 √ 0
combinedResultsLabel VARCHAR 255 √ 'Combined Results'
defaultToCombinedResults TINYINT 3 √ 0
footerTemplate VARCHAR 40 'default'
homePageWidgetId VARCHAR 50 √ ''
theme INT 10 √ 1
hooplaScopeId INT 10 √ -1
overDriveScopeId INT 10 √ -2
groupedWorkDisplaySettingId INT 10 √ -1
browseCategoryGroupId INT 10 -1
historicCode VARCHAR 20 √ ''
axis360ScopeId INT 10 √ -1
tty VARCHAR 25 √ NULL
description LONGTEXT 2147483647 √ NULL
createSearchInterface TINYINT 3 √ 1
showInSelectInterface TINYINT 3 √ 0
enableAppAccess TINYINT 3 √ 0
latitude VARCHAR 75 √ '0'
longitude VARCHAR 75 √ '0'
unit VARCHAR 3 √ NULL
appReleaseChannel TINYINT 3 √ 0
contactEmail VARCHAR 250 √ NULL
showOnDonationsPage TINYINT 3 √ 1
curbsidePickupInstructions VARCHAR 255 √ NULL
ebscohostSettingId INT 10 √ -2
ebscohostSearchSettingId INT 10 √ -2
lidaLocationSettingId INT 10 √ -1
vdxLocation VARCHAR 50 √ NULL
vdxFormId INT 10 √ NULL
validSelfRegistrationBranch TINYINT 3 1
useLibraryThemes TINYINT 3 √ 1
lidaSelfCheckSettingId INT 10 √ -1
secondaryPhoneNumber VARCHAR 25 √ ''
openArchivesFacetSettingId INT 10 √ 1
websiteIndexingFacetSettingId INT 10 √ 1
palaceProjectScopeId INT 10 √ -1
languageAndDisplayInHeader INT 10 √ 1
locationImage VARCHAR 100 √ NULL
allowUpdatingHoursFromILS TINYINT 3 √ 1
displayExploreMoreBarInSummon TINYINT 3 √ 1
displayExploreMoreBarInEbscoEds TINYINT 3 √ 1
displayExploreMoreBarInCatalogSearch TINYINT 3 √ 1
displayExploreMoreBarInEbscoHost TINYINT 3 √ 1
statGroup INT 10 √ -1
circulationUsername VARCHAR 20 √ NULL
repeatInCloudSource TINYINT 3 √ 0
repeatInShareIt TINYINT 3 √ 0
localIllFormId INT 10 √ -1
heyCentricSettingId INT 10 -1
allowUpdatingContactInfoFromILS TINYINT 3 √ 0

Indexes

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

Relationships

Close relationships within degrees of separation