CREATE TABLE [dbo].[SHChangeOrders]
(
[ChangeOrderID] [int] NOT NULL,
[ChangeOrderNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[ApplyToID] [int] NULL,
[ChangeOrderTypeID] [int] NOT NULL,
[ChangeOrderStatusID] [int] NOT NULL,
[AssignedToID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReqDate] [datetime] NULL,
[CloseDate] [datetime] 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].[SHChangeOrders] ADD CONSTRAINT [PK_SHChangeOrders] PRIMARY KEY CLUSTERED ([ChangeOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [UQ__SHChange__26130A7205890E96] UNIQUE NONCLUSTERED ([ChangeOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [UQ__SHChange__66B8B627DE0A51FF] UNIQUE NONCLUSTERED ([ChangeOrderNumber]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_ApplyToID_SHChangeOrders] FOREIGN KEY ([ApplyToID]) REFERENCES [dbo].[SHChangeOrders] ([ChangeOrderID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_ChangeOrderStatusID_SHChangeOrderStatuses] FOREIGN KEY ([ChangeOrderStatusID]) REFERENCES [dbo].[SHChangeOrderStatuses] ([ChangeOrderStatusID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_ChangeOrderTypeID_SHChangeOrderTypes] FOREIGN KEY ([ChangeOrderTypeID]) REFERENCES [dbo].[SHChangeOrderTypes] ([ChangeOrderTypeID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SHChangeOrders] ADD CONSTRAINT [FK_SHChangeOrders_ReportID_SCReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCReports] ([ReportID])
GO