Multi-tenancy
Setting your multi-tenancy mode
What is multi-tenancy?
Multi-tenancy refers to the concept of storing data from multiple users of software (or tenants) in a single database. This data can be separated in a number of ways, with two common patterns.
- Multi-tenant tables where tenant data is commingled in a set of tables, with a column to indicate tenancy (e.g., via an
organization_id
ortenant_id
column). - Schema per tenant where each schema contains the data for a given tenant.
![Multi-tenant table tenanting vs. schema-based tenanting](https://files.readme.io/8df4abd-Table_Tenant_vs_Schema_Tenants.png)
Multi-tenant table tenanting vs. schema-based tenanting
How do I indicate my multi-tenancy mode?
By default, Prequel assumes data is tenanted via multi-tenant tables. Ask Prequel support to convert your account to schema per tenant mode if that's your preferred setting.
Updated 8 months ago