LMS

Tables (8)

courses

  • course_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • operator_id — BIGINT — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — Foreign key → operators.user_id — NOT NULL

enrollments

  • course_id — BIGINT — Foreign key → courses.course_id — NOT NULL
  • user_id — BIGINT — Foreign key → students.user_id — NOT NULL
  • enrolled_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(20) — NOT NULL

instructors

  • instructor_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • career_years — SMALLINT

operators

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • department — VARCHAR(100)
  • position — VARCHAR(100)

reviews

  • review_id (BIGINT) — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • rating — SMALLINT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — Foreign key → students.user_id — NOT NULL

students

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • student_no — VARCHAR(50)

teaching_assignments

  • instructor_id (instructor_id2) — BIGINT — Foreign key → instructors.instructor_id — NOT NULL
  • course_id — BIGINT — Foreign key → courses.course_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(200)
  • created_at — TIMESTAMP — NOT NULL