You’ve got a many to many relationship here (each student can have multiple lessons, and each lesson can be taken by many students). In general, there are two ways to handle many to many relationships:
- Keep a list (e.g. List of Lessons on the user)
- Create an “instance” item (e.g. A “User-Lesson” item that links a User and a Lesson)
In your case, it gets more complicated with the addition of the Course item. One way you could set it up that will work is:
-lessons: List of Lesson
-course: List of Course
-status: text or option set
-parent course: Course
Of course, this is just one way to do it. The best way to do it depends on your app, and takes into account things such as:
-How many lessons per course (in general)?
-How many courses per user (in general)?
-What are the most common things a user does? What is the data you need the user to see quickest?
-Is this a quick MVP (prioritize easier development) or a full-fledged app (prioritize user experience)
Hope this helps. If you need more help, feel free to reach out to us at our website. We offer data design as part of our services.
Stuck on your bubble app? Reach out to us at https://protomakr.bubbleapps.io/