0

Tenant and sub-tenant

Hello,

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?

Thanks.

Robert

1 reply

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    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

Login to reply

Content aside

  • 4 yrs agoLast active
  • 1Replies
  • 803Views