JUNGLE_PROJECT2_CLONE

Tables (6)

categories

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

courses

  • id — INT — Primary key — NOT NULL
  • instructor_id — INT — Foreign key → users.id — NOT NULL
  • category_id — INT — Foreign key → categories.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • created_at — DATETIME

enrollments

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • course_id — INT — Foreign key → courses.id — NOT NULL
  • enrolled_at — DATETIME

reviews

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • course_id — INT — Foreign key → courses.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME

users

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255)
  • created_at — DATETIME

wishlists

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • course_id — INT — Foreign key → courses.id — NOT NULL
  • created_at — DATETIME