I'm planning a site using cakephp and this site will be used to manage projects.
I need some ideas to design the database, especially the relations and teams that will be part of each project.
The vertical entities are:
- Zone Manager
- Local Manager
- Project Manager
The transversal entities will be:
Each project will be seen vertically by the Managers that have people in each team.
The Consultant A will part of project A and B and Consultant B will be part of project C and D, etc. The Assistants will work in a Pool, so like Consultants they will be part of a team assigned to a project.
Using the best practices what is the best way to associate entities to a team and to each project?