CREATE TABLE [dbo].[SCMoveOrders]
(
[MoveOrderID] [int] NOT NULL IDENTITY(1, 1),
[MoveOrderNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[ApplyToID] [int] NULL,
[MoveOrderTypeID] [int] NOT NULL,
[MoveOrderStatusID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[InvoiceID] [int] NULL,
[ReportID] [int] NULL,
[CallID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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].[SCMoveOrders] ADD CONSTRAINT [PK_SCMoveOrders] PRIMARY KEY CLUSTERED ([MoveOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [UQ__SCMoveOr__FF7B35FAAEFEE259] UNIQUE NONCLUSTERED ([MoveOrderNumber]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_ApplyToID_SCMoveOrders] FOREIGN KEY ([ApplyToID]) REFERENCES [dbo].[SCMoveOrders] ([MoveOrderID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_MoveOrderStatusID_SCMoveOrderStatuses] FOREIGN KEY ([MoveOrderStatusID]) REFERENCES [dbo].[SCMoveOrderStatuses] ([MoveOrderStatusID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_MoveOrderTypeID_SCMoveOrderTypes] FOREIGN KEY ([MoveOrderTypeID]) REFERENCES [dbo].[SCMoveOrderTypes] ([MoveOrderTypeID])
GO
ALTER TABLE [dbo].[SCMoveOrders] ADD CONSTRAINT [FK_SCMoveOrders_ReportID_SCReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCReports] ([ReportID])
GO