I’m having a hard time working out what my database structure and workflow should be to achieve what I am trying. Hoping somebody smarter than me can point me in the right direction.
In my app a user can create a list of different Tasks, which are standard for their account.
Then, they can create new Events. Each Event should have all of the Tasks associated with it, so that for each Event you can mark off each Task, and not who completed the Task on what date.
I have a Table with Events and a table with Tasks. I’m not sure what to do to get the two associated. My first thought was to have another table, like Event_Tasks, where Tasks and Events are associated and then I can add date completed and who did so. I’m not sure how I would generate each Task/Event combo though. Via an API?
Or is there a better way?