Lookups in Multi-Tenant Database

Posted by Huthaifa Afanah on Stack Overflow See other posts from Stack Overflow or by Huthaifa Afanah
Published on 2010-08-19T13:30:19Z Indexed on 2011/01/03 5:54 UTC
Read the original article Hit count: 147

Filed under:
|

I am developing a SaaS application and I am looking for the best way to design lookup tables, taking in consideration:

  • The look-up tables will have predefined data shared among all the tenants
  • Each tenant must have the ability to extend the look-up table with his own data e.g adding a car class not defined

I am thinking about adding TenantID column to each lookup and add the predefined data with setting that column to some value which represents the "Super Tenant" that belongs to the system itself

© Stack Overflow or respective owner

Related posts about database

Related posts about saas