Tables [dbo].[PlasticProviderHppOptions]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created7:35:07 PM Tuesday, June 11, 2024
Last Modified7:35:44 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PlasticProviderHppOptions: ProviderHppOptionsIDProviderHppOptionsIDint4
No
1 - 1
Foreign Keys FK_PlasticProviderHppOptions_ProviderFID: [dbo].[PlasticProvider].ProviderFIDIndexes IX_PlasticProviderHppOptions_ProviderFID: ProviderFIDProviderFIDint4
No
LandscapeOrientationbit1
No
PageFontNamevarchar(128)128
Yes
PageFontSizeint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_PageTextColorFID: [dbo].[CssColor].PageTextColorFIDPageTextColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_PageBackColorFID: [dbo].[CssColor].PageBackColorFIDPageBackColorFIDint4
Yes
TitleTextvarchar(64)64
Yes
Foreign Keys FK_PlasticProviderHppOptions_TitleColorFID: [dbo].[CssColor].TitleColorFIDTitleColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_ButtonTextColorFID: [dbo].[CssColor].ButtonTextColorFIDButtonTextColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_ButtonBackColorFID: [dbo].[CssColor].ButtonBackColorFIDButtonBackColorFIDint4
Yes
AcceptSalesButtonTextvarchar(30)30
Yes
AcceptTokenButtonTextvarchar(30)30
Yes
CancelSalesButtonTextvarchar(30)30
Yes
CancelTokenButtonTextvarchar(30)30
Yes
ShowBillingAddressBlockbit1
No
ShowCountrybit1
No
HaveRoundedCornersbit1
No
HaveZipPromptbit1
No
UseHostFramebit1
No
HostPageFontNamevarchar(128)128
Yes
HostPageFontSizeint4
Yes
HideHostPageWarningbit1
No
Foreign Keys FK_PlasticProviderHppOptions_HostPageWarningBackColorFID: [dbo].[CssColor].HostPageWarningBackColorFIDHostPageWarningBackColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageWarningTextColorFID: [dbo].[CssColor].HostPageWarningTextColorFIDHostPageWarningTextColorFIDint4
Yes
HostPageWarningPaddingint4
Yes
HostPageWarningMessagenvarchar(128)256
Yes
HostPageHeaderPaddingint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageHeaderBackColorFID: [dbo].[CssColor].HostPageHeaderBackColorFIDHostPageHeaderBackColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageHeaderTextColorFID: [dbo].[CssColor].HostPageHeaderTextColorFIDHostPageHeaderTextColorFIDint4
Yes
HostPageLeftSidebarLogoWidthint4
Yes
Check Constraints CK_PlasticProviderHppOptions_HostPageLeftSidebarFlexPct : ([HostPageLeftSidebarFlexPct] IS NULL OR [HostPageLeftSidebarFlexPct]>=(0) AND [HostPageLeftSidebarFlexPct]<=(100))HostPageLeftSidebarFlexPcttinyint1
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageLeftSidebarBackColorFID: [dbo].[CssColor].HostPageLeftSidebarBackColorFIDHostPageLeftSidebarBackColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageLeftSidebarTextColorFID: [dbo].[CssColor].HostPageLeftSidebarTextColorFIDHostPageLeftSidebarTextColorFIDint4
Yes
HostPageLeftSidebarPaddingint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageMainSectionBackColorFID: [dbo].[CssColor].HostPageMainSectionBackColorFIDHostPageMainSectionBackColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageMainSectionTextColorFID: [dbo].[CssColor].HostPageMainSectionTextColorFIDHostPageMainSectionTextColorFIDint4
Yes
HostPageMainSectionPaddingint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageFooterBackColorFID: [dbo].[CssColor].HostPageFooterBackColorFIDHostPageFooterBackColorFIDint4
Yes
Foreign Keys FK_PlasticProviderHppOptions_HostPageFooterTextColorFID: [dbo].[CssColor].HostPageFooterTextColorFIDHostPageFooterTextColorFIDint4
Yes
HostPageFooterPaddingint4
Yes
HostPageFooterAlignCenterbit1
No
HostPageMinWidthToHaveTwoColumnsint4
Yes
HppFrameHeightint4
Yes
HppFrameWidthint4
Yes
WebPageHtmlnvarchar(max)max
Yes
WebPageVersionint4
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PlasticProviderHppOptions: ProviderHppOptionsIDPK_PlasticProviderHppOptionsProviderHppOptionsID
Yes
IX_PlasticProviderHppOptions_ProviderFIDProviderFID
Yes
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_PlasticProviderHppOptions_HostPageLeftSidebarFlexPctHostPageLeftSidebarFlexPct([HostPageLeftSidebarFlexPct] IS NULL OR [HostPageLeftSidebarFlexPct]>=(0) AND [HostPageLeftSidebarFlexPct]<=(100))
Foreign Keys Foreign Keys
NameColumns
FK_PlasticProviderHppOptions_ButtonBackColorFIDButtonBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_ButtonTextColorFIDButtonTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageFooterBackColorFIDHostPageFooterBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageFooterTextColorFIDHostPageFooterTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageHeaderBackColorFIDHostPageHeaderBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageHeaderTextColorFIDHostPageHeaderTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageLeftSidebarBackColorFIDHostPageLeftSidebarBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageLeftSidebarTextColorFIDHostPageLeftSidebarTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageMainSectionBackColorFIDHostPageMainSectionBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageMainSectionTextColorFIDHostPageMainSectionTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageWarningBackColorFIDHostPageWarningBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_HostPageWarningTextColorFIDHostPageWarningTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_PageBackColorFIDPageBackColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_PageTextColorFIDPageTextColorFID->[dbo].[CssColor].[CssColorID]
FK_PlasticProviderHppOptions_ProviderFIDProviderFID->[dbo].[PlasticProvider].[ProviderID]
FK_PlasticProviderHppOptions_TitleColorFIDTitleColorFID->[dbo].[CssColor].[CssColorID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PlasticProviderHppOptions]
(
[ProviderHppOptionsID] [int] NOT NULL IDENTITY(1, 1),
[ProviderFID] [int] NOT NULL,
[LandscapeOrientation] [bit] NOT NULL,
[PageFontName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PageFontSize] [int] NULL,
[PageTextColorFID] [int] NULL,
[PageBackColorFID] [int] NULL,
[TitleText] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TitleColorFID] [int] NULL,
[ButtonTextColorFID] [int] NULL,
[ButtonBackColorFID] [int] NULL,
[AcceptSalesButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AcceptTokenButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelSalesButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CancelTokenButtonText] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShowBillingAddressBlock] [bit] NOT NULL,
[ShowCountry] [bit] NOT NULL,
[HaveRoundedCorners] [bit] NOT NULL,
[HaveZipPrompt] [bit] NOT NULL,
[UseHostFrame] [bit] NOT NULL,
[HostPageFontName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostPageFontSize] [int] NULL,
[HideHostPageWarning] [bit] NOT NULL,
[HostPageWarningBackColorFID] [int] NULL,
[HostPageWarningTextColorFID] [int] NULL,
[HostPageWarningPadding] [int] NULL,
[HostPageWarningMessage] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HostPageHeaderPadding] [int] NULL,
[HostPageHeaderBackColorFID] [int] NULL,
[HostPageHeaderTextColorFID] [int] NULL,
[HostPageLeftSidebarLogoWidth] [int] NULL,
[HostPageLeftSidebarFlexPct] [tinyint] NULL,
[HostPageLeftSidebarBackColorFID] [int] NULL,
[HostPageLeftSidebarTextColorFID] [int] NULL,
[HostPageLeftSidebarPadding] [int] NULL,
[HostPageMainSectionBackColorFID] [int] NULL,
[HostPageMainSectionTextColorFID] [int] NULL,
[HostPageMainSectionPadding] [int] NULL,
[HostPageFooterBackColorFID] [int] NULL,
[HostPageFooterTextColorFID] [int] NULL,
[HostPageFooterPadding] [int] NULL,
[HostPageFooterAlignCenter] [bit] NOT NULL,
[HostPageMinWidthToHaveTwoColumns] [int] NULL,
[HppFrameHeight] [int] NULL,
[HppFrameWidth] [int] NULL,
[WebPageHtml] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebPageVersion] [int] NOT NULL CONSTRAINT [DF_PlasticProviderHppOptions_WebPageVersion] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [CK_PlasticProviderHppOptions_HostPageLeftSidebarFlexPct] CHECK (([HostPageLeftSidebarFlexPct] IS NULL OR [HostPageLeftSidebarFlexPct]>=(0) AND [HostPageLeftSidebarFlexPct]<=(100)))
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [PK_PlasticProviderHppOptions] PRIMARY KEY CLUSTERED  ([ProviderHppOptionsID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [IX_PlasticProviderHppOptions_ProviderFID] UNIQUE NONCLUSTERED  ([ProviderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ButtonBackColorFID] FOREIGN KEY ([ButtonBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ButtonTextColorFID] FOREIGN KEY ([ButtonTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageFooterBackColorFID] FOREIGN KEY ([HostPageFooterBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageFooterTextColorFID] FOREIGN KEY ([HostPageFooterTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageHeaderBackColorFID] FOREIGN KEY ([HostPageHeaderBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageHeaderTextColorFID] FOREIGN KEY ([HostPageHeaderTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageLeftSidebarBackColorFID] FOREIGN KEY ([HostPageLeftSidebarBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageLeftSidebarTextColorFID] FOREIGN KEY ([HostPageLeftSidebarTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageMainSectionBackColorFID] FOREIGN KEY ([HostPageMainSectionBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageMainSectionTextColorFID] FOREIGN KEY ([HostPageMainSectionTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageWarningBackColorFID] FOREIGN KEY ([HostPageWarningBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_HostPageWarningTextColorFID] FOREIGN KEY ([HostPageWarningTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_PageBackColorFID] FOREIGN KEY ([PageBackColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_PageTextColorFID] FOREIGN KEY ([PageTextColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_ProviderFID] FOREIGN KEY ([ProviderFID]) REFERENCES [dbo].[PlasticProvider] ([ProviderID])
GO
ALTER TABLE [dbo].[PlasticProviderHppOptions] ADD CONSTRAINT [FK_PlasticProviderHppOptions_TitleColorFID] FOREIGN KEY ([TitleColorFID]) REFERENCES [dbo].[CssColor] ([CssColorID])
GO
GRANT SELECT ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticProviderHppOptions] TO [MssExec]
GO
Uses
Used By