전종설

테이블 (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