Database Schema
The modeler requires a set of database tables to store diagrams, forms, and user sessions. The schema must exist before the webclient starts — the webclient connects to the database but never creates or modifies tables itself (ddl-auto: none).
Schema creation is the responsibility of the parent application (e.g. cibseven-bpm-run). Refer to the parent application’s documentation for the DDL scripts and migration tooling it provides.
Database Tables
| Table | Description |
|---|---|
mod_processes_diagrams |
Stores BPMN and DMN diagram metadata and the raw XML |
mod_forms |
Stores form schemas as JSON |
mod_user_sessions |
Tracks open editing sessions per user |
mod_diagram_usage |
Associates a user session with a specific diagram |
mod_form_usage |
Associates a user session with a specific form |
mod_element_templates |
Stores reusable element template definitions |
chat_messages |
Stores real-time chat messages per room (Enterprise Edition only) |
Enterprise Feature
The chat_messages table is only required when the enterprise edition is active and cibseven.webclient.modeler.enabled: true. It is not created in the community edition.
Supported Databases
Refer to Prerequisites for supported database versions.