I am looking for some advice on setting up a multi-user and multi-school website/application.
Each school and user will be created by a superuser; so there is no "self registration" functionality (at this point).
On the back-end, It is important that when user1 logs in he can only see and edit the school1 players.
On the font-end each school will have it's own url e.g. site.com/school1
Any hints would be much appreciated.
Users
user1 - school1
user2 - school1
user3 - school2
Pages
schools
school1
school2
players
football players
player1 - school1
player2 - school1
player3 - school2
cheerleaders
cheerleader1 - school1
cheerleader2 - school2
advertisments
advert1 - school1
advert2 - school2