.

Generated using SQL Data Dictionary demo version.

Table dbo.DesktopModulePermission (29 rows)

	Column	Data Type	Identity	Nullable	Default
PK	DesktopModulePermissionID	int	X
UK , FK	PortalDesktopModuleID	int
UK , FK	PermissionID	int
	AllowAccess	bit
UK , FK	RoleID	int		X
UK , FK	UserID	int		X
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_DesktopModulePermission
- (Primary Key)
- (Clustered)
- DesktopModulePermissionID

IX_DesktopModulePermission_DesktopModules
- (Unique)
- PortalDesktopModuleID
- PermissionID
- RoleID
- UserID
- AllowAccess (Included)

IX_DesktopModulePermission_Roles
- (Unique)
- RoleID
- PortalDesktopModuleID
- PermissionID
- AllowAccess (Included)

IX_DesktopModulePermission_Users
- (Unique)
- UserID
- PortalDesktopModuleID
- PermissionID
- AllowAccess (Included)

References:

dbo.Permission
- PermissionID
dbo.PortalDesktopModules
- PortalDesktopModuleID
dbo.Roles
- RoleID
dbo.Users
- UserID

Used by:

Procedure
dbo.AddDesktopModulePermission
Procedure
dbo.DeleteDesktopModulePermission
Procedure
dbo.DeleteDesktopModulePermissionsByPortalDesktopModuleID
Procedure
dbo.DeleteDesktopModulePermissionsByUserID
Procedure
dbo.DeleteRole
Procedure
dbo.UpdateDesktopModulePermission
View
dbo.vw_DesktopModulePermissions