englishLMS

Tables (8)

class

  • cno — INT — Primary key
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • instructor_id — INT — NOT NULL
  • created_at — DATETIME

enrollment

  • enrollment_id — INT — Primary key
  • progress — FLOAT
  • completed — BOOLEAN
  • enrolled_at — DATETIME

level

  • level_id — INT — Primary key
  • level_name — VARCHAR(50) — NOT NULL

quiz

  • quiz_id — INT — Primary key
  • title — VARCHAR(200) — NOT NULL
  • total_score — INT

quiz_answer

  • answer_id — INT — Primary key
  • user_answer — TEXT
  • is_correct — BOOLEAN

quiz_attempt

  • attempt_id — INT — Primary key
  • score — INT
  • attempted_at — DATETIME

quiz_question

  • question_id — INT — Primary key
  • content — TEXT — NOT NULL
  • type — ENUM('MULTIPLE_CHOICE', 'SHORT_ANSWER', 'ESSAY') — NOT NULL
  • score — INT

user

  • uno (mno) — INT — Primary key
  • level_id — INT — Foreign key → level.level_id
  • user_name — VARCHAR(100) — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — ENUM('STUDENT', 'INSTRUCTOR', 'ADMIN') — NOT NULL