I’m trying to create a multi-tenancy system for my CRM system. Basically every company using the software uses the same tables (edited from typo “every company has their own sets of tables”). The tenants table itself should be normal, without any tenant discrimination.
I would like to separate the data using a TenantID Column.
The flow would be like that

I’m trying to create a multi-tenancy system for my CRM system. Basically every company using the software uses the same tables (edited from typo “every company has their own sets of tables”). The tenants table itself should be normal, without any tenant discrimination.
I would like to separate the data using a TenantID Column.
The flow would be like that