建模平台用户组织角色项目相关表ER图
2021-12-06 09:36:43 8 举报111111111111111111111111111
作者其他创作
大纲/内容
UserGUID = UserId
myuserrightadjust(用户权限调整表)
myUserRightAdjustGUID：主键UserGUIDStandardRoleGUIDActionCodeObjectTypeApplication
myStandardRoleId = StandardRoleGUID
myGlobalRoleId = myGlobalRoleId
UserGUID = UserGUID
p_project(项目表)
p_projectId：主键BUGUIDCityGUIDCountyGUIDLevelParentGUIDProjCodeProjName
RoleId = myStandardRoleId
UserID = UserGUID
myStandardRoleId = RoleId
ProjectId = p_projectId
MyUserProjectMapping(用户项目表)
myUserProjectMappingId：主键UserIdProjectId
myBusinessUnit(组织表)
BUGUID：主键BUNameBUFullNameBUCodeBUTypeCompanyGUIDParentGUIDIsCompanyLevel
myuserproject2role(用户项目角色关系表)
myUserProject2RoleId：主键ProjectIdRoleIDUserId
mystandardroleright(标准角色功能权限表)
myStandardRoleRightId：主键StandardRoleGUIDActionCodeApplicationObjectType
BUGUID=BUGUID
BUGUID = BUId
myuserbuprojectright(用户公司项目权限表)
MyUserBUProjectRightId：主键UserIdBUId
myuser(用户表)
UserGUID：主键UserNameUserKindUserCodeOrderNumberIsOldUserBUGUID
myuserbusinessunitmapping(用户组织关系表)
myUserBusinessUnitMappingId：主键UserIdBUGUID
myglobalrole2role(通用角色与角色关系表)
myGlobalRole2RoleId：主键myGlobalRoleIdRoleId
RoleID = myStandardRoleId
myuser2role(用户角色关系表)
MyUser2RoleId：主键OrganizationIDUserIDRoleIDRefType
BUGUID = BUGUID
mystandardrole(标准角色表)
myStandardRoleId：主键BUGUIDParentGUIDLevelMyStandardRoleTypeIdStandardRoleCodeStandardRoleName
myglobalrole(通用角色表)
myGlobalRoleId：主键GlobalRoleName
收藏
0 条评论
下一页
