Tables [dbo].[SCMoveOrderDetails]
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 NullsIdentityDefault
Cluster Primary Key PK_SCMoveOrderDetails: MoveOrderDetailIDMoveOrderDetailIDint4
False
1 - 1
Indexes IX_SCMoveOrderDetails_MoveOrderIDForeign Keys FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrderDetails: [dbo].[SCMoveOrderDetails].MoveOrderID\ConjugateLinkedDetailIDForeign Keys FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrders: [dbo].[SCMoveOrders].MoveOrderIDMoveOrderIDint4
False
Indexes IX_SCMoveOrderDetails_MoveOrderIDDetailIDint4
False
Foreign Keys FK_SCMoveOrderDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Quantityint4
False
Fulfilledint4
False
((0))
Cancelledint4
False
((0))
Foreign Keys FK_SCMoveOrderDetails_SrcLocationID_ARCustomers: [dbo].[ARCustomers].SrcLocationIDSrcLocationIDint4
False
SrcLocationRemarksvarchar(128)128
True
Foreign Keys FK_SCMoveOrderDetails_DestLocationID_ARCustomers: [dbo].[ARCustomers].DestLocationIDDestLocationIDint4
False
DestLocationRemarksvarchar(128)128
True
Foreign Keys FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrderDetails: [dbo].[SCMoveOrderDetails].MoveOrderID\ConjugateLinkedDetailIDConjugateLinkedDetailIDint4
True
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
False
LastUpdatedatetime8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCMoveOrderDetails: MoveOrderDetailIDPK_SCMoveOrderDetailsMoveOrderDetailID
True
80
IX_SCMoveOrderDetails_MoveOrderIDMoveOrderID, DetailID
True
80
NameColumns
FK_SCMoveOrderDetails_DestLocationID_ARCustomersDestLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCMoveOrderDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrderDetailsMoveOrderID->[dbo].[SCMoveOrderDetails].[MoveOrderID]
ConjugateLinkedDetailID->[dbo].[SCMoveOrderDetails].[DetailID]
FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrdersMoveOrderID->[dbo].[SCMoveOrders].[MoveOrderID]
FK_SCMoveOrderDetails_SrcLocationID_ARCustomersSrcLocationID->[dbo].[ARCustomers].[CustomerID]
CREATE TABLE [dbo].[SCMoveOrderDetails]
(
[MoveOrderDetailID] [int] NOT NULL IDENTITY(1, 1),
[MoveOrderID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[Quantity] [int] NOT NULL,
[Fulfilled] [int] NOT NULL CONSTRAINT [DF_SCMoveOrderDetails_Fulfilled] DEFAULT ((0)),
[Cancelled] [int] NOT NULL CONSTRAINT [DF_SCMoveOrderDetails_Cancelled] DEFAULT ((0)),
[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].[SCMoveOrderDetails] ADD CONSTRAINT [PK_SCMoveOrderDetails] PRIMARY KEY CLUSTERED  ([MoveOrderDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [IX_SCMoveOrderDetails_MoveOrderID] UNIQUE NONCLUSTERED  ([MoveOrderID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_DestLocationID_ARCustomers] FOREIGN KEY ([DestLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrderDetails] FOREIGN KEY ([MoveOrderID], [ConjugateLinkedDetailID]) REFERENCES [dbo].[SCMoveOrderDetails] ([MoveOrderID], [DetailID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_MoveOrderID_SCMoveOrders] FOREIGN KEY ([MoveOrderID]) REFERENCES [dbo].[SCMoveOrders] ([MoveOrderID])
GO
ALTER TABLE [dbo].[SCMoveOrderDetails] ADD CONSTRAINT [FK_SCMoveOrderDetails_SrcLocationID_ARCustomers] FOREIGN KEY ([SrcLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO