Tables [dbo].[MeterSubmission]
PropertyValue
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_MeterSubmission_MeterSubmissionID: MeterSubmissionIDMeterSubmissionIDint4
False
1 - 1
Foreign Keys FK_MeterSubmission_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
CreateDatedatetime8
True
StartDatedatetime8
True
EndDatedatetime8
True
SubmissionDatedatetime8
True
Foreign Keys FK_MeterSubmission_SubmitContactID_Contact_ContactID: [dbo].[Contact].SubmitContactIDSubmitContactIDint4
True
ApproveDatedatetime8
True
Foreign Keys FK_MeterSubmission_ApproveContactID_Contact_ContactID: [dbo].[Contact].ApproveContactIDApproveContactIDint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_MeterSubmission_MeterSubmissionID: MeterSubmissionIDPK_MeterSubmission_MeterSubmissionIDMeterSubmissionID
True
NameDeleteColumns
FK_MeterSubmission_AccountID_Account_AccountIDCascadeAccountID->[dbo].[Account].[AccountID]
FK_MeterSubmission_ApproveContactID_Contact_ContactIDApproveContactID->[dbo].[Contact].[ContactID]
FK_MeterSubmission_SubmitContactID_Contact_ContactIDSubmitContactID->[dbo].[Contact].[ContactID]
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