Tables [dbo].[Meters]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:25 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_Meters_MetersID: MetersIDMetersIDint4
False
1 - 1
Foreign Keys FK_Meters_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
False
Foreign Keys FK_Meters_MeterSubmissionID_MeterSubmission_MeterSubmissionID: [dbo].[MeterSubmission].MeterSubmissionIDMeterSubmissionIDint4
False
StartTotalint4
True
StartMonoint4
True
StartColorint4
True
EndTotalint4
True
EndMonoint4
True
EndColorint4
True
UserSubmittedFieldsvarchar(32)32
False
ServiceCopiesint4
True
Notesvarchar(255)255
True
SaveDatedatetime8
True
Stateint4
False
InAuditbit1
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Meters_MetersID: MetersIDPK_Meters_MetersIDMetersID
True
NameDeleteColumns
FK_Meters_DeviceID_Device_DeviceIDCascadeDeviceID->[dbo].[Device].[DeviceID]
FK_Meters_MeterSubmissionID_MeterSubmission_MeterSubmissionIDMeterSubmissionID->[dbo].[MeterSubmission].[MeterSubmissionID]
CREATE TABLE [dbo].[Meters]
(
[MetersID] [int] NOT NULL IDENTITY(1, 1),
[DeviceID] [int] NOT NULL,
[MeterSubmissionID] [int] NOT NULL,
[StartTotal] [int] NULL,
[StartMono] [int] NULL,
[StartColor] [int] NULL,
[EndTotal] [int] NULL,
[EndMono] [int] NULL,
[EndColor] [int] NULL,
[UserSubmittedFields] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ServiceCopies] [int] NULL,
[Notes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SaveDate] [datetime] NULL,
[State] [int] NOT NULL,
[InAudit] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Meters] ADD CONSTRAINT [PK_Meters_MetersID] PRIMARY KEY CLUSTERED  ([MetersID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Meters] ADD CONSTRAINT [FK_Meters_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Meters] ADD CONSTRAINT [FK_Meters_MeterSubmissionID_MeterSubmission_MeterSubmissionID] FOREIGN KEY ([MeterSubmissionID]) REFERENCES [dbo].[MeterSubmission] ([MeterSubmissionID])
GO