CREATE TABLE [dbo].[SOFulFillDetailSourceLinks]
(
[FulFillDetailSourceLinkID] [int] NOT NULL IDENTITY(1, 1),
[FulFillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SourceFulFillID] [int] NOT NULL,
[SourceDetailID] [int] NOT NULL,
[SourceFulFillDetailBinID] [int] NULL,
[ShipQuantityFulfilled] [decimal] (18, 6) NOT NULL,
[ShipQuantityReversed] [decimal] (18, 6) NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SOFulFillDetailSourceLinks_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulFillDetailSourceLinks] ADD CONSTRAINT [PK_SOFulFillDetailSourceLinks] PRIMARY KEY CLUSTERED ([FulFillDetailSourceLinkID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulFillDetailSourceLinks] ADD CONSTRAINT [FK_SOFulFillDetailSourceLinks_FulFillID_SOFulfillDetails] FOREIGN KEY ([FulFillID], [DetailID]) REFERENCES [dbo].[SOFulfillDetails] ([FulfillID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulFillDetailSourceLinks] ADD CONSTRAINT [FK_SOFulFillDetailSourceLinks_SourceFulFillDetailBinID_SOFulfillDetailBins] FOREIGN KEY ([SourceFulFillDetailBinID]) REFERENCES [dbo].[SOFulfillDetailBins] ([FulFillDetailBinID])
GO
ALTER TABLE [dbo].[SOFulFillDetailSourceLinks] ADD CONSTRAINT [FK_SOFulFillDetailSourceLinks_SourceFulFillID_SOFulfillDetails] FOREIGN KEY ([SourceFulFillID], [SourceDetailID]) REFERENCES [dbo].[SOFulfillDetails] ([FulfillID], [DetailID])
GO