LinkedIn
Twitter
Hello everyone,
Iโm making an app for 3 different customers, they all have languages centers. I have many tables: Languages, Groups, Teachers, Classrooms, Students, Parents, Attendances, โฆ etc
My first try: I made the app and itโs worked, and then I made 3 copies, one for each center, and then I thought if I will get more customers, do I need to make a copy each time ? and if I want to update the app, do I need to do it separately for each customer ? โฆ itโs not a good idea at all.
My second try which is more better than the first one: I have added a column โCenter IDโ in every single table of the app and added for each table โSecurity Filtersโ to filter the tables by โCenter IDโ so each customer sees only his data, and then I got scared when I saw this:
The question is: am I doing right with adding the column โCenter IDโ in every single table ? or there is a better way to do it to achieve the same result โevery customer sees only his dataโ.
I appreciate your help, thank you.
