I am building an app where users can take courses on various topics. Each course consists of lessons. Each lesson can have status “New”, “Finished”, “Skipped”
How should I design a database to keep each lesson status for each user?
I want to be able to:
- show the user his next not watched lesson from a specific course
- list of finished lessons