-2

I need help creating a project system to which I can add a few people. What database structure should I create to assign several people to the project?

My database

users
 id 
 name
 surname

project
 id 
 name
 desc
 owner
 member 
fejmintv
  • 31
  • 7

2 Answers2

-1

With a relational database :

users
 id 
 name
 surname

project
 id 
 name
 desc
 owner
 member  // Do not store projects users here

Create an join table

projects_members
 project_id 
 user_id
Steven
  • 313
  • 3
  • 10
-1

You have to use many-to-many relation in order to add many people to the project and to have many people in the project.

You need to add one more table

user_project
  user_id
  project_id

and delete column member from project table

Mike Foxtech
  • 1,633
  • 1
  • 6
  • 7