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
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
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
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