전종설 2

테이블 (11)

course

  • course_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • semester — VARCHAR(10) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

feedback

  • feedback_id — INT — 기본 키 — NOT NULL
  • attempt_id — INT — 외래 키 → quiz_attempt.attempt_id — NOT NULL
  • feedback_text — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

lecture

  • lecture_id — INT — 기본 키 — NOT NULL
  • course_id — INT — 외래 키 → course.course_id — 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 — 기본 키 — NOT NULL
  • lecture_id — INT — 외래 키 → lecture.lecture_id — NOT NULL
  • page_number — INT — NOT NULL

note

  • note_id — INT — 기본 키 — NOT NULL
  • page_id — INT — 외래 키 → lecture_page.page_id — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • note_text — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

question

  • question_id — INT — 기본 키 — NOT NULL
  • quiz_id — INT — 외래 키 → quiz.quiz_id — NOT NULL
  • question_text — TEXT — NOT NULL
  • correct_answer — TEXT — NOT NULL
  • explanation — TEXT

question_attempt

  • question_attempt_id — INT — 기본 키 — NOT NULL
  • attempt_id — INT — 외래 키 → quiz_attempt.attempt_id — NOT NULL
  • question_id — INT — 외래 키 → question.question_id — NOT NULL
  • user_answer — TEXT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

quiz

  • quiz_id — INT — 기본 키 — NOT NULL
  • summary_id — INT — 외래 키 → summary.summary_id — NOT NULL
  • course_id — INT — 외래 키 → course.course_id — NOT NULL
  • question_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

quiz_attempt

  • attempt_id — INT — 기본 키 — NOT NULL
  • quiz_id — INT — 외래 키 → quiz.quiz_id — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • attempted_at — DATETIME — NOT NULL
  • score — INT
  • total_questions — INT
  • correct_count — INT

summary

  • summary_id — INT — 기본 키 — NOT NULL
  • lecture_id — INT — 외래 키 → lecture.lecture_id — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • summary_text — TEXT — NOT NULL
  • generated_at — DATETIME — NOT NULL

user

  • user_id — INT — 기본 키 — NOT NULL
  • 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