for multi-tenancy users(=customers) there are 3 main solutions, 1) Single DB with a) dedicated table per user or b) shared table with column that identify the

for multi-tenancy users(=customers) there are 3 main solutions, 1) Single DB with a) dedicated table per user or b) shared table with column that identify the user 2) Dedicated Schema for every user. 3) Dedicated DB for every users. there is no good answers and you'll find everyone have solved it differently as they scale... few biggest names i can think of my haed are SalesForce, Workday and ServiceNow