Kentico CMS 6.0 Developer's Guide

Database tables

Database tables

Previous topic Next topic Mail us feedback on this topic!  

Database tables

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

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.

 

devguide_clip1653

 

 

 

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.