Tables [dbo].[PlasticWebProvider]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created9:32:17 AM Friday, December 7, 2018
Last Modified7:38:34 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PlasticWebProvider: WebProviderIDWebProviderIDint4
No
1 - 1
Foreign Keys FK_PlasticWebProvider_ProviderFID: [dbo].[PlasticProvider].ProviderFIDIndexes IX_PlasticWebProvider_Provider: ProviderFIDProviderFIDint4
No
AllowWebPaymentsbit1
No
((0))
WebCompanyCodevarchar(10)10
Yes
WebProviderNamenvarchar(80)160
Yes
WebAddressInfo1nvarchar(80)160
Yes
WebAddressInfo2nvarchar(80)160
Yes
WebAddressInfo3nvarchar(80)160
Yes
WebAddressInfo4nvarchar(80)160
Yes
WebSiteUrlnvarchar(80)160
Yes
WebServiceMarknvarchar(80)160
Yes
DaysWebItemsStayOpenint4
No
((30))
MaxTransactionsPerItemint4
No
((5))
MinimumAmountmoney8
No
((0))
TransactionIdentifiervarchar(10)10
Yes
WebLogovarbinary(max)max
Yes
ImageTypevarchar(30)30
Yes
WebHtmlnvarchar(max)max
Yes
WebSynchronizeddatetime8
Yes
ForceRecordSavebit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PlasticWebProvider: WebProviderIDPK_PlasticWebProviderWebProviderID
Yes
IX_PlasticWebProvider_ProviderProviderFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_PlasticWebProvider_ProviderFIDProviderFID->[dbo].[PlasticProvider].[ProviderID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PlasticWebProvider]
(
[WebProviderID] [int] NOT NULL IDENTITY(1, 1),
[ProviderFID] [int] NOT NULL,
[AllowWebPayments] [bit] NOT NULL CONSTRAINT [DF_PlasticWebProvider_AllowWebPayments] DEFAULT ((0)),
[WebCompanyCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebProviderName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebAddressInfo4] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebSiteUrl] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebServiceMark] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DaysWebItemsStayOpen] [int] NOT NULL CONSTRAINT [DF_PlasticWebProvider_DaysWebItemsStayOpen] DEFAULT ((30)),
[MaxTransactionsPerItem] [int] NOT NULL CONSTRAINT [DF_PlasticWebProvider_MaxTransactionsPerItem] DEFAULT ((5)),
[MinimumAmount] [money] NOT NULL CONSTRAINT [DF_PlasticWebProvider_MinimumAmount] DEFAULT ((0)),
[TransactionIdentifier] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebLogo] [varbinary] (max) NULL,
[ImageType] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebHtml] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebSynchronized] [datetime] NULL,
[ForceRecordSave] [bit] NOT NULL CONSTRAINT [DF_PlasticWebProvider_ForceRecordSave] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [PK_PlasticWebProvider] PRIMARY KEY CLUSTERED  ([WebProviderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [IX_PlasticWebProvider_Provider] UNIQUE NONCLUSTERED  ([ProviderFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebProvider] ADD CONSTRAINT [FK_PlasticWebProvider_ProviderFID] FOREIGN KEY ([ProviderFID]) REFERENCES [dbo].[PlasticProvider] ([ProviderID])
GO
GRANT SELECT ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticWebProvider] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticWebProvider] TO [MssExec]
GO
Uses
Used By