Hey Xano Community!
I'm seeking the best practice for relating tasks and sub-tasks.
What is the best DB setup for tasks and sub-tasks?
Should I create one table for tasks and another for sub-tasks and use add-ons when calling tasks or is it better to create a column in the tasks table that stores sub-tasks as a list?
In general, what is the best practice for something like this? This makes me curious about how to handle multiple assignees for action items or a list of goals for a user.
I hope this makes sense -- Thank you for your help!