Thanks. We'll think about the schema based separation.

FKs: But how do you ensure data integrity? We need to have an existing user in the field, cause it is data shown...

Thanks

Few things:

Our data model has about 100 tables. 10 or so are general lookups which could be shared in a "each tenant has its own schema" design. That means 90...

It doesn't need to be part but when the tenant_id is included in the primary key (or an unique index) and every foreign key shares the same tenant_id field, there's...