themes

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
themeName Performance Asc themeName

Relationships

Close relationships within degrees of separation