Tables [dbo].[PlasticWebDeal]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created9:32:17 AM Friday, December 7, 2018
Last Modified7:35:37 PM Tuesday, June 11, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PlasticWebDeal: WebDealIDWebDealIDint4
No
1 - 1
Foreign Keys FK_PlasticWebDeal_ProviderFID: [dbo].[PlasticProvider].ProviderFIDProviderFIDint4
No
Indexes IX_PlasticWebDeal_MoversConnectFID: MoversConnectFIDMoversConnectFIDbigint8
No
ExternalIDvarchar(90)90
No
PaymentUrlvarchar(176)176
No
Descriptionvarchar(255)255
No
Foreign Keys FK_PlasticWebDeal_BranchPriKey: [dbo].[Branch].BranchPriKeyBranchPriKeyint4
No
CustomerNumbervarchar(15)15
Yes
Foreign Keys FK_PlasticWebDeal_OrderID: [dbo].[Orders].OrderFIDIndexes IX_PlasticWebDeal_OrderFID: OrderFIDOrderFIDint4
Yes
InvoicedHeaderFIDint4
Yes
StorageFIDint4
Yes
Indexes IX_PlasticWebDeal_StorageInvoiceFID: StorageInvoiceFIDStorageInvoiceFIDint4
Yes
ItemAmountmoney8
No
Foreign Keys FK_PlasticWebDeal_SysUserFID: [dbo].[Sysuser].SysUserFIDIndexes IX_PlasticWebDeal_SysUserFID: SysUserFIDSysUserFIDint4
No
CreatedDatedatetime8
No
EmailAddressvarchar(255)255
Yes
PaymentNotificationbit1
No
((0))
NotificationEmailAddressvarchar(255)255
Yes
CaptureCardInfoOnlybit1
No
((0))
AttachCardToCustomerbit1
No
((0))
Check Constraints CK_PlasticWebDeal_SysEmailTypeCode : ((1)=[dbo].[SysEmailTypeCodeIsValid]([SysEmailTypeCode]))SysEmailTypeCodechar(1)1
No
('O')
WasReprocessedbit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PlasticWebDeal: WebDealIDPK_PlasticWebDealWebDealID
Yes
IX_PlasticWebDeal_MoversConnectFIDMoversConnectFID
IX_PlasticWebDeal_OrderFIDOrderFID
IX_PlasticWebDeal_StorageInvoiceFIDStorageInvoiceFID
IX_PlasticWebDeal_SysUserFIDSysUserFID
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_PlasticWebDeal_SysEmailTypeCodeSysEmailTypeCode((1)=[dbo].[SysEmailTypeCodeIsValid]([SysEmailTypeCode]))
Foreign Keys Foreign Keys
NameColumns
FK_PlasticWebDeal_BranchPriKeyBranchPriKey->[dbo].[Branch].[BranchPriKey]
FK_PlasticWebDeal_OrderIDOrderFID->[dbo].[Orders].[PriKey]
FK_PlasticWebDeal_ProviderFIDProviderFID->[dbo].[PlasticProvider].[ProviderID]
FK_PlasticWebDeal_SysUserFIDSysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PlasticWebDeal]
(
[WebDealID] [int] NOT NULL IDENTITY(1, 1),
[ProviderFID] [int] NOT NULL,
[MoversConnectFID] [bigint] NOT NULL,
[ExternalID] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PaymentUrl] [varchar] (176) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BranchPriKey] [int] NOT NULL,
[CustomerNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderFID] [int] NULL,
[InvoicedHeaderFID] [int] NULL,
[StorageFID] [int] NULL,
[StorageInvoiceFID] [int] NULL,
[ItemAmount] [money] NOT NULL,
[SysUserFID] [int] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[EmailAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PaymentNotification] [bit] NOT NULL CONSTRAINT [DF_PlasticWebDeal_PaymentNotification] DEFAULT ((0)),
[NotificationEmailAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CaptureCardInfoOnly] [bit] NOT NULL CONSTRAINT [DF_PlasticWebDeal_CaptureCardInfoOnly] DEFAULT ((0)),
[AttachCardToCustomer] [bit] NOT NULL CONSTRAINT [DF_PlasticWebDeal_AttachCardToCustomer] DEFAULT ((0)),
[SysEmailTypeCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PlasticWebDeal_SysEmailTypeCode] DEFAULT ('O'),
[WasReprocessed] [bit] NOT NULL CONSTRAINT [DF_PlasticWebDeal_WasReprocessed] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [CK_PlasticWebDeal_SysEmailTypeCode] CHECK (((1)=[dbo].[SysEmailTypeCodeIsValid]([SysEmailTypeCode])))
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [PK_PlasticWebDeal] PRIMARY KEY CLUSTERED  ([WebDealID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticWebDeal_MoversConnectFID] ON [dbo].[PlasticWebDeal] ([MoversConnectFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticWebDeal_OrderFID] ON [dbo].[PlasticWebDeal] ([OrderFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticWebDeal_StorageInvoiceFID] ON [dbo].[PlasticWebDeal] ([StorageInvoiceFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticWebDeal_SysUserFID] ON [dbo].[PlasticWebDeal] ([SysUserFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [FK_PlasticWebDeal_BranchPriKey] FOREIGN KEY ([BranchPriKey]) REFERENCES [dbo].[Branch] ([BranchPriKey])
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [FK_PlasticWebDeal_OrderID] FOREIGN KEY ([OrderFID]) REFERENCES [dbo].[Orders] ([PriKey])
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [FK_PlasticWebDeal_ProviderFID] FOREIGN KEY ([ProviderFID]) REFERENCES [dbo].[PlasticProvider] ([ProviderID])
GO
ALTER TABLE [dbo].[PlasticWebDeal] ADD CONSTRAINT [FK_PlasticWebDeal_SysUserFID] FOREIGN KEY ([SysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[PlasticWebDeal] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticWebDeal] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticWebDeal] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticWebDeal] TO [MssExec]
GO
Uses
Used By