Java Activiti (3)--Database description

Activiti background is supported by the database, and all tables begin with Act_. The second section is a two-letter identifier that represents the purpose of the table. The purpose also corresponds to the API of the service.

1)  act_re_*: ' RE ' means repository. This prefix table contains the process definition and process static resources (pictures, rules, and so on).
2)  act_ru_*: ' RU ' means runtime. These run-time tables, including process instances, tasks, variables, asynchronous tasks, and so on run the data. Activiti saves the data only during process instance execution and deletes the records at the end of the process. This way the runtime table can always be very small and fast.
3)  act_id_*: ' ID ' indicates identity. These tables contain identity information, such as users, groups, and so on.
4)  act_hi_*: ' HI ' means history. These tables contain historical data, such as historical process instances, variables, tasks, and so on.
5)  Act_ge_*: Universal data, for different scenarios.

1. Resource pool process rules table

1)  act_re_deployment   Deployment Information Table
2)  Act_re_model    Process Design Model Deployment Table
3)  Act_re_procdef      Process Definition data table

2, run-time database table

1  act_ru_execution    run-time Process Execution Instance table
2)  Act_ru_identitylink runtime process personnel table, primary storage task node and participant information
3  act_ru_task     run-time Task node table
4  act_ru_variable run-time process variables Datasheet

3, Historical database table

1)  Act_hi_actinst History      node Table
2)  act_hi_attachment       Historical Annex Table
3)  act_hi_comment      historical Opinion form
4)  Act_hi_identitylink     History Flow Staff table
5)  act_hi_detail           Historical Details table, providing historical variables query
6)  Act_hi_procinst     Historical Process Example Table
7  act_hi_taskinst     History Task Table
8)  act_hi_varinst      history Variable Table

4. Organization Chart

1)  act_id_group        user Group Information table
2  act_id_info     user extended Information Table
3)  act_id_membership   User and user group corresponding information table
4  act_id_user     User Information table

These four tables are very common, basic organization management, on the user authentication suggestion or own development set, the function of the component is too simple, the use of a lot of demand is difficult to meet
5. General data Table

1  act_ge_bytearray        binary data Table
2) The  Act_ge_property     property Datasheet stores the entire process engine level of data, and when the table structure is initialized, three records are inserted by default.

————————————————————————————————————————————————— – Java Architect Project Combat, high concurrency cluster distributed, large data high availability video tutorials, total 760G

Download Address:

https://item.taobao.com/item.htm?id=555888526201

01. High-level architect 42 Phases
02.Java Advanced System Training Architecture Course 148 hours
03.Java Senior Internet Architect Course
04.Java Internet Architecture Netty, Nio, Mina, etc.-Video tutorials
05.Java Advanced Architecture Design 2016 finishing-video tutorials
06. Architect Foundation, advanced film
07.Java Architect Required Linux Operation series courses
08.Java Advanced System Training Architecture Course 116 hours
+
Hadoop series tutorials, Java design patterns and data structures, Spring Cloud Micro service, Springboot Primer

—————————————————————————————————————————————————–