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.
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 12 months ago