ERD for User Permissions
UserManagement.Companies
Primary Key
Companies_ID
CompanyName
UserManagement.Users
Primary Key
Users_ID
Foreign Key
FullNames_ID
Foreign Key
Emails_ID
UserManagement.Roles
Primary Key
Roles_ID
RoleName
UserManagement.Permissions
Primary Key
Permissions_ID
PermissionName
UserManagement.Groups
Primary Key
Groups_ID
GroupName
UserManagement.RGroups
Primary Key
RGroups_ID
Foreign Key
Groups_ID
UserManagement.PGroups
Primary Key
PGroups_ID
Foreign Key
Groups_ID
UserManagement.PermissionGroups
Primary Key
PermissionGroups_ID
Foreign Key
Permissions_ID
Foreign Key
PGroups_ID
Description
UserManagement.RoleGroups
Primary Key
RoleGroups_ID
Foreign Key
Roles_ID
Foreign Key
RGroups_ID
UserManagement.RoleGroup_PermissionGroups
Primary Key
RoleGroup_PermissionGroups_ID
Foreign Key
RoleGroups_ID
Foreign Key
PermissionGroups_ID
EntryTime
UserManagement.Permission_DisplayNames
Primary Key
Permission_DisplayNames_ID
Foreign Key
Permissions_ID
Permission_DisplayName
UserManagement.Company_UserRoleGroups
Primary Key
Company_UserRoleGroups_ID
Foreign Key
Companies_ID
Foreign Key
Users_ID
Foreign Key
RoleGroups_ID