CREATE TABLE [dbo].[MTMeterReadings]
(
[MeterReadingID] [int] NOT NULL IDENTITY(1, 1),
[MeterReadingGroupID] [int] NOT NULL,
[MeterID] [int] NOT NULL,
[Display] [decimal] (18, 6) NULL,
[Actual] [decimal] (18, 6) NULL,
[Credits] [decimal] (18, 6) NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsValidForBilling] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_IsValidForBilling] DEFAULT ((0)),
[IsEstimate] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_IsEstimate] DEFAULT ((0)),
[IsOverEstimate] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_IsOverEstimate] DEFAULT ((0)),
[IsRollOver] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_IsRollOver] DEFAULT ((0)),
[IsValid] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_IsValid] DEFAULT ((1)),
[WasRequired] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_WasRequired] DEFAULT ((0)),
[OverriddenByID] [int] NULL,
[WasReset] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_WasReset] DEFAULT ((0)),
[ResetValue] [decimal] (18, 6) NULL CONSTRAINT [DF_MTMeterReadings_ResetValue] DEFAULT ((0)),
[NewlyPosted] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_NewlyPosted] DEFAULT ((1)),
[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_MTMeterReadings_CreateDate] DEFAULT (getdate()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF_MTMeterReadings_UpdateDate] DEFAULT (getdate()),
[WasUsedForBilling] [bit] NOT NULL CONSTRAINT [DF_MTMeterReadings_WasUsedForBilling] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTMeterReadings] ADD CONSTRAINT [PK_MTMeterReadings] PRIMARY KEY CLUSTERED ([MeterReadingID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTMeterReadings] ADD CONSTRAINT [FK_MTMeterReadings_MeterID_MTMeters] FOREIGN KEY ([MeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO
ALTER TABLE [dbo].[MTMeterReadings] ADD CONSTRAINT [FK_MTMeterReadings_MeterReadingGroupID_MTMeterReadingGroups] FOREIGN KEY ([MeterReadingGroupID]) REFERENCES [dbo].[MTMeterReadingGroups] ([MeterReadingGroupID])
GO
ALTER TABLE [dbo].[MTMeterReadings] ADD CONSTRAINT [FK_MTMeterReadings_OverriddenByID_MTMeterReadings] FOREIGN KEY ([OverriddenByID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO