Tables [dbo].[SHCOEquipmentMoveDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:57 AM Thursday, March 21, 2019
Last Modified1:15:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SHCOEquipmentMoveDetails: EquipmentMoveDetailIDEquipmentMoveDetailIDint4
False
1 - 1
Indexes IX_SHCOEquipmentMoveDetails_ChangeOrderIDForeign Keys FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHChangeOrders: [dbo].[SHChangeOrders].ChangeOrderIDForeign Keys FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHCOEquipmentMoveDetails: [dbo].[SHCOEquipmentMoveDetails].ChangeOrderID\ConjugateLinkedDetailIDChangeOrderIDint4
False
Indexes IX_SHCOEquipmentMoveDetails_ChangeOrderIDDetailIDint4
False
Foreign Keys FK_SHCOEquipmentMoveDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Statuschar(32)32
False
Foreign Keys FK_SHCOEquipmentMoveDetails_SrcLocationID_ARCustomers: [dbo].[ARCustomers].SrcLocationIDSrcLocationIDint4
False
SrcLocationRemarksvarchar(128)128
True
Foreign Keys FK_SHCOEquipmentMoveDetails_DestLocationID_ARCustomers: [dbo].[ARCustomers].DestLocationIDDestLocationIDint4
False
DestLocationRemarksvarchar(128)128
True
Foreign Keys FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHCOEquipmentMoveDetails: [dbo].[SHCOEquipmentMoveDetails].ChangeOrderID\ConjugateLinkedDetailIDConjugateLinkedDetailIDint4
True
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
False
LastUpdatedatetime8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SHCOEquipmentMoveDetails: EquipmentMoveDetailIDPK_SHCOEquipmentMoveDetailsEquipmentMoveDetailID
True
80
IX_SHCOEquipmentMoveDetails_ChangeOrderIDChangeOrderID, DetailID
True
80
NameColumns
FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHChangeOrdersChangeOrderID->[dbo].[SHChangeOrders].[ChangeOrderID]
FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHCOEquipmentMoveDetailsChangeOrderID->[dbo].[SHCOEquipmentMoveDetails].[ChangeOrderID]
ConjugateLinkedDetailID->[dbo].[SHCOEquipmentMoveDetails].[DetailID]
FK_SHCOEquipmentMoveDetails_DestLocationID_ARCustomersDestLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SHCOEquipmentMoveDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SHCOEquipmentMoveDetails_SrcLocationID_ARCustomersSrcLocationID->[dbo].[ARCustomers].[CustomerID]
CREATE TABLE [dbo].[SHCOEquipmentMoveDetails]
(
[EquipmentMoveDetailID] [int] NOT NULL IDENTITY(1, 1),
[ChangeOrderID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[Status] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[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].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [PK_SHCOEquipmentMoveDetails] PRIMARY KEY CLUSTERED  ([EquipmentMoveDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [IX_SHCOEquipmentMoveDetails_ChangeOrderID] UNIQUE NONCLUSTERED  ([ChangeOrderID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHChangeOrders] FOREIGN KEY ([ChangeOrderID]) REFERENCES [dbo].[SHChangeOrders] ([ChangeOrderID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_ChangeOrderID_SHCOEquipmentMoveDetails] FOREIGN KEY ([ChangeOrderID], [ConjugateLinkedDetailID]) REFERENCES [dbo].[SHCOEquipmentMoveDetails] ([ChangeOrderID], [DetailID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_DestLocationID_ARCustomers] FOREIGN KEY ([DestLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SHCOEquipmentMoveDetails] ADD CONSTRAINT [FK_SHCOEquipmentMoveDetails_SrcLocationID_ARCustomers] FOREIGN KEY ([SrcLocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
  • [dbo].[v_SCExchangeEquipment]