DoctorKim

Tables (10)

ai_generated_quiz

  • quiz_id — uuid — Primary key — NOT NULL
  • room_id — uuid — Foreign key → learning_room.room_id — NOT NULL
  • pdf_extraction_id (Key3) — uuid — Foreign key → pdf_extraction_page.pdf_extraction_id — NOT NULL
  • generation_time — timestamp
  • question — text
  • choices — text
  • correct_answer — text
  • explanation — text

ai_tutor_script

  • script_id — uuid — Primary key — NOT NULL
  • room_id — uuid — Foreign key → learning_room.room_id — NOT NULL
  • generated_at — timestamp
  • lecture_text — text
  • audio_url — text
  • tts_voice_style — varchar(50)

learning_room

  • room_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → user_account.user_id — NOT NULL
  • pdf_id — uuid — Foreign key → pdf.pdf_id — NOT NULL
  • current_page — int
  • last_study_date — timestamp
  • study_goal — text

pdf

  • pdf_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → user_account.user_id — NOT NULL
  • file_name — varchar(255)
  • storage_url — text
  • upload_date — timestamp

pdf_extraction_page (coach_page_output)

  • pdf_extraction_id — uuid — Primary key — NOT NULL
  • room_id — uuid — Foreign key → learning_room.room_id — NOT NULL
  • page_id — uuid — Foreign key → pdf_page.page_id — NOT NULL
  • pdf_id — uuid — Foreign key → pdf_page.pdf_id — NOT NULL
  • summary — text
  • cornell_summary (cornell) — text
  • key_terms — text
  • concept_json — text
  • last_updated — timestamp

pdf_page

  • page_id — uuid — Primary key — NOT NULL
  • pdf_id — uuid — Foreign key → pdf.pdf_id — NOT NULL
  • page_number — int
  • page_text — text
  • thumbnail_url — text

quiz_history

  • quiz_history — uuid — Primary key — NOT NULL
  • room_id — uuid — Foreign key → learning_room.room_id — NOT NULL
  • generated_quiz_ids — text
  • score — int
  • total_questions — int
  • start_time — timestamp
  • duration_seconds — int

user_account

  • user_id — uuid — Primary key — NOT NULL
  • email — varchar(255)
  • password_hash — varchar(255)
  • nickname — varchar(100)
  • registration_date — timestamp

weakness_diagnosis

  • diagnosis_id — uuid — Primary key — NOT NULL
  • room_id — uuid — Foreign key → learning_room.room_id — NOT NULL
  • analysis_date — timestamp
  • weak_area — text
  • improvement_plan — text

wrong_answer

  • wrong_id — uuid — Primary key — NOT NULL
  • quiz_history — uuid — Foreign key → quiz_history.quiz_history — NOT NULL
  • question — text
  • your_answer — text
  • correct_answer — text
  • explanation — text
  • review_count — int
  • is_mastered — boolean