CREATE TABLE [dbo].[MTReadingRequestContacts]
(
[MeterReadingRequestContactID] [int] NOT NULL IDENTITY(1, 1),
[MeterRequestID] [int] NOT NULL,
[ContactID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[MethodValue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Successful] [bit] NOT NULL CONSTRAINT [DF_MTReadingRequestContacts_Successful] DEFAULT ((0)),
[AccessCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [PK_MTReadingRequestContacts] PRIMARY KEY CLUSTERED ([MeterReadingRequestContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [IX_MTReadingRequestContacts_AccessCode] UNIQUE NONCLUSTERED ([AccessCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [IX_MTReadingRequestContacts_MeterRequestID] UNIQUE NONCLUSTERED ([MeterRequestID], [ContactID], [CustomerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [FK_MTReadingRequestContacts_ContactID_CMContacts] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [FK_MTReadingRequestContacts_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[MTReadingRequestContacts] ADD CONSTRAINT [FK_MTReadingRequestContacts_MeterRequestID_MTReadingRequests] FOREIGN KEY ([MeterRequestID]) REFERENCES [dbo].[MTReadingRequests] ([MeterRequestID])
GO