|
|
Database tables |
|
|
|
|
|
Database tables |
|
|
|
|
|
|
Database tables |
|
|
|
|
|
Database tables |
|
|
|
|
|
|
||
The following database tables are used to store information about groups:
•Community_Group - contains records representing groups and their settings.
•Community_GroupMember - stores relationships between groups and users and other group membership data.
•Community_GroupRolePermission - stores relationships between groups and roles as well as a permission type. Each entry in this table indicates that users belonging to the given role have the specified permission for a group.
•Community_Invitation - stores invitations for group membership.
|
Group role storage
Group roles are stored along with standard roles in the CMS_Role table. Records representing group roles have a value in their RoleGroupID field that is equal to the ID of the group that they belong under, while standard roles have it set to NULL. |
