(ii) Introduction of the--activiti database table of Activiti

Source: Internet
Author: User
Tags naming convention

1. Naming the database tables

The Activiti 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_re_*: ' RE ' means repository . The table for this prefix contains the process definition and process static resources (pictures, rules, etc.).
    • act_ru_*: ' RU ' means 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 ' indicates 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.
    • Act_ge_*: 通用 data for different scenarios.
    • Other: Act_evt_log and Act_procdef_info did not follow the rules, and the two belonged to Hi and re respectively.

In activiti5.21, the Activiti data contains 25 tables, with 23 tables named after the naming convention, such as: Picture source

There are also two tables: Act_evt_log and Act_procdef_info do not follow the rules, and they belong to hi and re respectively.

2. database table Structure 2.1 act_re_ (Process definition table)

Act_re_deployment (Deployment)

Act_re_model (model)

ACT_RE_PROCDEF (Process definition)

2.2 Act_ru_ (running instance table)

ACT_RU_EVENT_SUBSCR (Event subscription)

Act_ru_execution (executive) Act_ru_identitylink (participant)

Act_ru_job (Asynchronous Job)

Act_ru_task (Task)

Act_ru_variable (variable)

2.3 Act_hi_ (Process history)

Act_hi_actinst (link historical information) act_hi_attachment (annex) act_hi_comment (comment)

Act_hi_detail (historical details) Act_hi_identitylink (participant history) Act_hi_procinst (process instance history) Act_hi_taskinst (Task History)

Act_hi_varinst (Variable history)

2.4 Act_ge_ (normal data)

Act_ge_bytearray (binary content table) all binary content is stored in this table, such as deployed Process.bpmn20.xml, Process.png, User.form, attachments, and beans serialized into binary process variables.

Act_ge_property (Global parameter table) global parameters, default three parameters next.dbid,idgenerator interval, schema.history, automatic execution of SQL history, schema.version, current SQL version.

2.5 act_id_ (User User Group table) act_id_group (group) act_id_info (user details)

Act_id_membership (user group relationship) act_id_user (user basic information)

2.6 Other Act_evt_log (Event log table) is not turned on by default

Act_procdef_info (Process definition update information)

(ii) Introduction of the--activiti database table of Activiti

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.