.

Generated using SQL Data Dictionary demo version.

Table dbo.Permission (14 rows)

	Column	Data Type	Identity	Nullable	Default
PK	PermissionID	int	X
UK	PermissionCode	varchar(50)
UK	ModuleDefID	int
UK	PermissionKey	varchar(50)
	PermissionName	varchar(50)
	ViewOrder	int			9999
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_Permission
- (Primary Key)
- (Clustered)
- PermissionID

IX_Permission
- (Unique)
- PermissionCode
- ModuleDefID
- PermissionKey

Referenced by:

dbo.ContentWorkflowStatePermission
- PermissionID
dbo.DesktopModulePermission
- PermissionID
dbo.FolderPermission
- PermissionID
dbo.ModulePermission
- PermissionID
dbo.TabPermission
- PermissionID

Used by:

Procedure
dbo.AddPermission
Procedure
dbo.DeleteDesktopModule
Procedure
dbo.DeleteModuleDefinition
Procedure
dbo.DeletePermission
Procedure
dbo.GetFoldersByPermissions
Procedure
dbo.GetPermissions
Procedure
dbo.UpdatePermission
View
dbo.vw_ContentWorkflowStatePermissions
View
dbo.vw_DesktopModulePermissions
View
dbo.vw_FolderPermissions
View
dbo.vw_ModulePermissions
View
dbo.vw_TabPermissions