I'm trying to create a flexible datamodel and i'm not sure what's the right approach.
My application is used by several clients (big and small). Big clients need all the seperate layers, but small clients only need a few. Here's what i mean:
So 'company' and 'users' are always used, but the other ones 'rayons', 'locations' and 'departments' are used depending of the size of the client.
My first thought
I could use stubs to fill the tables for small clients. So they have one hidden 'rayon', 'location' and 'department'. But i get the feeling there is a better solution then this.
So if you have any insight, hint or suggestion; it is all appreciated!
And a final thought: What to do, when i want to add a layer 'country'? I don't see how this is gonna be an easy implementation right now.