0
In a project management system we have the entities "Users" and "Projects".
I would like to evolve this basic structure into a structure that has teams. Example: Project 1 has 3 members.
What is the best way to persist with this structure? Is this ? Where a user would create the project and then add new members to the structure...
0
Just create the entity Papel and in the entity Usuarios_Projetos replace the field Papel for papel_id.
Remove the column Usuarios_id of the entity Projetos.
As good practice, I recommend leaving the name of the columns in lower case.
Browser other questions tagged php mysql database orm
You are not signed in. Login or sign up in order to post.
this model seems good to me. it’s simple, if you think that Users - Projects is a relationship
n:norn:m, basically a link table like the Users_projects solves– Ricardo Pontual