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