CREATE TABLE [dbo].[MTModelMeters]
(
[ModelMeterID] [int] NOT NULL IDENTITY(1, 1),
[ModelID] [int] NOT NULL,
[MeterTypeID] [int] NOT NULL,
[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterDigits] [int] NOT NULL CONSTRAINT [DF_MTModelMeters_MeterDigits] DEFAULT ((0)),
[RequireReading] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_RequireReading] DEFAULT ((0)),
[WarrantyClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTModelMeters_WarrantyClicks] DEFAULT ((0)),
[DoPMByClicks] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_DoPMByClicks] DEFAULT ((0)),
[PMIntervalClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTModelMeters_PMIntervalClicks] DEFAULT ((0)),
[PMDueClicks] [decimal] (18, 6) NULL CONSTRAINT [DF_MTModelMeters_PMDueClicks] DEFAULT ((0)),
[MeterFormula] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_IsDefault] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_Active] DEFAULT ((1)),
[AvgMonthlyVolume3Mo] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_AvgMonthlyVolume3Mo] DEFAULT ((0)),
[AvgMonthlyVolume6Mo] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_AvgMonthlyVolume6Mo] DEFAULT ((0)),
[AvgMonthlyVolume12Mo] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_AvgMonthlyVolume12Mo] DEFAULT ((0)),
[AvgMonthlyVolumeInstall] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_AvgMonthlyVolumeInstall] DEFAULT ((0)),
[MfgSuggestedMonthlyVolume] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_MfgSuggestedMonthlyVolume] DEFAULT ((0)),
[TargetMonthlyVolume] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_MTModelMeters_TargetMonthlyVolume] DEFAULT ((0)),
[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_MTModelMeters_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_MTModelMeters_UpdateDate] DEFAULT (getdate()),
[IncludeInMeterRequests] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_IncludeInMeterRequests] DEFAULT ((1)),
[InterfaceName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SequentialMeter] [bit] NOT NULL CONSTRAINT [DF_MTModelMeters_SequentialMeter] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTModelMeters] ADD CONSTRAINT [PK_MTModelMeters] PRIMARY KEY CLUSTERED ([ModelMeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTModelMeters] ADD CONSTRAINT [FK_MTModelMeters_MeterTypeID_MTMeterTypes] FOREIGN KEY ([MeterTypeID]) REFERENCES [dbo].[MTMeterTypes] ([MeterTypeID])
GO
ALTER TABLE [dbo].[MTModelMeters] ADD CONSTRAINT [FK_MTModelMeters_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO