CREATE TABLE [dbo].[SCEquipmentHistory]
(
[SCEquipmentHistoryID] [int] NOT NULL IDENTITY(1, 1),
[EquipmentID] [int] NOT NULL,
[StatusID] [int] NULL,
[ConditionID] [int] NULL,
[ShTrackingValueGroupID] [int] NOT NULL,
[Manual] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentHistory_Manual] DEFAULT ((0)),
[Date] [datetime] NOT NULL,
[Period] [int] NULL,
[Reference] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionTypeID] [int] NOT NULL,
[SubReference] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdateDate] [datetime] NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReferenceID] [int] NULL,
[Notes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCEquipmentHistory] ADD CONSTRAINT [PK_SCEquipmentHistory] PRIMARY KEY CLUSTERED ([SCEquipmentHistoryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCEquipmentHistory] ADD CONSTRAINT [FK_SCEquipmentHistory_ConditionID_SCEquipmentConditions] FOREIGN KEY ([ConditionID]) REFERENCES [dbo].[SCEquipmentConditions] ([SCEquipmentConditionID])
GO
ALTER TABLE [dbo].[SCEquipmentHistory] ADD CONSTRAINT [FK_SCEquipmentHistory_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCEquipmentHistory] ADD CONSTRAINT [FK_SCEquipmentHistory_ShTrackingValueGroupID_ShTrackingValueGroups] FOREIGN KEY ([ShTrackingValueGroupID]) REFERENCES [dbo].[ShTrackingValueGroups] ([ShTrackingValueGroupID])
GO
ALTER TABLE [dbo].[SCEquipmentHistory] ADD CONSTRAINT [FK_SCEquipmentHistory_StatusID_ShEntryTypes] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[ShEntryTypes] ([ShEntryTypeID])
GO