CREATE TABLE [dbo].[MTMeters]
(
[MeterID] [int] NOT NULL IDENTITY(1, 1),
[EquipmentID] [int] NOT NULL,
[MeterTypeID] [int] NOT NULL,
[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterDigits] [int] NOT NULL CONSTRAINT [DF_MTMeters_MeterDigits] DEFAULT ((0)),
[RequireReading] [bit] NOT NULL CONSTRAINT [DF_MTMeters_RequireReading] DEFAULT ((0)),
[WarrantyClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTMeters_WarrantyClicks] DEFAULT ((0)),
[DoPMByClicks] [bit] NOT NULL CONSTRAINT [DF_MTMeters_DoPMByClicks] DEFAULT ((0)),
[PMIntervalClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTMeters_PMIntervalClicks] DEFAULT ((0)),
[PMDueClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTMeters_PMDueClicks] DEFAULT ((0)),
[MeterFormula] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_MTMeters_IsDefault] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_MTMeters_Active] DEFAULT ((1)),
[AvgMonthlyVolume3Mo] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_MTMeters_AvgMonthlyVolume3Mo] DEFAULT ((0)),
[AvgMonthlyVolume6Mo] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_MTMeters_AvgMonthlyVolume6Mo] DEFAULT ((0)),
[AvgMonthlyVolume12Mo] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_MTMeters_AvgMonthlyVolume12Mo] DEFAULT ((0)),
[AvgMonthlyVolumeInstall] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_MTMeters_AvgMonthlyVolumeInstall] DEFAULT ((0)),
[MfgSuggestedMonthlyVolume] [decimal] (18, 6) NULL CONSTRAINT [DF_MTMeters_MfgSuggestedMonthlyVolume] DEFAULT ((0)),
[TargetMonthlyVolume] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_MTMeters_TargetMonthlyVolume] DEFAULT ((0)),
[MostRecentMeterReadingID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_MTMeters_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_MTMeters_UpdateDate] DEFAULT (getdate()),
[IncludeInMeterRequests] [bit] NOT NULL CONSTRAINT [DF_MTMeters_IncludeInMeterRequests] DEFAULT ((1)),
[InterfaceName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SequentialMeter] [bit] NOT NULL CONSTRAINT [DF_MTMeters_SequentialMeter] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTMeters] ADD CONSTRAINT [PK_MTMeters] PRIMARY KEY CLUSTERED ([MeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTMeters] ADD CONSTRAINT [FK_MTMeters_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[MTMeters] ADD CONSTRAINT [FK_MTMeters_MeterTypeID_MTMeterTypes] FOREIGN KEY ([MeterTypeID]) REFERENCES [dbo].[MTMeterTypes] ([MeterTypeID])
GO
ALTER TABLE [dbo].[MTMeters] ADD CONSTRAINT [FK_MTMeters_MostRecentMeterReadingID_MTMeterReadings] FOREIGN KEY ([MostRecentMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO