CREATE TABLE [dbo].[ScheduledReportSettings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[ReportSettingsID] [int] NOT NULL,
[RecipientContactID] [int] NOT NULL,
[CreatedByContactID] [int] NOT NULL,
[CreationDate] [datetime] NOT NULL,
[LastRun] [datetime] NULL,
[Frequency] [tinyint] NOT NULL,
[RunTime] [tinyint] NOT NULL,
[ReportSettingsAccountID] [int] NULL,
[IncludeHierarchy] [bit] NOT NULL CONSTRAINT [DF_ScheduledReportSettings_IncludeHierarchy] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScheduledReportSettings] ADD CONSTRAINT [PK_ScheduledReportSettings_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScheduledReportSettings] ADD CONSTRAINT [FK_ScheduledReportSettings_CreatedByContactID_Contact_ContactID] FOREIGN KEY ([CreatedByContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[ScheduledReportSettings] ADD CONSTRAINT [FK_ScheduledReportSettings_RecipientContactID_Contact_ContactID] FOREIGN KEY ([RecipientContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[ScheduledReportSettings] ADD CONSTRAINT [FK_ScheduledReportSettings_ReportSettingsAccountID_Account_AccountID] FOREIGN KEY ([ReportSettingsAccountID]) REFERENCES [dbo].[Account] ([AccountID])
GO
ALTER TABLE [dbo].[ScheduledReportSettings] ADD CONSTRAINT [FK_ScheduledReportSettings_ReportSettingsID_ReportSettings_ID] FOREIGN KEY ([ReportSettingsID]) REFERENCES [dbo].[ReportSettings] ([ID]) ON DELETE CASCADE
GO