Question : In my application, several times I have to show results that are paginated and sorted by some field. […]
Tag: multi-tenant
Composite Primary Key in multi-tenant SQL Server database
Question : I’m building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure […]
Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?
Question : I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of […]
How can I Run stored procedures in public schema to provision and create tables in a new schema
Question : I’m building a multi tenant application with shared database and different schemas(each customer has its isolated data in […]
Is this schema usable for multi-tenant clients?How to remove multi-cascade paths?
Question : I am newbie to database design. I want to build multi-tenant application that will have the following schema […]
Multi-tenant database constraints
Question : I have a multi-tenant app in PostgreSQL that has a repeated tenant_id column in each table to help […]
Composite Primary Key column order
Question : How would you do the ordering of the PK columns in this case (Oracle 11gR2 Standard Edition): I […]
Most efficient table structure for multi-tenant database
Question : I have a conventional relational database (mySQL) with several entities stored in their own table. Three examples are […]
Multiple schema or multiple databases for better performance [closed]
Question : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]
copy data from public schema to another schema in postgresql
Question : I’m creating a multi-tenant RoR app using PostgreSQL 9.3.5 running on linux (Ubuntu 14). I’d like to copy […]