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?
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