topic Re: activiti tables? in Alfresco Forum

activiti tables?

narendraprakash — Fri, 16 Aug 2019 02:50:57 GMT

I am new to activiti. is there any proper documentation about tables? what kind of data will go into tables?Thanks

Re: activiti tables?

abhinavmishra14 — Fri, 16 Aug 2019 12:17:23 GMT

Follow the activiti user guide: https://www.activiti.org/userguide/

DB Tables: https://www.activiti.org/userguide/#database.tables.explained

Re: activiti tables?

narendraprakash — Fri, 16 Aug 2019 12:55:50 GMT

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.

Re: activiti tables?

paul_roth — Fri, 16 Aug 2019 13:49:11 GMT

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.

Re: activiti tables?

nhhao1996 — Mon, 19 Aug 2019 04:22:03 GMT

Any document more details than this sir? There are some properties in many tables I don't understand what is it?

Re: activiti tables?

paul_roth — Mon, 19 Aug 2019 04:56:51 GMT

What are you trying to do and perhaps somebody in the community can answer a specific question.

Re: activiti tables?

nhhao1996 — Tue, 20 Aug 2019 03:18:05 GMT

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?

Re: activiti tables?

abbask01 — Tue, 20 Aug 2019 10:28:57 GMT

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

Re: activiti tables?

guinetik — Thu, 30 Jun 2022 20:54:46 GMT

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!