1. After the execution of a process, a data is generated in the Act_hi_procinst table,3. Each node in a process produces a piece of data in the Act_hi_actinst table, such as when the following process is executed, the following three records are generated in the Act_hi_actinst table:
4. Act_hi_taskinst, this is only when there is a human task in a process, each human task node produces a record within that table. 5. act_hi_varinst, each variable in the detailed recording process is recorded here, including his name, type, how much the value is, when it was created, when it was updated, whether the variable passed in when the process started, or the field in the form. 6. Act_hi_detail, in my practice, the variables set in the form will be recorded here, but the variables passed through Startprocessinstancebykey when the process starts are not recorded, and there is no rule. The feeling of this watch is a bit strange, do not know what is the use of concrete.
These tables, only act_hi_detail feel more strange, do not know what use, others are OK.
From for notes (Wiz)
Activiti Series: Relationships between several historical data tables