Persisting project teams

0

In a project management system we have the "Users" and "Projects" entities.

Iwouldliketoevolvethisbasicstructureintoastructurethatwouldinvolveteams.Example:Project1has3members.

Whatisthebestwaytomaintainthisstructure?Wasthis?Whereauserwouldcreatetheprojectandthencouldaddnewmemberstothestructure...

    
asked by anonymous 18.09.2018 / 04:46

1 answer

0

Only create the Papel entity and in the Usuarios_Projetos ed entity, replace the Papel field with papel_id .

Remove the Usuarios_id column from the Projetos entity.

As a good practice, I recommend leaving the column names in lowercase.

    
18.09.2018 / 17:26