activiti tables?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-15-2019 10:50 PM
I am new to activiti. is there any proper documentation about tables? what kind of data will go into tables?
Thanks
- Labels:
-
Alfresco Process Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2019 08:17 AM
Follow the activiti user guide: https://www.activiti.org/userguide/
DB Tables: https://www.activiti.org/userguide/#database.tables.explained
(ACSCE, AWS SAA, Azure Admin)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2019 08:55 AM
Hi Abhinav,
Thanks for your reply. But i want to understand details about each table which i could not found in document.
I am looking for that kind of details.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-16-2019 09:49 AM
naga mandavilli‌
Section 3.1 explains what each of the Activiti tables is used for e.g. what kind of data goes into each table.
3.7. Database table names explained
The database names of Activiti all start with ACT_. The second part is a two-character identification of the use case of the table. This use case will also roughly match the service API.
ACT_RE_*: RE stands for
repository
. Tables with this prefix contain static information such as process definitions and process resources (images, rules, etc.).ACT_RU_*: RU stands for
runtime
. These are the runtime tables that contain the runtime data of process instances, user tasks, variables, jobs, etc. Activiti only stores the runtime data during process instance execution, and removes the records when a process instance ends. This keeps the runtime tables small and fast.ACT_ID_*: ID stands for
identity
. These tables contain identity information, such as users, groups, etc.ACT_HI_*: HI stands for
history
. These are the tables that contain historic data, such as past process instances, variables, tasks, etc.ACT_GE_*:
general
data, which is used in various use cases.
Perhaps if you describe the use case that you are trying develop that may better explain what you are looking for if the above explanation is not enough.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2019 12:22 AM
Any document more details than this sir? There are some properties in many tables I don't understand what is it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2019 12:56 AM
What are you trying to do and perhaps somebody in the community can answer a specific question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-19-2019 11:18 PM
I created a question months ago but no one answer. I just want to understand the database more clearly. There are some properties like TENANT_ID, REV_, I can't understand what is it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2019 06:28 AM
Once you are familiar with basic engine concepts like process definitions, instances, tasks, etc. and how the data flows, the tables names and columns will become self-explanatory. refer the create script for db definition
TENANT_ID is used when you run engine in multi-tenancy. each tenant will have their own set of process definitions.
REV_ is for revisions
Abbas

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-30-2022 04:54 PM
Dude i was looking for these schema files for ages so i created an account, verified email, completed a boat captcha challenge just to say....Thanks!
