ProcessMaker Database Model

ProcessMaker can manage numerous workspaces at a time. Each workspace has 3 MySQL databases:

wf_<WORKSPACE-NAME>

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

For version 2.0 and earlier see the Entity-Relationship diagram of this database.

For version 2.0 and later download the new Entity-Relationship Diagram

rb_<WORKSPACE-NAME>

This database contains the information about users to maintain a Role-Based Access Control (RBAC) system in ProcessMaker.
See the Entity-Relationship diagram of this database.

rp_<WORKSPACE-NAME>

This database is designed to allow external applications to access data from ProcessMaker cases. Each Report Table creates a separate table in this database, which external databases can query. If ProcessMaker was installed with the Automatic Windows Installer before version 1.6-4260, then this database is named rp<WORKSPACE> (without the underscore in the name).

More Information

The default workspace created in ProcessMaker is called workflow, so its databases are named wf_workflow, rb_workflow and rp_workflow. If doing a manual install of ProcessMaker, the setup screen provides an option to rename these databases. See Consulting the ProcessMaker databases for more information about how to access these databases 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/rb_workflow/

/var/lib/mysql/rp_workflow/

/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\rb_workflow\

C:\Program Files\ProcessMaker\mysql\data\rp_workflow\

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