Tables [dbo].[SCMoveOrders]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:20 AM Thursday, March 21, 2019
Last Modified1:15:07 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SCMoveOrders: MoveOrderIDMoveOrderIDint4
False
1 - 1
Indexes UQ__SCMoveOr__FF7B35FAAEFEE259MoveOrderNumbervarchar(15)15
False
Datedatetime8
False
Foreign Keys FK_SCMoveOrders_ApplyToID_SCMoveOrders: [dbo].[SCMoveOrders].ApplyToIDApplyToIDint4
True
Foreign Keys FK_SCMoveOrders_MoveOrderTypeID_SCMoveOrderTypes: [dbo].[SCMoveOrderTypes].MoveOrderTypeIDMoveOrderTypeIDint4
False
Foreign Keys FK_SCMoveOrders_MoveOrderStatusID_SCMoveOrderStatuses: [dbo].[SCMoveOrderStatuses].MoveOrderStatusIDMoveOrderStatusIDint4
False
Foreign Keys FK_SCMoveOrders_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Foreign Keys FK_SCMoveOrders_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
True
Foreign Keys FK_SCMoveOrders_ReportID_SCReports: [dbo].[SCReports].ReportIDReportIDint4
True
Foreign Keys FK_SCMoveOrders_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_SCMoveOrders: MoveOrderIDPK_SCMoveOrdersMoveOrderID
True
80
UQ__SCMoveOr__FF7B35FAAEFEE259MoveOrderNumber
True
80
NameColumns
FK_SCMoveOrders_ApplyToID_SCMoveOrdersApplyToID->[dbo].[SCMoveOrders].[MoveOrderID]
FK_SCMoveOrders_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SCMoveOrders_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCMoveOrders_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_SCMoveOrders_MoveOrderStatusID_SCMoveOrderStatusesMoveOrderStatusID->[dbo].[SCMoveOrderStatuses].[MoveOrderStatusID]
FK_SCMoveOrders_MoveOrderTypeID_SCMoveOrderTypesMoveOrderTypeID->[dbo].[SCMoveOrderTypes].[MoveOrderTypeID]
FK_SCMoveOrders_ReportID_SCReportsReportID->[dbo].[SCReports].[ReportID]
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