Tenant and sub-tenant


I have a trooble for modelization a schema. In fact i have a table tenant and in this table i have record that is sub-tenant.

But how can recognize the record tenant or sub-tenant?

I thinking for create a table externe of my table tenant and make a relation m-n

It's right way? Any suggestion?



Ninox Profile

Hi Robert, 

That depends if a sub-tenant can have more than one tenants and also a tenant can have more than one sub-tenants. Then a M : N relationship is right. 

If a sub-tenant can have only one tenant then a N : 1 relationship would be sufficient.

Kind regards, Jörg