Jiri Svitak [https://community.jboss.org/people/jsvitak] created the discussion "Re: Question regarding jbpm 5.4 schema" To view the discussion, visit: https://community.jboss.org/message/790456#790456 -------------------------------------------------------------- It's recommended to use different database schemas for process runtime and logging due to performance reasons. Because of this the schemas are separated. Of course you can use single database for non-production purposes, but to use the relation that you describe, you need to add foreign key manually. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/790456#790456] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Jiri Svitak [https://community.jboss.org/people/jsvitak] created the discussion "Re: Question regarding jbpm 5.4 schema" To view the discussion, visit: https://community.jboss.org/message/790465#790465 -------------------------------------------------------------- As explained before the main reason is to be possible to separate logging database schema and runtime database schema. If each would be tied together using foreign keys, it would not be possible to split them easily. My opinion is that sometimes it's necessary to update database schema manually. For example some databases don't create indexes by default, you need to add them manually, if you need them. You have to try it in your scenario if foreign key adding won't damage anything. I think that it should not. FYI I am not a jBPM developer, so I cannot guarantee that :) -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/790465#790465] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]