Tables [dbo].[ReportSettings_UserPermissions]
PropertyValue
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:26 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsID: ReportSettingsID\UserPermissionsIDForeign Keys FK_ReportSettings_UserPermissions_ReportSettingsID_ReportSettings_ID: [dbo].[ReportSettings].ReportSettingsIDReportSettingsIDint4
False
Cluster Primary Key PK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsID: ReportSettingsID\UserPermissionsIDForeign Keys FK_ReportSettings_UserPermissions_UserPermissionsID_UserPermissions_UserPermissionsID: [dbo].[UserPermissions].UserPermissionsIDUserPermissionsIDint4
False
OrderIndexint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsID: ReportSettingsID\UserPermissionsIDPK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsIDReportSettingsID, UserPermissionsID
True
NameUpdateDeleteColumns
FK_ReportSettings_UserPermissions_ReportSettingsID_ReportSettings_IDCascadeCascadeReportSettingsID->[dbo].[ReportSettings].[ID]
FK_ReportSettings_UserPermissions_UserPermissionsID_UserPermissions_UserPermissionsIDUserPermissionsID->[dbo].[UserPermissions].[UserPermissionsID]
CREATE TABLE [dbo].[ReportSettings_UserPermissions]
(
[ReportSettingsID] [int] NOT NULL,
[UserPermissionsID] [int] NOT NULL,
[OrderIndex] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [PK_ReportSettings_UserPermissions_ReportSettingsID_UserPermissionsID] PRIMARY KEY CLUSTERED  ([ReportSettingsID], [UserPermissionsID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [FK_ReportSettings_UserPermissions_ReportSettingsID_ReportSettings_ID] FOREIGN KEY ([ReportSettingsID]) REFERENCES [dbo].[ReportSettings] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ReportSettings_UserPermissions] ADD CONSTRAINT [FK_ReportSettings_UserPermissions_UserPermissionsID_UserPermissions_UserPermissionsID] FOREIGN KEY ([UserPermissionsID]) REFERENCES [dbo].[UserPermissions] ([UserPermissionsID])
GO