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