themes

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
themeName VARCHAR 100 null
extendsTheme VARCHAR 100 NULL
logoName VARCHAR 100 ''
headerBackgroundColor CHAR 7 '#f1f1f1'
headerBackgroundColorDefault TINYINT 3 1
headerForegroundColor CHAR 7 '#8b8b8b'
headerForegroundColorDefault TINYINT 3 1
generatedCss LONGTEXT 2147483647 NULL
headerBottomBorderWidth VARCHAR 6 NULL
favicon VARCHAR 100 ''
pageBackgroundColor CHAR 7 '#ffffff'
pageBackgroundColorDefault TINYINT 3 1
primaryBackgroundColor CHAR 7 '#147ce2'
primaryBackgroundColorDefault TINYINT 3 1
primaryForegroundColor CHAR 7 '#ffffff'
primaryForegroundColorDefault TINYINT 3 1
bodyBackgroundColor CHAR 7 '#ffffff'
bodyBackgroundColorDefault TINYINT 3 1
bodyTextColor CHAR 7 '#6B6B6B'
bodyTextColorDefault TINYINT 3 1
secondaryBackgroundColor CHAR 7 '#de9d03'
secondaryBackgroundColorDefault TINYINT 3 1
secondaryForegroundColor CHAR 7 '#ffffff'
secondaryForegroundColorDefault TINYINT 3 1
tertiaryBackgroundColor CHAR 7 '#de1f0b'
tertiaryBackgroundColorDefault TINYINT 3 1
tertiaryForegroundColor CHAR 7 '#ffffff'
tertiaryForegroundColorDefault TINYINT 3 1
headingFont VARCHAR 191 NULL
headingFontDefault TINYINT 3 1
bodyFont VARCHAR 191 NULL
bodyFontDefault TINYINT 3 1
additionalCss MEDIUMTEXT 16777215 NULL
additionalCssType TINYINT 3 0
buttonRadius VARCHAR 6 NULL
smallButtonRadius VARCHAR 6 NULL
browseCategoryPanelColor CHAR 7 '#ffffff'
browseCategoryPanelColorDefault TINYINT 3 1
selectedBrowseCategoryBackgroundColor CHAR 7 '#0087AB'
selectedBrowseCategoryBackgroundColorDefault TINYINT 3 1
selectedBrowseCategoryForegroundColor CHAR 7 '#ffffff'
selectedBrowseCategoryForegroundColorDefault TINYINT 3 1
selectedBrowseCategoryBorderColor CHAR 7 '#0087AB'
selectedBrowseCategoryBorderColorDefault TINYINT 3 1
deselectedBrowseCategoryBackgroundColor CHAR 7 '#ffffff'
deselectedBrowseCategoryBackgroundColorDefault TINYINT 3 1
deselectedBrowseCategoryForegroundColor CHAR 7 '#6B6B6B'
deselectedBrowseCategoryForegroundColorDefault TINYINT 3 1
deselectedBrowseCategoryBorderColor CHAR 7 '#6B6B6B'
deselectedBrowseCategoryBorderColorDefault TINYINT 3 1
menubarHighlightBackgroundColor CHAR 7 '#f1f1f1'
menubarHighlightBackgroundColorDefault TINYINT 3 1
menubarHighlightForegroundColor CHAR 7 '#265a87'
menubarHighlightForegroundColorDefault TINYINT 3 1
customHeadingFont VARCHAR 100 NULL
customBodyFont VARCHAR 100 NULL
capitalizeBrowseCategories TINYINT 3 -1
defaultButtonBackgroundColor CHAR 7 '#ffffff'
defaultButtonBackgroundColorDefault TINYINT 3 1
defaultButtonForegroundColor CHAR 7 '#333333'
defaultButtonForegroundColorDefault TINYINT 3 1
defaultButtonBorderColor CHAR 7 '#cccccc'
defaultButtonBorderColorDefault TINYINT 3 1
defaultButtonHoverBackgroundColor CHAR 7 '#ebebeb'
defaultButtonHoverBackgroundColorDefault TINYINT 3 1
defaultButtonHoverForegroundColor CHAR 7 '#333333'
defaultButtonHoverForegroundColorDefault TINYINT 3 1
defaultButtonHoverBorderColor CHAR 7 '#adadad'
defaultButtonHoverBorderColorDefault TINYINT 3 1
primaryButtonBackgroundColor CHAR 7 '#428bca'
primaryButtonBackgroundColorDefault TINYINT 3 1
primaryButtonForegroundColor CHAR 7 '#ffffff'
primaryButtonForegroundColorDefault TINYINT 3 1
primaryButtonBorderColor CHAR 7 '#357ebd'
primaryButtonBorderColorDefault TINYINT 3 1
primaryButtonHoverBackgroundColor CHAR 7 '#3276b1'
primaryButtonHoverBackgroundColorDefault TINYINT 3 1
primaryButtonHoverForegroundColor CHAR 7 '#ffffff'
primaryButtonHoverForegroundColorDefault TINYINT 3 1
primaryButtonHoverBorderColor CHAR 7 '#285e8e'
primaryButtonHoverBorderColorDefault TINYINT 3 1
actionButtonBackgroundColor CHAR 7 '#428bca'
actionButtonBackgroundColorDefault TINYINT 3 1
actionButtonForegroundColor CHAR 7 '#ffffff'
actionButtonForegroundColorDefault TINYINT 3 1
actionButtonBorderColor CHAR 7 '#357ebd'
actionButtonBorderColorDefault TINYINT 3 1
actionButtonHoverBackgroundColor CHAR 7 '#3276b1'
actionButtonHoverBackgroundColorDefault TINYINT 3 1
actionButtonHoverForegroundColor CHAR 7 '#ffffff'
actionButtonHoverForegroundColorDefault TINYINT 3 1
actionButtonHoverBorderColor CHAR 7 '#285e8e'
actionButtonHoverBorderColorDefault TINYINT 3 1
infoButtonBackgroundColor CHAR 7 '#5bc0de'
infoButtonBackgroundColorDefault TINYINT 3 1
infoButtonForegroundColor CHAR 7 '#ffffff'
infoButtonForegroundColorDefault TINYINT 3 1
infoButtonBorderColor CHAR 7 '#46b8da'
infoButtonBorderColorDefault TINYINT 3 1
infoButtonHoverBackgroundColor CHAR 7 '#39b3d7'
infoButtonHoverBackgroundColorDefault TINYINT 3 1
infoButtonHoverForegroundColor CHAR 7 '#ffffff'
infoButtonHoverForegroundColorDefault TINYINT 3 1
infoButtonHoverBorderColor CHAR 7 '#269abc'
infoButtonHoverBorderColorDefault TINYINT 3 1
warningButtonBackgroundColor CHAR 7 '#f0ad4e'
warningButtonBackgroundColorDefault TINYINT 3 1
warningButtonForegroundColor CHAR 7 '#ffffff'
warningButtonForegroundColorDefault TINYINT 3 1
warningButtonBorderColor CHAR 7 '#eea236'
warningButtonBorderColorDefault TINYINT 3 1
warningButtonHoverBackgroundColor CHAR 7 '#ed9c28'
warningButtonHoverBackgroundColorDefault TINYINT 3 1
warningButtonHoverForegroundColor CHAR 7 '#ffffff'
warningButtonHoverForegroundColorDefault TINYINT 3 1
warningButtonHoverBorderColor CHAR 7 '#d58512'
warningButtonHoverBorderColorDefault TINYINT 3 1
dangerButtonBackgroundColor CHAR 7 '#d9534f'
dangerButtonBackgroundColorDefault TINYINT 3 1
dangerButtonForegroundColor CHAR 7 '#ffffff'
dangerButtonForegroundColorDefault TINYINT 3 1
dangerButtonBorderColor CHAR 7 '#d43f3a'
dangerButtonBorderColorDefault TINYINT 3 1
dangerButtonHoverBackgroundColor CHAR 7 '#d2322d'
dangerButtonHoverBackgroundColorDefault TINYINT 3 1
dangerButtonHoverForegroundColor CHAR 7 '#ffffff'
dangerButtonHoverForegroundColorDefault TINYINT 3 1
dangerButtonHoverBorderColor CHAR 7 '#ac2925'
dangerButtonHoverBorderColorDefault TINYINT 3 1
footerBackgroundColor CHAR 7 '#ffffff'
footerBackgroundColorDefault TINYINT 3 1
footerForegroundColor CHAR 7 '#6b6b6b'
footerForegroundColorDefault TINYINT 3 1
VARCHAR 100 NULL
footerLogoLink VARCHAR 255 NULL
closedPanelBackgroundColor CHAR 7 '#e7e7e7'
closedPanelBackgroundColorDefault TINYINT 3 1
closedPanelForegroundColor CHAR 7 '#333333'
closedPanelForegroundColorDefault TINYINT 3 1
openPanelBackgroundColor CHAR 7 '#4DACDE'
openPanelBackgroundColorDefault TINYINT 3 1
openPanelForegroundColor CHAR 7 '#ffffff'
openPanelForegroundColorDefault TINYINT 3 1
editionsButtonBackgroundColor CHAR 7 '#f8f9fa'
editionsButtonBackgroundColorDefault TINYINT 3 1
editionsButtonForegroundColor CHAR 7 '#212529'
editionsButtonForegroundColorDefault TINYINT 3 1
editionsButtonBorderColor CHAR 7 '#999999'
editionsButtonBorderColorDefault TINYINT 3 1
editionsButtonHoverBackgroundColor CHAR 7 '#e2e6ea'
editionsButtonHoverBackgroundColorDefault TINYINT 3 1
editionsButtonHoverForegroundColor CHAR 7 '#212529'
editionsButtonHoverForegroundColorDefault TINYINT 3 1
editionsButtonHoverBorderColor CHAR 7 '#dae0e5'
editionsButtonHoverBorderColorDefault TINYINT 3 1
linkColor CHAR 7 '#3174AF'
linkColorDefault TINYINT 3 1
badgeBackgroundColor CHAR 7 '#666666'
badgeBackgroundColorDefault TINYINT 3 1
badgeForegroundColor CHAR 7 '#ffffff'
badgeForegroundColorDefault TINYINT 3 1
badgeBorderRadius VARCHAR 6 NULL
toolsButtonBackgroundColor CHAR 7 '#4F4F4F'
toolsButtonBackgroundColorDefault TINYINT 3 1
toolsButtonForegroundColor CHAR 7 '#ffffff'
toolsButtonForegroundColorDefault TINYINT 3 1
toolsButtonBorderColor CHAR 7 '#636363'
toolsButtonBorderColorDefault TINYINT 3 1
toolsButtonHoverBackgroundColor CHAR 7 '#636363'
toolsButtonHoverBackgroundColorDefault TINYINT 3 1
toolsButtonHoverForegroundColor CHAR 7 '#ffffff'
toolsButtonHoverForegroundColorDefault TINYINT 3 1
toolsButtonHoverBorderColor CHAR 7 '#636363'
toolsButtonHoverBorderColorDefault TINYINT 3 1
panelBodyBackgroundColor CHAR 7 '#ffffff'
panelBodyBackgroundColorDefault TINYINT 3 1
panelBodyForegroundColor CHAR 7 '#404040'
panelBodyForegroundColorDefault TINYINT 3 1
linkHoverColor CHAR 7 '#265a87'
linkHoverColorDefault TINYINT 3 1
resultLabelColor CHAR 7 '#44484a'
resultLabelColorDefault TINYINT 3 1
resultValueColor CHAR 7 '#6B6B6B'
resultValueColorDefault TINYINT 3 1
breadcrumbsBackgroundColor CHAR 7 '#f5f5f5'
breadcrumbsBackgroundColorDefault TINYINT 3 1
breadcrumbsForegroundColor CHAR 7 '#6B6B6B'
breadcrumbsForegroundColorDefault TINYINT 3 1
searchToolsBackgroundColor CHAR 7 '#f5f5f5'
searchToolsBackgroundColorDefault TINYINT 3 1
searchToolsBorderColor CHAR 7 '#e3e3e3'
searchToolsBorderColorDefault TINYINT 3 1
searchToolsForegroundColor CHAR 7 '#6B6B6B'
searchToolsForegroundColorDefault TINYINT 3 1
menubarBackgroundColor CHAR 7 '#f1f1f1'
menubarBackgroundColorDefault TINYINT 3 1
menubarForegroundColor CHAR 7 '#303030'
menubarForegroundColorDefault TINYINT 3 1
menuDropdownBackgroundColor CHAR 7 '#ededed'
menuDropdownBackgroundColorDefault TINYINT 3 1
menuDropdownForegroundColor CHAR 7 '#404040'
menuDropdownForegroundColorDefault TINYINT 3 1
modalDialogBackgroundColor CHAR 7 '#ffffff'
modalDialogBackgroundColorDefault TINYINT 3 1
modalDialogForegroundColor CHAR 7 '#333333'
modalDialogForegroundColorDefault TINYINT 3 1
modalDialogHeaderFooterBackgroundColor CHAR 7 '#ffffff'
modalDialogHeaderFooterBackgroundColorDefault TINYINT 3 1
modalDialogHeaderFooterForegroundColor CHAR 7 '#333333'
modalDialogHeaderFooterForegroundColorDefault TINYINT 3 1
modalDialogHeaderFooterBorderColor CHAR 7 '#e5e5e5'
modalDialogHeaderFooterBorderColorDefault TINYINT 3 1
footerLogoAlt VARCHAR 255 NULL
logoApp VARCHAR 100 NULL
browseCategoryImageSize TINYINT 3 -1
browseImageLayout TINYINT 3 -1
fullWidth TINYINT 3 0
coverStyle VARCHAR 50 'border'
headerBackgroundImage VARCHAR 255 NULL
headerBackgroundImageSize VARCHAR 75 NULL
headerBackgroundImageRepeat VARCHAR 75 NULL
displayName VARCHAR 60 null
isHighContrast TINYINT 3 0
inactiveTabBackgroundColor CHAR 7 '#ffffff'
inactiveTabBackgroundColorDefault TINYINT 3 1
inactiveTabForegroundColor CHAR 7 '#6B6B6B'
inactiveTabForegroundColorDefault TINYINT 3 1
activeTabBackgroundColor CHAR 7 '#e7e7e7'
activeTabBackgroundColorDefault TINYINT 3 1
activeTabForegroundColor CHAR 7 '#333333'
activeTabForegroundColorDefault TINYINT 3 1
defaultCover VARCHAR 100 ''
booksImage VARCHAR 100 ''
eBooksImage VARCHAR 100 ''
audioBooksImage VARCHAR 100 ''
musicImage VARCHAR 100 ''
moviesImage VARCHAR 100 ''
booksImageSelected VARCHAR 100 ''
eBooksImageSelected VARCHAR 100 ''
audioBooksImageSelected VARCHAR 100 ''
musicImageSelected VARCHAR 100 ''
moviesImageSelected VARCHAR 100 ''
cookieConsentBackgroundColor CHAR 7 '#1D7FF0'
cookieConsentBackgroundColorDefault TINYINT 3 1
cookieConsentButtonColor CHAR 7 '#1D7FF0'
cookieConsentButtonColorDefault TINYINT 3 1
cookieConsentButtonHoverColor CHAR 7 '#FF0000'
cookieConsentButtonHoverColorDefault TINYINT 3 1
cookieConsentTextColor CHAR 7 '#FFFFFF'
cookieConsentTextColorDefault TINYINT 3 1
cookieConsentButtonTextColor CHAR 7 '#FFFFFF'
cookieConsentButtonTextColorDefault TINYINT 3 1
cookieConsentButtonHoverTextColor CHAR 7 '#FFFFFF'
cookieConsentButtonHoverTextColorDefault TINYINT 3 1
cookieConsentButtonBorderColor CHAR 7 '#FFFFFF'
cookieConsentButtonBorderColorDefault TINYINT 3 1
catalogImage VARCHAR 100 ''
genealogyImage VARCHAR 100 ''
articlesDBImage VARCHAR 100 ''
eventsImage VARCHAR 100 ''
listsImage VARCHAR 100 ''
libraryWebsiteImage VARCHAR 100 ''
historyArchivesImage VARCHAR 100 ''
accessibleBrowseCategories TINYINT 3 0

Indexes

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

Relationships