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