Tables [dbo].[MTReadingRequestContacts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:24 AM Thursday, March 21, 2019
Last Modified1:12:44 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_MTReadingRequestContacts: MeterReadingRequestContactIDMeterReadingRequestContactIDint4
False
1 - 1
Indexes IX_MTReadingRequestContacts_MeterRequestIDForeign Keys FK_MTReadingRequestContacts_MeterRequestID_MTReadingRequests: [dbo].[MTReadingRequests].MeterRequestIDMeterRequestIDint4
False
Indexes IX_MTReadingRequestContacts_MeterRequestIDForeign Keys FK_MTReadingRequestContacts_ContactID_CMContacts: [dbo].[CMContacts].ContactIDContactIDint4
False
Indexes IX_MTReadingRequestContacts_MeterRequestIDForeign Keys FK_MTReadingRequestContacts_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
MethodValuevarchar(255)255
True
Successfulbit1
False
((0))
Indexes IX_MTReadingRequestContacts_AccessCodeAccessCodevarchar(50)50
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_MTReadingRequestContacts: MeterReadingRequestContactIDPK_MTReadingRequestContactsMeterReadingRequestContactID
True
80
IX_MTReadingRequestContacts_AccessCodeAccessCode
True
80
IX_MTReadingRequestContacts_MeterRequestIDMeterRequestID, ContactID, CustomerID
True
80
NameColumns
FK_MTReadingRequestContacts_ContactID_CMContactsContactID->[dbo].[CMContacts].[ContactID]
FK_MTReadingRequestContacts_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_MTReadingRequestContacts_MeterRequestID_MTReadingRequestsMeterRequestID->[dbo].[MTReadingRequests].[MeterRequestID]
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