Tables [dbo].[SCEquipmentHistory]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:21 AM Thursday, March 21, 2019
Last Modified1:15:05 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCEquipmentHistory: SCEquipmentHistoryIDSCEquipmentHistoryIDint4
False
1 - 1
Foreign Keys FK_SCEquipmentHistory_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Foreign Keys FK_SCEquipmentHistory_StatusID_ShEntryTypes: [dbo].[ShEntryTypes].StatusIDStatusIDint4
True
Foreign Keys FK_SCEquipmentHistory_ConditionID_SCEquipmentConditions: [dbo].[SCEquipmentConditions].ConditionIDConditionIDint4
True
Foreign Keys FK_SCEquipmentHistory_ShTrackingValueGroupID_ShTrackingValueGroups: [dbo].[ShTrackingValueGroups].ShTrackingValueGroupIDShTrackingValueGroupIDint4
False
Manualbit1
False
((0))
Datedatetime8
False
Periodint4
True
Referencevarchar(255)255
False
TransactionTypeIDint4
False
SubReferencevarchar(255)255
True
CreatorIDvarchar(8)8
False
UpdatorIDvarchar(8)8
False
CreateDatedatetime8
False
UpdateDatedatetime8
False
Remarksvarchar(255)255
True
Descriptionvarchar(255)255
True
ReferenceIDint4
True
Notesvarchar(255)255
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCEquipmentHistory: SCEquipmentHistoryIDPK_SCEquipmentHistorySCEquipmentHistoryID
True
80
NameColumns
FK_SCEquipmentHistory_ConditionID_SCEquipmentConditionsConditionID->[dbo].[SCEquipmentConditions].[SCEquipmentConditionID]
FK_SCEquipmentHistory_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCEquipmentHistory_ShTrackingValueGroupID_ShTrackingValueGroupsShTrackingValueGroupID->[dbo].[ShTrackingValueGroups].[ShTrackingValueGroupID]
FK_SCEquipmentHistory_StatusID_ShEntryTypesStatusID->[dbo].[ShEntryTypes].[ShEntryTypeID]
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