CREATE TABLE [dbo].[ModelPerspective]
(
[ID] [uniqueidentifier] NOT NULL,
[ModelID] [uniqueidentifier] NOT NULL,
[PerspectiveID] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[PerspectiveName] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[PerspectiveDescription] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_ModelPerspective] ON [dbo].[ModelPerspective] ([ModelID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ModelPerspective] WITH NOCHECK ADD CONSTRAINT [FK_ModelPerspectiveModel] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[Catalog] ([ItemID]) ON DELETE CASCADE
GO
GRANT REFERENCES ON  [dbo].[ModelPerspective] TO [RSExecRole]
GRANT SELECT ON  [dbo].[ModelPerspective] TO [RSExecRole]
GRANT INSERT ON  [dbo].[ModelPerspective] TO [RSExecRole]
GRANT DELETE ON  [dbo].[ModelPerspective] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[ModelPerspective] TO [RSExecRole]
GO