I am developing a SaaS application and I am looking for the best way to develop lookup tables, given:
- Search tables will have predefined data distributed among all tenants
- Each tenant must have the ability to expand the lookup table with his own data, for example, with the addition of a car, the class is not defined
I am going to add a TenantID column for each search and add predefined data by setting this column to some value, which is a “Super Tenant” owned by the system
source
share