전종설
테이블 (11)
course
- course_id — INT
- user_id — INT — NOT NULL
- semester — VARCHAR(10) — NOT NULL
- course_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
feedback
- feedback_id — INT
- attempt_id — INT — NOT NULL
- feedback_text — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
lecture
- lecture_id — INT
- course_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- uploaded_at — DATETIME — NOT NULL
- updated_at — DATETIME
lecture_page
- page_id — INT
- lecture_id — INT — NOT NULL
- page_number — INT — NOT NULL
note
- note_id — INT
- page_id — INT — NOT NULL
- user_id — INT — NOT NULL
- note_text — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
question
- question_id — INT
- quiz_id — INT — NOT NULL
- question_text — TEXT — NOT NULL
- correct_answer — TEXT — NOT NULL
- explanation — TEXT
question_attempt
- question_attempt_id — INT
- attempt_id — INT — NOT NULL
- question_id — INT — NOT NULL
- user_answer — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
quiz
- quiz_id — INT
- summary_id — INT — NOT NULL
- course_id — INT — NOT NULL
- question_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
quiz_attempt
- attempt_id — INT
- quiz_id — INT — NOT NULL
- user_id — INT — NOT NULL
- attempted_at — DATETIME — NOT NULL
- score — INT
- total_questions — INT
- correct_count — INT
summary
- summary_id — INT
- lecture_id — INT — NOT NULL
- user_id — INT — NOT NULL
- summary_text — TEXT — NOT NULL
- generated_at — DATETIME — NOT NULL
user
- user_id — INT
- login_id — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- email — VARCHAR(100) — NOT NULL
- program_year — INT — NOT NULL
- current_semester — VARCHAR(10) — NOT NULL