权限菜单的设计

1. 资源表

 

 1.1  Resource

 ResourceID,  ResourceNamespace,  Description

 

 1.2 Category

 CategoryID, Name, ParentID, Description

 

 1.3  Module

 ModuleID, Name, Url, Description, CategoryID ,ResourceID

 

 

2. 用户表

  2.1 User

  UserID, LoginName, Email, Description

 

  2.2 App

  AppCode, ApplicationName, Description

 

  2.3 UserApp

  UserAppID, UserID , AppCode , Description

 

3.  权限表

  3.1 AppPermissionGroup

  AppPermissionGroupID,  PermissionGroupCode, AppCode,  Description

 

  3.2 AppPermission

  AppPermissionID, AppPermissionGroupID, ResourceID, AppCode,  CanView, CanChange, CanDelete, CanCreate, Description

 

4. 关系表

 

  4.1 UserPermissionGroupLink

  UserPermissionGroupLinkID, UserAppID, AppPermissionGroupID, Description