Default Tables

There are four tables that are essential for the system: config, admin, service, and subservice. They are created during the system installation. During the installation, the user, userprofile, userprofile_service, and userprofile_subservice tables are also added, although they can be deleted without affecting the system.

These tables have the following relationship:

config

This is a pseudo-module that contains system configuration and operation data.

service

Installed services, in this case services, admin, and user. Config, which is not a real module, is added here so that it can be accessed from the administrative console as if it were a real service.

subservice

Installed subservices, in this case subservice (dependent on service) and userprofile (dependent on user).

admin

System administrators. There will always be one, with the highest privileges to administer the system.

user

System users. Empty by default.

userprofile

User profiles. Empty by default.

userprofile_service

Service permissions per user profile. Empty by default.

userprofile_subservice

Subservice permissions per user profile. Empty by default.