library

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
libraryId INT 10 √ null
aspen_lida_notifications_library.libraryId Implied Constraint R
aspen_lida_quick_searches.libraryId Implied Constraint R
browse_category.libraryId Implied Constraint R
collection_spotlights.libraryId Implied Constraint R
event_library_map_values.libraryId Implied Constraint R
greenhouse_cache.libraryId Implied Constraint R
holiday.libraryId Implied Constraint R
hoopla_settings.libraryId Implied Constraint R
host_information.libraryId Implied Constraint R
javascript_snippet_library.libraryId Implied Constraint R
library_cloud_library_scope.libraryId Implied Constraint R
library_combined_results_section.libraryId Implied Constraint R
library_events_setting.libraryId Implied Constraint R
library_links.libraryId Implied Constraint R
library_open_archives_collection.libraryId Implied Constraint R
library_records_to_include.libraryId Implied Constraint R
library_search_source.libraryId Implied Constraint R
library_sideload_scopes.libraryId Implied Constraint R
library_themes.libraryId Implied Constraint R
library_web_builder_basic_page.libraryId Implied Constraint R
library_web_builder_custom_form.libraryId Implied Constraint R
library_web_builder_portal_page.libraryId Implied Constraint R
library_web_builder_resource.libraryId Implied Constraint R
library_website_indexing.libraryId Implied Constraint R
location.libraryId Implied Constraint R
materials_request.libraryId Implied Constraint R
materials_request_fields_to_display.libraryId Implied Constraint R
materials_request_form_fields.libraryId Implied Constraint R
materials_request_formats.libraryId Implied Constraint R
materials_request_status.libraryId Implied Constraint R
materials_request_usage.libraryId Implied Constraint R
overdrive_api_product_availability.libraryId Implied Constraint R
placard_library.libraryId Implied Constraint R
staff_members.libraryId Implied Constraint R
system_message_library.libraryId Implied Constraint R
web_builder_custom_from_submission.libraryId Implied Constraint R
web_builder_menu.libraryId Implied Constraint R

A unique id to identify the library within the system
subdomain VARCHAR 25 null

The subdomain which can be used to access settings for the library
displayName VARCHAR 80 null
showLibraryFacet TINYINT 3 1

Whether or not the user can see and use the library facet to change to another branch in their library system.
showConsortiumFacet TINYINT 3 0

Whether or not the user can see and use the consortium facet to change to other library systems.
allowInBranchHolds TINYINT 3 1

Whether or not the user can place holds for their branch. If this isn’t shown, they won’t be able to place holds for books at the location they are in. If set to false, they won’t be able to place any holds.
allowInLibraryHolds TINYINT 3 1

Whether or not the user can place holds for books at other locations in their library system
allowConsortiumHolds TINYINT 3 0

Whether or not the user can place holds for any book anywhere in the consortium.
scope SMALLINT 5 √ 0
useScope TINYINT 3 √ 0
hideCommentsWithBadWords TINYINT 3 √ 0
showStandardReviews TINYINT 3 √ 1
showHoldButton TINYINT 3 √ 1
showLoginButton TINYINT 3 √ 1
showEmailThis TINYINT 3 √ 1
showComments TINYINT 3 √ 1
showFavorites TINYINT 3 √ 1
inSystemPickupsOnly TINYINT 3 √ 0
facetLabel VARCHAR 75 √ ''
finePaymentType BOOLEAN 3 √ NULL
repeatSearchOption enum('none', 'librarySystem', 'marmot', 'all') 13 'all'

