3.0 - ProcessMaker Database Model
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
No votes yet
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.
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.
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:
The location depends upon your distribution, but it is generally:
If installed with the ProcessMaker Windows Installer, the MySQL files are generally stored at:
If installed with the manual installation, the MySQL files are generally stored at:
C:\ProgramData\MySQL\MySQL Server 5.1\data\wf_workflow\
Download Our App
Automate your Workflow with Business Process Management
Software licensed under the GNU Affero General Public License version 3
Contact us: firstname.lastname@example.org
© Copyright 2000-2018 ProcessMaker Inc. All rights reserved.