CREATE TABLE [dbo].[MeterSubmission]
(
[MeterSubmissionID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[CreateDate] [datetime] NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[SubmissionDate] [datetime] NULL,
[SubmitContactID] [int] NULL,
[ApproveDate] [datetime] NULL,
[ApproveContactID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MeterSubmission] ADD CONSTRAINT [PK_MeterSubmission_MeterSubmissionID] PRIMARY KEY CLUSTERED ([MeterSubmissionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MeterSubmission] ADD CONSTRAINT [FK_MeterSubmission_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MeterSubmission] ADD CONSTRAINT [FK_MeterSubmission_ApproveContactID_Contact_ContactID] FOREIGN KEY ([ApproveContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[MeterSubmission] ADD CONSTRAINT [FK_MeterSubmission_SubmitContactID_Contact_ContactID] FOREIGN KEY ([SubmitContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO