Learning Notes on Flowable
In Flowable, all database tables are prefixed with ACT_.
ACT_RE_*: The “RE” stands for Repository, & these tables store static data, such as process definitions, process resources (e.g., images, rule files), & other persistent information.
ACT_RU_*: The “RU” stands for Runtime, & these tables store dynamic data that is only relevant during the execution of a process instance, such as process instances, user tasks, variables, & jobs.
Flowable retains runtime data only while a process instance is active & automatically purges the records once the instance is completed. This design ensures that the runtime tables remain small & efficient.