Where to allow repeating search. Valid options are: none, librarySystem, marmot, all
repeatInInnReach TINYINT 3 √ 0
repeatInWorldCat TINYINT 3 √ 0
systemsToRepeatIn VARCHAR 255 √ ''
homeLink VARCHAR 255 'default'
showAdvancedSearchbox TINYINT 3 1
validPickupSystems VARCHAR 500 √ ''
allowProfileUpdates TINYINT 3 1
allowRenewals TINYINT 3 1
allowFreezeHolds TINYINT 3 1
showItsHere TINYINT 3 1
holdDisclaimer LONGTEXT 2147483647 √ NULL
showHoldCancelDate TINYINT 3 0
enableInnReachIntegration TINYINT 3 0
showRatings TINYINT 3 1
minimumFineAmount FLOAT 12 0
enableGenealogy TINYINT 3 0
enableCourseReserves BOOLEAN 3 0
exportOptions VARCHAR 100 'RefWorks|EndNote'
enableSelfRegistration TINYINT 3 0
enableMaterialsRequest TINYINT 3 √ 0
eContentLinkRules VARCHAR 512 √ ''
notesTabName VARCHAR 50 √ 'Notes'
showHoldButtonInSearchResults TINYINT 3 √ 1
showSimilarAuthors TINYINT 3 √ 1
showSimilarTitles TINYINT 3 √ 1
show856LinksAsTab TINYINT 3 √ 0
applyNumberOfHoldingsBoost TINYINT 3 √ 1
worldCatUrl VARCHAR 100 √ ''
worldCatQt VARCHAR 40 √ ''
preferSyndeticsSummary TINYINT 3 √ 1
showGoDeeper TINYINT 3 √ 1
showInnReachResultsAtEndOfSearch TINYINT 3 √ 1
defaultNotNeededAfterDays INT 10 √ 0
showCheckInGrid INT 10 √ 1
showOtherFormatCategory BOOLEAN 3 √ 1
showWikipediaContent BOOLEAN 3 √ 1
payFinesLink VARCHAR 512 √ 'default'
payFinesLinkText VARCHAR 512 √ 'Click to Pay Fines Online'
ilsCode VARCHAR 75 √ NULL
systemMessage MEDIUMTEXT 16777215 √ NULL
restrictSearchByLibrary BOOLEAN 3 √ 0
includeOutOfSystemExternalLinks BOOLEAN 3 √ 0
restrictOwningBranchesAndSystems BOOLEAN 3 √ 1
showAvailableAtAnyLocation BOOLEAN 3 √ 1
allowPatronAddressUpdates BOOLEAN 3 √ 1
showWorkPhoneInProfile BOOLEAN 3 √ 0
showNoticeTypeInProfile BOOLEAN 3 √ 0
allowPickupLocationUpdates BOOLEAN 3 √ 0
accountingUnit INT 10 √ 10
additionalCss LONGTEXT 2147483647 √ NULL
allowPinReset BOOLEAN 3 √ NULL
maxRequestsPerYear INT 10 √ 60
maxOpenRequests INT 10 √ 5
twitterLink VARCHAR 255 √ ''
pinterestLink VARCHAR 255 √ NULL
youtubeLink VARCHAR 255 √ NULL
instagramLink VARCHAR 255 √ NULL
goodreadsLink VARCHAR 255 √ NULL
facebookLink VARCHAR 255 √ ''
generalContactLink VARCHAR 255 √ ''
repeatInOnlineCollection INT 10 √ 1
showExpirationWarnings BOOLEAN 3 √ 1
econtentLocationsToInclude VARCHAR 255 √ NULL
showLibraryHoursNoticeOnAccountPages BOOLEAN 3 √ 1
showShareOnExternalSites INT 10 √ 1
showGoodReadsReviews INT 10 √ 1
showStaffView INT 10 √ 1
showSearchTools INT 10 √ 1
barcodePrefix VARCHAR 15 √ ''
minBarcodeLength INT 10 √ 0
maxBarcodeLength INT 10 √ 0
showDisplayNameInHeader TINYINT 3 √ 0
headerText LONGTEXT 2147483647 √ NULL
promptForBirthDateInSelfReg TINYINT 3 √ 0
availabilityToggleLabelSuperScope VARCHAR 50 √ 'Entire Collection'
availabilityToggleLabelLocal VARCHAR 50 √ '{display name}'
availabilityToggleLabelAvailable VARCHAR 50 √ 'Available Now'
loginFormUsernameLabel VARCHAR 100 √ 'Your Name'
loginFormPasswordLabel VARCHAR 100 √ 'Library Card Number'
additionalLocationsToShowAvailabilityFor VARCHAR 255 ''
showInMainDetails VARCHAR 255 √ NULL
includeDplaResults BOOLEAN 3 √ 0
selfRegistrationFormMessage MEDIUMTEXT 16777215 √ NULL
selfRegistrationSuccessMessage MEDIUMTEXT 16777215 √ NULL
addSMSIndicatorToPhone BOOLEAN 3 √ 0
showAlternateLibraryOptionsInProfile BOOLEAN 3 √ 1
selfRegistrationTemplate VARCHAR 25 √ 'default'
externalMaterialsRequestUrl VARCHAR 255 √ NULL
isDefault BOOLEAN 3 √ NULL
showHoldButtonForUnavailableOnly BOOLEAN 3 √ 0
allowLinkedAccounts BOOLEAN 3 √ 1
allowAutomaticSearchReplacements BOOLEAN 3 √ 1
overDriveScopeId INT 10 √ -1
publicListsToInclude BOOLEAN 3 √ 4
showLCSubjects BOOLEAN 3 √ 1
showBisacSubjects BOOLEAN 3 √ 1
showFastAddSubjects BOOLEAN 3 √ 1
showOtherSubjects BOOLEAN 3 √ 1
maxFinesToAllowAccountUpdates FLOAT 12 √ 10
showRefreshAccountButton TINYINT 3 1
patronNameDisplayStyle enum('firstinitial_lastname', 'lastinitial_firstname') 21 √ 'firstinitial_lastname'
includeAllRecordsInShelvingFacets TINYINT 3 √ 0
includeAllRecordsInDateAddedFacets TINYINT 3 √ 0
preventExpiredCardLogin BOOLEAN 3 √ 0
showInSearchResultsMainDetails VARCHAR 255 √ 'a:4:{i:0;s:10:"showSeries";i:1;s:13:"showPublisher";i:2;s:19:"showPublicationDate";i:3;s:13:"showLanguages";}'
alwaysShowSearchResultsMainDetails BOOLEAN 3 √ 0
casHost VARCHAR 50 √ NULL
casPort SMALLINT 5 √ NULL
casContext VARCHAR 50 √ NULL
availabilityToggleLabelAvailableOnline VARCHAR 50 √ ''
includeOnlineMaterialsInAvailableToggle BOOLEAN 3 √ 1
masqueradeAutomaticTimeoutLength BOOLEAN 3 √ NULL
allowMasqueradeMode BOOLEAN 3 √ 1
allowReadingHistoryDisplayInMasqueradeMode BOOLEAN 3 √ 0
newMaterialsRequestSummary MEDIUMTEXT 16777215 √ NULL
materialsRequestDaysToPreserve INT 10 √ 0
showGroupedHoldCopiesCount BOOLEAN 3 √ 1
interLibraryLoanName VARCHAR 30 √ NULL
interLibraryLoanUrl VARCHAR 200 √ NULL
expirationNearMessage LONGTEXT 2147483647 √ NULL
expiredMessage LONGTEXT 2147483647 √ NULL
enableCombinedResults BOOLEAN 3 √ 0
combinedResultsLabel VARCHAR 255 √ 'Combined Results'
defaultToCombinedResults BOOLEAN 3 √ 0
hooplaLibraryID INT UNSIGNED 10 √ NULL
showOnOrderCounts BOOLEAN 3 √ 1
sharedOverdriveCollection BOOLEAN 3 √ -1
showSeriesAsTab TINYINT 3 0
enableAlphaBrowse TINYINT 3 √ 1
homePageWidgetId VARCHAR 50 √ ''
searchGroupedRecords TINYINT 3 √ 0
showStandardSubjects BOOLEAN 3 √ 1
theme INT 10 √ 1
enableOpenArchives BOOLEAN 3 √ 0
hooplaScopeId INT 10 √ -1
axis360ScopeId INT 10 √ -1
showQuickCopy BOOLEAN 3 √ 1
finesToPay BOOLEAN 3 √ 1
msbUrl VARCHAR 80 √ NULL
finePaymentOrder VARCHAR 80 √ ''
showConvertListsFromClassic BOOLEAN 3 √ 0
enableForgotPasswordLink BOOLEAN 3 √ 1
selfRegistrationLocationRestrictions INT 10 √ 2
baseUrl VARCHAR 75 √ NULL
generateSitemap BOOLEAN 3 √ 1
selfRegistrationUrl VARCHAR 255 √ NULL
showWhileYouWait BOOLEAN 3 √ 1
enableWebBuilder BOOLEAN 3 √ 0
useAllCapsWhenSubmittingSelfRegistration BOOLEAN 3 √ 0
validSelfRegistrationStates VARCHAR 255 √ ''
selfRegistrationPasswordNotes VARCHAR 255 √ ''
validSelfRegistrationZipCodes VARCHAR 255 √ ''
showAlternateLibraryCard TINYINT 3 √ 0
showAlternateLibraryCardPassword TINYINT 3 √ 0
alternateLibraryCardLabel VARCHAR 50 √ ''
alternateLibraryCardPasswordLabel VARCHAR 50 √ ''
libraryCardBarcodeStyle VARCHAR 20 √ 'none'
alternateLibraryCardStyle VARCHAR 20 √ 'none'
allowUsernameUpdates BOOLEAN 3 √ 0
useAllCapsWhenUpdatingProfile BOOLEAN 3 √ 0
bypassReviewQueueWhenUpdatingProfile BOOLEAN 3 √ 0
requireNumericPhoneNumbersWhenUpdatingProfile BOOLEAN 3 √ 0
availableHoldDelay INT 10 √ 0
allowPatronPhoneNumberUpdates BOOLEAN 3 √ 1
loginNotes LONGTEXT 2147483647 √ NULL
allowRememberPickupLocation BOOLEAN 3 √ 1
allowHomeLibraryUpdates BOOLEAN 3 √ 1
showOpacNotes BOOLEAN 3 √ 0
showBorrowerMessages BOOLEAN 3 √ 0
showDebarmentNotes BOOLEAN 3 √ 0
symphonyPaymentType VARCHAR 10 √ NULL
symphonyPaymentPolicy VARCHAR 10 √ NULL
allowDeletingILSRequests BOOLEAN 3 √ 1
tiktokLink VARCHAR 255 √ ''
edsSettingsId INT 10 √ -1
workstationId VARCHAR 10 √ ''
compriseSettingId INT 10 √ -1
proPaySettingId INT 10 √ -1
payPalSettingId INT 10 √ -1
worldPaySettingId INT 10 √ -1
createSearchInterface BOOLEAN 3 √ 1
maxDaysToFreeze INT 10 √ 365
displayItemBarcode BOOLEAN 3 √ 0
treatBibOrItemHoldsAs BOOLEAN 3 √ 1
showCardExpirationDate BOOLEAN 3 √ 1
showInSelectInterface BOOLEAN 3 √ 1
isConsortialCatalog BOOLEAN 3 √ 0
showMessagingSettings BOOLEAN 3 √ 1
groupedWorkDisplaySettingId INT 10 √ 0
browseCategoryGroupId INT 10 √ 0
layoutSettingId INT 10 √ 0
contactEmail VARCHAR 250 √ NULL
displayMaterialsRequestToPublic BOOLEAN 3 √ 1
donationSettingId INT 10 √ -1
donations.id Implied Constraint R
courseReserveLibrariesToInclude VARCHAR 50 √ NULL
showLogMeOutAfterPlacingHolds BOOLEAN 3 √ 1
curbsidePickupSettingId INT 10 √ -1
twoFactorAuthSettingId INT 10 √ -1
defaultRememberMe BOOLEAN 3 √ 0
systemHoldNote VARCHAR 50 √ ''
systemHoldNoteMasquerade VARCHAR 50 √ ''
enableReadingHistory BOOLEAN 3 √ 1
showCitationStyleGuides BOOLEAN 3 √ 1
minPinLength INT 10 √ 4
maxPinLength INT 10 √ 6
onlyDigitsAllowedInPin INT 10 √ 1
enableSavedSearches BOOLEAN 3 √ 1
holdPlacedAt BOOLEAN 3 √ 0
allowLoginToPatronsOfThisLibraryOnly BOOLEAN 3 √ 0
messageForPatronsOfOtherLibraries TEXT 65535 √ NULL
xpressPaySettingId INT 10 √ -1
allowNameUpdates BOOLEAN 3 √ 1
allowDateOfBirthUpdates BOOLEAN 3 √ 1
preventLogin BOOLEAN 3 √ 0
preventLoginMessage TEXT 65535 √ NULL
footerText MEDIUMTEXT 16777215 √ NULL
ebscohostSettingId INT 10 √ -1
ebscohostSearchSettingId INT 10 √ -1
displayHoldsOnCheckout BOOLEAN 3 √ 0
ssoName VARCHAR 255 √ NULL
ssoXmlUrl VARCHAR 255 √ NULL
ssoUniqueAttribute VARCHAR 255 √ NULL
ssoMetadataFilename VARCHAR 255 √ NULL
ssoIdAttr VARCHAR 255 √ NULL
ssoUsernameAttr VARCHAR 255 √ NULL
ssoFirstnameAttr VARCHAR 255 √ NULL
ssoLastnameAttr VARCHAR 255 √ NULL
ssoEmailAttr VARCHAR 255 √ NULL
ssoDisplayNameAttr VARCHAR 255 √ NULL
ssoPhoneAttr VARCHAR 255 √ NULL
ssoPatronTypeAttr VARCHAR 255 √ NULL
ssoPatronTypeFallback VARCHAR 255 √ NULL
ssoAddressAttr VARCHAR 255 √ NULL
ssoCityAttr VARCHAR 255 √ NULL
ssoLibraryIdAttr VARCHAR 255 √ NULL
ssoLibraryIdFallback VARCHAR 255 √ NULL
ssoCategoryIdAttr VARCHAR 255 √ NULL
ssoCategoryIdFallback VARCHAR 255 √ NULL
lidaNotificationSettingId INT 10 √ -1
lidaQuickSearchId INT 10 √ -1
selfRegistrationUserProfile VARCHAR 20 √ 'SELFREG'
aciSpeedpaySettingId INT 10 √ -1
ssoEntityId VARCHAR 255 √ NULL
promptForParentInSelfReg BOOLEAN 3 0
promptForSMSNoticesInSelfReg BOOLEAN 3 0
selfRegRequirePhone BOOLEAN 3 0
selfRegRequireEmail BOOLEAN 3 1
ssoSettingId TINYINT 3 √ -1
showUserCirculationModules BOOLEAN 3 √ 1
showUserPreferences BOOLEAN 3 √ 1
showUserContactInformation BOOLEAN 3 √ 1
showVolumesWithLocalCopiesFirst TINYINT 3 √ 0
enableListDescriptions BOOLEAN 3 √ 1
allowableListNames VARCHAR 500 √ ''
cityStateField TINYINT 3 √ 0
holdRange VARCHAR 20 √ 'SYSTEM'
invoiceCloudSettingId INT 10 √ -1
optInToReadingHistoryUpdatesILS BOOLEAN 3 √ 0
optOutOfReadingHistoryUpdatesILS BOOLEAN 3 √ 1
setUsePreferredNameInIlsOnUpdate BOOLEAN 3 √ 1
novelistSettingId INT 10 √ -1
accountProfileId INT 10 √ -1
lidaGeneralSettingId INT 10 √ -1
materialsRequestSendStaffEmailOnNew BOOLEAN 3 √ 0
materialsRequestSendStaffEmailOnAssign BOOLEAN 3 √ 0
materialsRequestNewEmail VARCHAR 125 √ NULL
deluxeCertifiedPaymentsSettingId INT 10 √ -1
paypalPayflowSettingId INT 10 √ -1
enableThirdPartyRegistration TINYINT 3 √ 0
thirdPartyRegistrationLocation INT 10 √ -1
thirdPartyPTypeAddressValidated INT 10 √ -1
thirdPartyPTypeAddressNotValidated INT 10 √ -1
squareSettingId INT 10 √ -1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc libraryId
subdomain Must be unique Asc subdomain

Relationships

Close relationships within degrees of separation