Quiz-App

Quiz-App ERD

Tables (5)

bookmark

  • _id — ObjectId — Primary key — NOT NULL
  • userId — ObjectId — Foreign key → user._id — NOT NULL
  • unitId — ObjectId — Foreign key → unit._id — NOT NULL

folder

  • _id — ObjectID — Primary key — NOT NULL
  • title — String — NOT NULL
  • description — String
  • maker — ObjectId — Foreign key → user._id

review

  • _id — ObjectId — Primary key — NOT NULL
  • rate — Number — NOT NULL
  • userId — ObjectId — Foreign key → user._id — NOT NULL
  • unitId — ObjectId — Foreign key → unit._id — NOT NULL

unit

  • _id — ObjectId — Primary key — NOT NULL
  • title — String — NOT NULL
  • description — String
  • isPublic — String — NOT NULL
  • type — String — NOT NULL
  • words — Array
  • imageURL — String
  • folder — ObjectId — Foreign key → folder._id
  • maker — ObjectId — Foreign key → user._id

user

  • _id — String — Primary key — NOT NULL
  • email — String — NOT NULL
  • nickname — String — NOT NULL
  • password — String