# Database schema for flowable apps

**URL:** <https://forum.flowable.org/t/database-schema-for-flowable-apps/6173>\
**Category:** Flowable Application\
**Created:** [June 9, 2020, 6:46am UTC](https://forum.flowable.org/t/database-schema-for-flowable-apps/6173 "2020-06-09T06:46:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prashant](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/prashant/32/1820_2.png) [@prashant](https://forum.flowable.org/u/prashant)\
**Post date:** [June 9, 2020, 6:46am UTC](https://forum.flowable.org/t/database-schema-for-flowable-apps/6173/1 "2020-06-09T06:46:05Z")

</div>

Flowable has the multiple application - modeler, task, rest, admin and idm.

Is there any guideline for creating schema for all apps? Should they share common schema or they should have their own individual schema?

What is the best approach?

How it will affect multi tenancy ( Share engine/ Multi Schema) . When we say multi schema, which app should have tenant specific schema?

As from [Flowable multi tenancy for all apps](https://forum.flowable.org/t/flowable-multi-tenancy-for-all-apps/6054), only engines are multi tenant enabled(whiich is part of flowable-task and flowable-rest)

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [June 11, 2020, 5:43pm UTC](https://forum.flowable.org/t/database-schema-for-flowable-apps/6173/2 "2020-06-11T17:43:52Z")

</div>

Correct, the UI apps are not multi-tenant enabled.

> [@prashant](#):
>
> Is there any guideline for creating schema for all apps?

rest and task should point to the same datasource if you want to have them work on the same data. All the rest can be in another schema.

---

<div class="post-metadata">

**Author:** ![slangeberg](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/slangeberg/32/1801_2.png) [@slangeberg](https://forum.flowable.org/u/slangeberg)\
**Post date:** [June 16, 2020, 3:25pm UTC](https://forum.flowable.org/t/database-schema-for-flowable-apps/6173/3 "2020-06-16T15:25:47Z")

</div>

@joram is there any ability to send tenantId along request from flowable-admin / other ui apps? Or when you say it is “not multi-tenant enabled” - it has not been implemented at all?

Thanks!

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [June 28, 2020, 9:10am UTC](https://forum.flowable.org/t/database-schema-for-flowable-apps/6173/4 "2020-06-28T09:10:59Z")

</div>

> [@slangeberg](#):
>
> it has not been implemented at all?

Indeed.

There is this PR open [OIDC SSO authentication by tomvda · Pull Request #2281 · flowable/flowable-engine · GitHub](https://github.com/flowable/flowable-engine/pull/2281) (will be worked on soon to get merged) which adds some tenancy capabilities, but right now the UI apps are not multi-tenant.