DATABASEMODEL

3.0 - ProcessMaker Database Model

Version:

Please rate how useful you found this document:

Select ratingGive 3.0 - ProcessMaker Database Model 1/5Give 3.0 - ProcessMaker Database Model 2/5Give 3.0 - ProcessMaker Database Model 3/5Give 3.0 - ProcessMaker Database Model 4/5Give 3.0 - ProcessMaker Database Model 5/5

Give 3.0 - ProcessMaker Database Model 1/5

Give 3.0 - ProcessMaker Database Model 2/5

Give 3.0 - ProcessMaker Database Model 3/5

Give 3.0 - ProcessMaker Database Model 4/5

Give 3.0 - ProcessMaker Database Model 5/5

No votes yet

Contents: [hide]

Overview

ProcessMaker can manage numerous workspaces at a time. Each workspace has one MySQL database for each workspace in order to facilitate the use of ProcessMaker in hosted servers which limit the number of databases.

Note: If upgraded from a previous version, ProcessMaker 2.8 and later will continue to use 3 databases. For more information, please check out 2.0 ProcessMaker Database Model.

wf_<workspace-name>

This database contains all the information required by the Process Engine, including information about processes, cases, users, PM Tables, etc.

Tables with prefix RBAC added to their table names contain the information about users to maintain a Role-Based Access Control (RBAC) system in ProcessMaker.

RBAC_AUTHENTICATION_SOURCE, RBAC_PERMISSIONS, RBAC_ROLES, RBAC_ROLES_PERMISSIONS, RBAC_SYSTEMS, RBAC_USERS, RBAC_USERS_ROLES

The database also includes Report Tables designed to allow external applications to access data from ProcessMaker cases. Report Tables have the prefix PMT_ in their names. Each Report Table creates a separate table in this database, which external databases can query.

Click the images below to see the Entity-Relationship diagram of this database. The diagram is divided in three parts for better understanding.

More Information

The default workspace created in ProcessMaker is called workflow, so its database is named wf_workflow. If doing a manual installation of ProcessMaker, the setup screen provides an option to rename this database. See Consulting the ProcessMaker databases for more information about how to access this database with MySQL and phpMyAdmin.

The files for the MySQL databases are generally stored in the following locations:

Linux/UNIX:

The location depends upon your distribution, but it is generally:

/var/lib/mysql/<DATABASE-NAME>/

For example:

/var/lib/mysql/wf_workflow/

Windows:

If installed with the ProcessMaker Windows Installer, the MySQL files are generally stored at:

<INSTALL-DIRECTORY>\MySQL\data\<DATABASE-NAME>\

For example:

C:\Program Files\ProcessMaker\MySQL\data\wf_workflow\

If installed with the manual installation, the MySQL files are generally stored at: