CREATE TABLE [dbo].[ModelDrill]
(
[ModelDrillID] [uniqueidentifier] NOT NULL,
[ModelID] [uniqueidentifier] NOT NULL,
[ReportID] [uniqueidentifier] NOT NULL,
[ModelItemID] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[Type] [tinyint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ModelDrill] ADD CONSTRAINT [PK_ModelDrill] PRIMARY KEY NONCLUSTERED ([ModelDrillID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_ModelDrillModelID] ON [dbo].[ModelDrill] ([ModelID], [ReportID], [ModelDrillID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ModelDrill] WITH NOCHECK ADD CONSTRAINT [FK_ModelDrillModel] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[Catalog] ([ItemID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ModelDrill] WITH NOCHECK ADD CONSTRAINT [FK_ModelDrillReport] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[Catalog] ([ItemID])
GO
GRANT REFERENCES ON  [dbo].[ModelDrill] TO [RSExecRole]
GRANT SELECT ON  [dbo].[ModelDrill] TO [RSExecRole]
GRANT INSERT ON  [dbo].[ModelDrill] TO [RSExecRole]
GRANT DELETE ON  [dbo].[ModelDrill] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[ModelDrill] TO [RSExecRole]
GO