Tables [dbo].[SHChangeOrders]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:57 AM Thursday, March 21, 2019
Last Modified1:15:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SHChangeOrders: ChangeOrderIDIndexes UQ__SHChange__26130A7205890E96ChangeOrderIDint4
False
Indexes UQ__SHChange__66B8B627DE0A51FFChangeOrderNumbervarchar(15)15
False
Datedatetime8
False
Foreign Keys FK_SHChangeOrders_ApplyToID_SHChangeOrders: [dbo].[SHChangeOrders].ApplyToIDApplyToIDint4
True
Foreign Keys FK_SHChangeOrders_ChangeOrderTypeID_SHChangeOrderTypes: [dbo].[SHChangeOrderTypes].ChangeOrderTypeIDChangeOrderTypeIDint4
False
Foreign Keys FK_SHChangeOrders_ChangeOrderStatusID_SHChangeOrderStatuses: [dbo].[SHChangeOrderStatuses].ChangeOrderStatusIDChangeOrderStatusIDint4
False
AssignedToIDchar(8)8
True
ReqDatedatetime8
True
CloseDatedatetime8
True
Foreign Keys FK_SHChangeOrders_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Foreign Keys FK_SHChangeOrders_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
True
Foreign Keys FK_SHChangeOrders_ReportID_SCReports: [dbo].[SCReports].ReportIDReportIDint4
True
Foreign Keys FK_SHChangeOrders_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
Descriptionvarchar(255)255
False
Remarksvarchar(1024)1024
False
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
False
LastUpdatedatetime8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SHChangeOrders: ChangeOrderIDPK_SHChangeOrdersChangeOrderID
True
80
UQ__SHChange__26130A7205890E96ChangeOrderID
True
80
UQ__SHChange__66B8B627DE0A51FFChangeOrderNumber
True
80
NameColumns
FK_SHChangeOrders_ApplyToID_SHChangeOrdersApplyToID->[dbo].[SHChangeOrders].[ChangeOrderID]
FK_SHChangeOrders_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SHChangeOrders_ChangeOrderStatusID_SHChangeOrderStatusesChangeOrderStatusID->[dbo].[SHChangeOrderStatuses].[ChangeOrderStatusID]
FK_SHChangeOrders_ChangeOrderTypeID_SHChangeOrderTypesChangeOrderTypeID->[dbo].[SHChangeOrderTypes].[ChangeOrderTypeID]
FK_SHChangeOrders_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SHChangeOrders_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_SHChangeOrders_ReportID_SCReportsReportID->[dbo].[SCReports].[ReportID]
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