CREATE TABLE [dbo].[SHCOEquipmentMoveDetails]
(
[EquipmentMoveDetailID] [int] NOT NULL IDENTITY(1, 1),
[ChangeOrderID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[Status] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[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].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [PK_SHCOEquipmentMoveDetails] PRIMARY KEY CLUSTERED ([EquipmentMoveDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [IX_SHCOEquipmentMoveDetails_ChangeOrderID] UNIQUE NONCLUSTERED ([ChangeOrderID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHChangeOrders] FOREIGN KEY ([ChangeOrderID]) REFERENCES [dbo].[SHChangeOrders] ([ChangeOrderID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHCOEquipmentMoveDetails] FOREIGN KEY ([ChangeOrderID], [ConjugateLinkedDetailID]) REFERENCES [dbo].[SHCOEquipmentMoveDetails] ([ChangeOrderID], [DetailID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_DestLocationID_ARCustomers] FOREIGN KEY ([DestLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_SrcLocationID_ARCustomers] FOREIGN KEY ([SrcLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO