1
*
Company
+ id:long PK+ sysGroupId:long FK
Operator
+ id:long PK+ companyId:long FK
UserRoles
SysMenuFunction
+ id:long PK+ sysMenuId:long FK
Unique Index:sysMenuId+functionName
UserRolePermission
+ id:long PK+ userRoleId:long FK+ sysMenuFunctionId:long FK
Unique Index:sysMenuFunctionId+userRoleId
sysGroup
+ id:long PK+ groupCode:string+ defaultUserCode:string+ groupName:string+ apiUrl:string
SysMenu
+ id:long PK
Unique Index:menuName+parentId
SysOperatorRoles
+ id:long PK+ operatorId:long FK+ userRoleId:long FK
Unique Index:userRoleId+operatorId