topic Something about activiti 5 database in Alfresco Forum

Something about activiti 5 database

leon007 — Sun, 01 Jan 2017 10:20:03 GMT

I want to explore database design in activiti 5. Today, I tried to draw a ER diagram via reverse engineering by ERmaster. Surprisingly, it results 26 isolated entities (corresponding to original tables), without any relationship. Is that the truth of the design, or it is my fault in revers engineer

Re: Something about activiti 5 database

gdharley — Tue, 03 Jan 2017 16:29:01 GMT

The schema is quite simple for Activiti Community Edition and the DDL can be found in the build here:
Activiti/modules/activiti-engine/src/main/resources/org/activiti/db/create at master · Activiti/Activiti · GitHub

The users guide also talks a little about the naming convention for the tables here:
Activiti User Guide - Database Table Names Explained

Hope this helps,

Greg

‌

Re: Something about activiti 5 database

leon007 — Wed, 04 Jan 2017 04:07:26 GMT

Hi, Greg,

Thanks for your valuable information. I'm going to have a look there.

Happy new year!

Leon

Prof. Liang ZHANG (Leon) Ph.D School of Computer Science Fudan University, Shanghai, 200433 China +86-21-65642219 Tel. +86-21-65642219 Fax +86-18930692817 Mobile. +86-13916354953 Mobile. lzhang@fudan.edu.cn email