mysql

Tables (6)

Course

  • course_id — LONG — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP — NOT NULL
  • instructor_id — LONG — Foreign key → Instructor.instructor_id — NOT NULL
  • operator_id — LONG — Foreign key → Operator.operator_id — NOT NULL

Enrollment

  • enrollment_id — LONG — Primary key — NOT NULL
  • student_id (student_id2) — LONG — Foreign key → Student.student_id — NOT NULL
  • course_id — LONG — Foreign key → Course.course_id — NOT NULL
  • status — VARCHAR(50)
  • enrolled_at — TIMESTAMP

Instructor

  • instructor_id — LONG — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • department — VARCHAR(120)
  • email — VARCHAR(120)

Operator

  • operator_id — LONG — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(80) — NOT NULL
  • email — VARCHAR(120)

Review

  • review_id — LONG — Primary key — NOT NULL
  • course_id (course_id2) — LONG — Foreign key → Course.course_id — NOT NULL
  • student_id — LONG — Foreign key → Student.student_id — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT — EX
  • created_at — TIMESTAMP — NOT NULL

Student

  • student_id — LONG — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(120)
  • major — VARCHAR(100)
  • created_at — TIMESTAMP