Tables [dbo].[XmlOrderEmailTypeMap]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)10
Created9:08:29 AM Thursday, May 23, 2024
Last Modified9:08:32 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Primary Key PK_XmlOrderEmailTypeMap: XmlOrderEmailTypeMapIDXmlOrderEmailTypeMapIDint4
No
1 - 1
Foreign Keys FK_XmlOrderEmailTypeMap_OrderEmailType: [dbo].[OrderEmailType].OrderEmailTypeFIDIndexes IX_XmlOrderEmailTypeMap_OrderEmailType_XMLInterface: OrderEmailTypeFID\XmlInterfaceFIDOrderEmailTypeFIDint4
No
Foreign Keys FK_XmlOrderEmailTypeMap_XmlInterface: [dbo].[XmlInterface].XmlInterfaceFIDIndexes IX_XmlOrderEmailTypeMap_OrderEmailType_XMLInterface: OrderEmailTypeFID\XmlInterfaceFIDIndexes IX_XmlOrderEmailTypeMap_XMLInterface_ExternalCode: XmlInterfaceFID\ExternalCodeXmlInterfaceFIDint4
No
Indexes IX_XmlOrderEmailTypeMap_XMLInterface_ExternalCode: XmlInterfaceFID\ExternalCodeExternalCodevarchar(32)32
No
Indexes Indexes
NameColumnsUnique
Primary Key PK_XmlOrderEmailTypeMap: XmlOrderEmailTypeMapIDPK_XmlOrderEmailTypeMapXmlOrderEmailTypeMapID
Yes
IX_XmlOrderEmailTypeMap_OrderEmailType_XMLInterfaceOrderEmailTypeFID, XmlInterfaceFID
Yes
IX_XmlOrderEmailTypeMap_XMLInterface_ExternalCodeXmlInterfaceFID, ExternalCode
Yes
Foreign Keys Foreign Keys
NameDeleteColumns
FK_XmlOrderEmailTypeMap_OrderEmailTypeCascadeOrderEmailTypeFID->[dbo].[OrderEmailType].[OrderEmailTypeID]
FK_XmlOrderEmailTypeMap_XmlInterfaceCascadeXmlInterfaceFID->[dbo].[XmlInterface].[XmlInterfaceID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[XmlOrderEmailTypeMap]
(
[XmlOrderEmailTypeMapID] [int] NOT NULL IDENTITY(1, 1),
[OrderEmailTypeFID] [int] NOT NULL,
[XmlInterfaceFID] [int] NOT NULL,
[ExternalCode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderEmailTypeMap] ADD CONSTRAINT [PK_XmlOrderEmailTypeMap] PRIMARY KEY NONCLUSTERED  ([XmlOrderEmailTypeMapID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderEmailTypeMap] ADD CONSTRAINT [IX_XmlOrderEmailTypeMap_OrderEmailType_XMLInterface] UNIQUE NONCLUSTERED  ([OrderEmailTypeFID], [XmlInterfaceFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderEmailTypeMap] ADD CONSTRAINT [IX_XmlOrderEmailTypeMap_XMLInterface_ExternalCode] UNIQUE NONCLUSTERED  ([XmlInterfaceFID], [ExternalCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlOrderEmailTypeMap] ADD CONSTRAINT [FK_XmlOrderEmailTypeMap_OrderEmailType] FOREIGN KEY ([OrderEmailTypeFID]) REFERENCES [dbo].[OrderEmailType] ([OrderEmailTypeID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[XmlOrderEmailTypeMap] ADD CONSTRAINT [FK_XmlOrderEmailTypeMap_XmlInterface] FOREIGN KEY ([XmlInterfaceFID]) REFERENCES [dbo].[XmlInterface] ([XmlInterfaceID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[XmlOrderEmailTypeMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlOrderEmailTypeMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlOrderEmailTypeMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlOrderEmailTypeMap] TO [MssExec]
GO
Uses
Used By