Activiti Getting Started--easy to read database

Related articles :

"The most authoritative Activiti Framework study guide in History"

Introduction to Activiti-environment building and core API

In Activiti, there are 5 additional sheets on the basis of the predecessor JBPM, and the framework provides 23 tables by default. Today this chapter to share with you about the ACTIVITI database structure-related knowledge.

Database

Activiti's background is supported by the database, and all tables start with act_. The second part is a two-letter identifier that represents the purpose of the table. The use also corresponds to the API of the service;

Act_ge_*: General data for storing uploaded file information and database version information;

act_re_*: ' RE ' represents repository. The table of this prefix contains the process definition and process static resources (pictures, rules, etc.);

act_ru_*: ' RU ' indicates runtime. These run-time tables contain process instances, tasks, variables, asynchronous tasks, and other running data;

Activiti only saves this data during the process instance execution and deletes the records at the end of the process. This way the run-time table can always be very small and fast;

act_id_*: ' ID ' denotes identity. These tables contain identity information, such as users, groups, and so on;

act_hi_*: ' HI ' means history. These tables contain historical data, such as historical process instances, variables, tasks, and so on.

General Data Sheet

1) Act_ge_bytearray binary data sheet;

2) The Act_ge_property Property data table stores the entire process engine level of data, and when the table structure is initialized, three records are inserted by default;

Resource pool Process Rules table

1) Act_re_deployment Deployment Information Sheet

2) Act_re_model process Design Model Deployment table

3) ACT_RE_PROCDEF Process definition Data Sheet

Run-time database tables

1) act_ru_execution run-time Process Execution Instance table

2) Act_ru_identitylink run-time Process staff table, which mainly stores information about task nodes and participants

3) Act_ru_task Run-Time Task node table

4) act_ru_variable run-time process variable data table

Historical database Tables

1) Act_hi_actinst History node table

2) Act_hi_attachment History attachment Table

3) Act_hi_comment History Opinion Table

4) Act_hi_identitylink History process Personnel table

5) Act_hi_detail History Detail table, provide historical variable query

6) Act_hi_procinst History Process Example Table

7) Act_hi_taskinst History task Instance table

8) Act_hi_varinst Historical variables table

Organization Chart

1) Act_id_group User Group Information sheet

2) Act_id_info User extension Information table

3) act_id_membership user and user group corresponding information table

4) Act_id_user User Information Form

These five tables are very common, the basic organizational management, about the user certification recommendations or self-developed a set of components, the function is too simple, the actual application of a lot of requirements are difficult to meet.

Activiti Getting Started--easy to read database