Kentico CMS 7.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 users:

 

CMS_User - contains records representing users.

CMS_UserSite - stores relationships between users and sites. Each entry indicates that a specific user account is available on a given site.

CMS_UserRole - stores relationships between users and roles. Each entry indicates that a specific role is assigned to a given user. This table is also used to store the expiration date for roles that are assigned for a limited time period.

CMS_UserCulture - stores relationships between users and content cultures. Each entry indicates that a user may edit the content of documents belonging to a specified culture/language (if the given user is an editor).

CMS_UserSettings - stores the advanced settings of users.

 

devguide_clip1668

 

The following tables store information about roles and permissions:

 

CMS_Role - contains records representing roles.

CMS_Permission - stores permissions.

CMS_RolePermission - stores relationships between roles and permissions. Each entry indicates that a permission is granted to a given role.

CMS_RoleUIElement - stores relationships between roles and UI elements. Each entry indicates that a specified UI element will be displayed to members of a given role.

 

devguide_clip1669