[dbo].[OrderNoteDetailExternalMap]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	3:33:55 PM Thursday, December 6, 2018
Last Modified	3:33:57 PM Thursday, December 6, 2018

	Name	Data Type	Max Length (Bytes)	Identity
	OrderNoteDetailExternalMapID	int	4	1 - 1
	OrderNoteDetailFID	int	4
$Indexes IX_OrderNoteDetailExternalMap_XmlInterfaceFIDExternalID: XmlInterfaceFID\ExternalID$	XmlInterfaceFID	int	4
$Indexes IX_OrderNoteDetailExternalMap_XmlInterfaceFIDExternalID: XmlInterfaceFID\ExternalID$	ExternalID	varchar(32)	32

	Name	Columns	Unique
	PK_OrderNoteDetailExternalMap	OrderNoteDetailExternalMapID
	IX_OrderNoteDetailExternalMap_XmlInterfaceFIDExternalID	XmlInterfaceFID, ExternalID
	IX_OrderNoteDetailExternalMap_OrderNoteDetailFID	OrderNoteDetailFID

Name	Delete	Columns
FK_OrderNoteDetailExternalMap_OrderNoteDetail	Cascade	OrderNoteDetailFID->[dbo].[OrderNoteDetail].[OrderNoteDetailID]
FK_OrderNoteDetailExternalMap_XmlInterface		XmlInterfaceFID->[dbo].[XmlInterface].[XmlInterfaceID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

CREATE TABLE [dbo].[OrderNoteDetailExternalMap]
(
[OrderNoteDetailExternalMapID] [int] NOT NULL IDENTITY(1, 1),
[OrderNoteDetailFID] [int] NOT NULL,
[XmlInterfaceFID] [int] NOT NULL,
[ExternalID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderNoteDetailExternalMap] ADD CONSTRAINT [PK_OrderNoteDetailExternalMap] PRIMARY KEY CLUSTERED  ([OrderNoteDetailExternalMapID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OrderNoteDetailExternalMap_OrderNoteDetailFID] ON [dbo].[OrderNoteDetailExternalMap] ([OrderNoteDetailFID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_OrderNoteDetailExternalMap_XmlInterfaceFIDExternalID] ON [dbo].[OrderNoteDetailExternalMap] ([XmlInterfaceFID], [ExternalID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderNoteDetailExternalMap] ADD CONSTRAINT [FK_OrderNoteDetailExternalMap_OrderNoteDetail] FOREIGN KEY ([OrderNoteDetailFID]) REFERENCES [dbo].[OrderNoteDetail] ([OrderNoteDetailID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[OrderNoteDetailExternalMap] ADD CONSTRAINT [FK_OrderNoteDetailExternalMap_XmlInterface] FOREIGN KEY ([XmlInterfaceFID]) REFERENCES [dbo].[XmlInterface] ([XmlInterfaceID])
GO
GRANT SELECT ON  [dbo].[OrderNoteDetailExternalMap] TO [MssExec]
GRANT INSERT ON  [dbo].[OrderNoteDetailExternalMap] TO [MssExec]
GRANT DELETE ON  [dbo].[OrderNoteDetailExternalMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[OrderNoteDetailExternalMap] TO [MssExec]
GO