Multi-tenancy

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 or tenant_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.