CREATE TABLE [dbo].[SCMoveOrderDetails]
(
[MoveOrderDetailID] [int] NOT NULL IDENTITY(1, 1),
[MoveOrderID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[Quantity] [int] NOT NULL,
[Fulfilled] [int] NOT NULL CONSTRAINT [DF_SCMoveOrderDetails_Fulfilled] DEFAULT ((0)),
[Cancelled] [int] NOT NULL CONSTRAINT [DF_SCMoveOrderDetails_Cancelled] DEFAULT ((0)),
[SrcLocationID] [int] NOT NULL,
[SrcLocationRemarks] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestLocationID] [int] NOT NULL,
[DestLocationRemarks] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConjugateLinkedDetailID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [PK_SCMoveOrderDetails] PRIMARY KEY CLUSTERED ([MoveOrderDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [IX_SCMoveOrderDetails_MoveOrderID] UNIQUE NONCLUSTERED ([MoveOrderID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_DestLocationID_ARCustomers] FOREIGN KEY ([DestLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrderDetails] FOREIGN KEY ([MoveOrderID], [ConjugateLinkedDetailID]) REFERENCES [dbo].[SCMoveOrderDetails] ([MoveOrderID], [DetailID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrders] FOREIGN KEY ([MoveOrderID]) REFERENCES [dbo].[SCMoveOrders] ([MoveOrderID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_SrcLocationID_ARCustomers] FOREIGN KEY ([SrcLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO