Multi Tenancy

Hi everyone,

I want to create a tenancy system with several panels:

App Panel (Central Application)
Student Panel (For Student Login)
Teacher Panel (For Teacher Login)
Parent Panel (For Parent Login)
For the tenancy model, I am using the School model, where both students and parents can be associated with more than one school. I’ve included a screenshot of the database relationship diagram.

My problem is figuring out how to link the logged-in user (student, parent, etc.) to their respective school based on the relationships in the tables I have.
image.png
Was this page helpful?