Tables [dbo].[MTReadingRequestContactMeters]
PropertyValue
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 NullsDefault
Cluster Primary Key PK_MTReadingRequestContactMeters: MeterReadingRequestContactID\MeterIDForeign Keys FK_MTReadingRequestContactMeters_MeterReadingRequestContactID_MTReadingRequestContacts: [dbo].[MTReadingRequestContacts].MeterReadingRequestContactIDMeterReadingRequestContactIDint4
False
Cluster Primary Key PK_MTReadingRequestContactMeters: MeterReadingRequestContactID\MeterIDForeign Keys FK_MTReadingRequestContactMeters_MeterID_MTMeters: [dbo].[MTMeters].MeterIDMeterIDint4
False
Foreign Keys FK_MTReadingRequestContactMeters_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
False
MeterDueDatedatetime8
True
LastReadingRequestDatedatetime8
True
LastMeterDisplaydecimal(18,6)9
True
LastMeterActualdecimal(18,6)9
True
OverLimitbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_MTReadingRequestContactMeters: MeterReadingRequestContactID\MeterIDPK_MTReadingRequestContactMetersMeterReadingRequestContactID, MeterID
True
80
NameColumns
FK_MTReadingRequestContactMeters_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_MTReadingRequestContactMeters_MeterID_MTMetersMeterID->[dbo].[MTMeters].[MeterID]
FK_MTReadingRequestContactMeters_MeterReadingRequestContactID_MTReadingRequestContactsMeterReadingRequestContactID->[dbo].[MTReadingRequestContacts].[MeterReadingRequestContactID]
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