CREATE TABLE [dbo].[RPReportObjects]
(
[ReportObjectID] [int] NOT NULL IDENTITY(1, 1),
[ReportObjectName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReportID] [int] NOT NULL,
[ObjectTypeID] [int] NOT NULL,
[ObjectID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportObjects] ADD CONSTRAINT [PK_RPReportObjects] PRIMARY KEY CLUSTERED ([ReportObjectID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportObjects] ADD CONSTRAINT [FK_RPReportObjects_ObjectTypeID_RPObjectTypes] FOREIGN KEY ([ObjectTypeID]) REFERENCES [dbo].[RPObjectTypes] ([ObjectTypeID])
GO
ALTER TABLE [dbo].[RPReportObjects] ADD CONSTRAINT [FK_RPReportObjects_ReportID_RPReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[RPReports] ([ReportID])
GO