2

Tables (10)

course

  • course_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — TEXT — NOT NULL

course_description

  • id (course_description_id) — NUMBER — Primary key — NOT NULL
  • course_id — NUMBER — Foreign key → course.course_id — NOT NULL
  • content — TEXT — NOT NULL

description_author

  • id (description_author_id) — NUMBER — Primary key — NOT NULL
  • id (course_description_id) — NUMBER — Foreign key → course_description.id — NOT NULL
  • author_type — ENUM('INSTRUCTOR','MANAGER) — NOT NULL
  • author_id (authod_id) — NUMBER — NOT NULL

enrollment

  • id (enrollment_id) — NUMBER — Primary key — NOT NULL
  • course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
  • id (student_id) — NUMBER — Foreign key → student.id — NOT NULL — UNIQUE
  • enrolled_at — TIMESTAMP — NOT NULL

instructor

  • id (instructor_id) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL — UNIQUE

manager

  • id (manager_id) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL — UNIQUE

managing

  • id (managing_id) — NUMBER — Primary key — NOT NULL
  • course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
  • id (manager_id) — NUMBER — Foreign key → manager.id — NOT NULL — UNIQUE

review

  • id (review_id) — NUMBER — Primary key — NOT NULL
  • course_id — NUMBER — Foreign key → course.course_id — NOT NULL
  • id (student_id) — NUMBER — Foreign key → student.id — NOT NULL
  • content — TEXT
  • rating — INT — NOT NULL

student

  • id (student_id) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL — UNIQUE

teaching

  • id (teaching_id) — NUMBER — Primary key — NOT NULL
  • course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
  • id (instructor_id) — NUMBER — Foreign key → instructor.id — NOT NULL — UNIQUE