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

Close relationships within degrees of separation