Need help designing a database

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:

  1. show the user his next not watched lesson from a specific course
  2. list of finished lessons


If this is your first time, just star with simple collections, and then begin to add relationship between collections


Don’t be afraid of making it wrong. Just start with baby steps.

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.