CREATE TABLE [dbo].[SCEquipmentProfileHistory]
(
[EquipmentProfileHistoryID] [int] NOT NULL IDENTITY(1, 1),
[EquipmentHistoryID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ItemID] [int] NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SerialNumberID] [int] NULL,
[SerialNumberIDLocked] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_SerialNumberIDLocked] DEFAULT ((0)),
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[BillCodeID] [int] NULL,
[ResponseTime] [int] NOT NULL,
[LocationID] [int] NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OfficeOpen] [datetime] NULL,
[OfficeClose] [datetime] NULL,
[InstallDate] [datetime] NULL,
[Contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContactPhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContactFax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DecisionMaker] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DecisionMakerPhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DecisionMakerFax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TerritoryID] [int] NOT NULL,
[TechnicianID] [int] NOT NULL,
[WarrantyDate] [datetime] NULL,
[WarrantyMeter] [int] NULL,
[PMMeterInterval] [int] NULL,
[PMMeterDue] [int] NULL,
[PMDateInterval] [int] NULL,
[PMDateDue] [datetime] NULL,
[PMUseMeter] [bit] NOT NULL,
[PMUseDate] [bit] NOT NULL,
[StatusID] [int] NULL,
[ConditionID] [int] NULL,
[CurrentStatusHistoryID] [int] NULL,
[UnReviewed] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_UnReviewed] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[ParentID] [int] NULL,
[Hosting] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_Hosting] DEFAULT ((0)),
[Attached] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_Attached] DEFAULT ((0)),
[BinID] [int] NULL,
[FillerRecordOnly] [bit] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_FillerRecordOnly] DEFAULT ((0)),
[ModelID] [int] NOT NULL,
[IsMetered] [bit] NOT NULL,
[DefaultMeterID] [int] NULL,
[RequireMeteronServiceCalls] [bit] NOT NULL,
[ShTrackingConfigID] [int] NULL,
[MostRecentDefaultMeterReadingID] [int] NULL,
[MostRecentDefaultMeterReadingDisplay] [decimal] (18, 6) NULL,
[MostRecentDefaultMeterReadingDate] [datetime] NULL,
[MostRecentHostDefaultMeterReadingID] [int] NULL,
[MostRecentHostDefaultMeterReadingDisplay] [decimal] (18, 6) NULL,
[MostRecentHostDefaultMeterReadingDate] [datetime] NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCEquipmentProfileHistory_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [PK_SCEquipmentProfileHistory] PRIMARY KEY CLUSTERED ([EquipmentProfileHistoryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] WITH NOCHECK ADD CONSTRAINT [FK_SCEquipmentProfileHistory_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_ConditionID_SCEquipmentConditions] FOREIGN KEY ([ConditionID]) REFERENCES [dbo].[SCEquipmentConditions] ([SCEquipmentConditionID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_CurrentStatusHistoryID_SCEquipmentHistory] FOREIGN KEY ([CurrentStatusHistoryID]) REFERENCES [dbo].[SCEquipmentHistory] ([SCEquipmentHistoryID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] WITH NOCHECK ADD CONSTRAINT [FK_SCEquipmentProfileHistory_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_DefaultMeterID_MTMeters] FOREIGN KEY ([DefaultMeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_EquipmentHistoryID_SCEquipmentHistory] FOREIGN KEY ([EquipmentHistoryID]) REFERENCES [dbo].[SCEquipmentHistory] ([SCEquipmentHistoryID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] WITH NOCHECK ADD CONSTRAINT [FK_SCEquipmentProfileHistory_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_MostRecentDefaultMeterReadingID_MTMeterReadings] FOREIGN KEY ([MostRecentDefaultMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_MostRecentHostDefaultMeterReadingID_MTMeterReadings] FOREIGN KEY ([MostRecentHostDefaultMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_SerialNumberID_ICSerialNumbers] FOREIGN KEY ([SerialNumberID]) REFERENCES [dbo].[ICSerialNumbers] ([LookUpID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_StatusID_ShEntryTypes] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[ShEntryTypes] ([ShEntryTypeID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[SCEquipmentProfileHistory] ADD CONSTRAINT [FK_SCEquipmentProfileHistory_TerritoryID_SCTerritories] FOREIGN KEY ([TerritoryID]) REFERENCES [dbo].[SCTerritories] ([TerritoryID])
GO