I have a table of resources in the database, every user can mark if he finished the resource or not
How can I arrange the database so that in the application every user will see the resource as done/not done specifically for them
One way is to use list fields on the user (one for ‘started resources’, and another for 'completed resources), to record which resources they have started and completed.
Another way (almost certainly a better way) is to create a new datatype to connect a User to a specific resource, and record on that when the User has started it, when they’ve completed it, and any other data you need about that particular user and that specific resource.
Yeah I’ll create a junction table, thanks a lot
1 Like