建模平台用户组织角色项目相关表ER图

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