Correct Nesting Databases Structure?

Hi I would appreciate any insight (to my noob-ish) question

I am trying to make the databases for a company project manager, it is Project / Tasks / Sub-Steps

I have to nest the sub-steps under a task, and a group of tasks under a given project, but I also need to assign more than one user to the project/task.

How should I go about configuring the database structure-wise?

Any help or insight will be appreciated, thanks.

@digitalexperiencemg

User
Name (text)

Project
Title (text)
Users (list of users)

Task
Title (text)
Project (project)
User (user)

Sub-task
Title (text)
Task (task)
User (user)

3 Likes