I am making a Phonegap based ERP solution for school in which every school can configure their own school individually and can manage the whole school from that single application, in which a main administrator configures the school,i.e., adds all the subjects, teachers, classes, timetables, result, etc.
The application also has roles for students, teachers, parents, and admins in which the admin can define the permissions that all the different roles have plus can add and delete the permissions as well.
The application manages the attendance, time table, results, profile of all the students and staff as well.
I can think of only two ways of doing the same,
- To maintain a column of school_id in every table that i create and in all the queries that i make i specify the school_id with it.
- To create a different database for every school that registers in the application so that all the school data is not in the same table and the single table is not over populated.
I just cant make out with what design I shall go forward with.
Thanks in advance.