CREATE TABLE [dbo].[MTReadingRequestContactMeters]
(
[MeterReadingRequestContactID] [int] NOT NULL,
[MeterID] [int] NOT NULL,
[LocationID] [int] NOT NULL,
[MeterDueDate] [datetime] NULL,
[LastReadingRequestDate] [datetime] NULL,
[LastMeterDisplay] [decimal] (18, 6) NULL,
[LastMeterActual] [decimal] (18, 6) NULL,
[OverLimit] [bit] NOT NULL CONSTRAINT [DF_MTReadingRequestContactMeters_OverLimit] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContactMeters] ADD CONSTRAINT [PK_MTReadingRequestContactMeters] PRIMARY KEY CLUSTERED ([MeterReadingRequestContactID], [MeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContactMeters] ADD CONSTRAINT [FK_MTReadingRequestContactMeters_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[MTReadingRequestContactMeters] ADD CONSTRAINT [FK_MTReadingRequestContactMeters_MeterID_MTMeters] FOREIGN KEY ([MeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO
ALTER TABLE [dbo].[MTReadingRequestContactMeters] ADD CONSTRAINT [FK_MTReadingRequestContactMeters_MeterReadingRequestContactID_MTReadingRequestContacts] FOREIGN KEY ([MeterReadingRequestContactID]) REFERENCES [dbo].[MTReadingRequestContacts] ([MeterReadingRequestContactID])
GO