1

Tables (10)

course

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

course_description

  • id (Key) — Primary key — NOT NULL
  • course_id — INT — NOT NULL
  • content — TEXT — NOT NULL

description_author

  • description_id — UUID
  • author_id — UUID
  • role — VARCHAR

enrollment

  • course_id — UUID
  • student_id — UUID
  • enrolled_at — TIMESTAMP

instructor

  • id — UUID
  • name — VARCHAR
  • email — VARCHAR

manager

  • id — UUID
  • name — VARCHAR
  • email — VARCHAR

managing

  • course_id — UUID
  • manager_id — UUID

review

  • id — UUID
  • course_id — UUID
  • student_id — UUID
  • content — TEXT
  • rating — INT

student

  • id — UUID
  • name — VARCHAR
  • email — VARCHAR

teaching

  • course_id — UUID
  • instructor_id — UUID