Business processes historical data operational database

🌐 This document is available in both English and Ukrainian. Use the language toggle in the top right corner to switch between versions.

1. Overview

The process_history database provides long-term storage for the execution history of business process instances and user tasks.

2. Database schema

process_history-schema
Legend
Diagram notation Table notation Meaning

ο and [PK]

(PK)

Primary key

[FK]

(references table.column)

Foreign key

●

column name in bold

Required field (not null)

column name in regular font

Optional field (null)

A table relationship is not established intentionally because, as a result of denormalization, they contain the entire set of attributes necessary for serving historical queries and are filled with data independently of each other.

3. Data structures

3.1. bpm_history_process

Provides storage for business processes history.

Column name
Description

process_instance_id text (PK)
Business process instance ID.

super_process_instance_id text
Business process parent instance ID.

process_definition_id text
Business process current version ID.

process_definition_key text
A unique ID for all versions of a business process.

process_definition_name text
Business process name.

business_key text
Domain-specific process instance ID.

start_time timestamp without time zone
Business process start time.

end_time timestamp without time zone
Business process end time.

start_user_id text
The ID of the user who initiated the business process.

state text
Business process state.

  • ACTIVE

  • COMPLETED

excerpt_id text
Excerpt ID for business processes that generate excerpts.

completion_result text
A text message with business process execution result.

3.2. bpm_history_task

Provides storage for tasks history.

Column name
Description

activity_instance_id text (PK)
Row ID.

task_definition_key text
Unique task ID.

task_definition_name text
Task name.

process_instance_id text
The ID of the business process instance to which the task belongs.

process_definition_id text
Business process current version ID.

process_definition_key text
A unique ID for all versions of a business process.

process_definition_name text
Business process name.

root_process_instance_id text
Business process root instance ID.

start_time timestamp without time zone
The time the task instance was created and became available for execution.

end_time timestamp without time zone
Task end time.

assignee text
ID of the user to whom the task was assigned.