ProcessMaker Database Model
From ProcessMaker
Contents |
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.
See the Entity-Relationship diagram of this database.
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. (Windows versions of ProcessMaker call this database 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.
If Windows installations, these databases are stored at: <INSTALL-DIRECTORY>\apps\processmaker\shared\workflow_data\sites\<WORKSPACE-NAME>\
For example: C:\Program Files\ProcessMaker\apps\processmaker\shared\workflow_data\sites\<WORKSPACE-NAME>\
In Linux/UNIX, they are found at: <INSTALL-DIRECTORY>/shared/sites/<WORKSPACE-NAME>/
For example: /opt/processmaker/shared/sites/<WORKSPACE-NAME>/
