fd
Tables (41)
agent_chat_rooms
- agent_room_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- learning_mode — VARCHAR(20)
- created_at — DATETIME — NOT NULL
agents
- agent_id — BIGINT — Primary key — NOT NULL
- agent_room_id — BIGINT — Foreign key → agent_chat_rooms.agent_room_id — NOT NULL
- name — VARCHAR(30) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- persona — VARCHAR(1000) — NOT NULL
- tone — VARCHAR(100)
- goal — VARCHAR(200)
- created_at — DATETIME — NOT NULL
blog_comments
- comment_id — BIGINT — Primary key — NOT NULL
- blog_id — BIGINT — Foreign key → blogs.blog_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
blog_likes
- like_id — BIGINT — Primary key — NOT NULL
- blog_id — BIGINT — Foreign key → blogs.blog_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
blogs
- blog_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- pdf_s3_key — VARCHAR(255)
- image_s3_key — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
chat_messages
- message_id — BIGINT — Primary key — NOT NULL
- agent_room_id — BIGINT — Foreign key → agent_chat_rooms.agent_room_id — NOT NULL
- agent_id — BIGINT — Foreign key → agents.agent_id
- content — TEXT — NOT NULL
- sender — VARCHAR(100) — NOT NULL
- process_steps_json — TEXT
- created_at — DATETIME — NOT NULL
folders
- folder_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- parent_id — BIGINT — Foreign key → folders.folder_id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
group_studies
- group_study_id — BIGINT — Primary key — NOT NULL
- leader_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- capacity — INT — NOT NULL
- current_count — INT — NOT NULL
- is_public — BOOLEAN — NOT NULL
- status — VARCHAR(20) — NOT NULL
- hashtags — VARCHAR(200)
- cover_image_key — VARCHAR(300)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
group_study_attendances
- group_study_attendance_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- attendance_date — DATE — NOT NULL
- check_in_time — DATETIME — NOT NULL
- check_out_time — DATETIME
- study_duration_seconds — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
group_study_join_applications
- group_study_join_application_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- introduction — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
group_study_materials
- group_study_material_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- uploader_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- s3_key — VARCHAR(255) — NOT NULL
- file_size — BIGINT — NOT NULL
- original_file_name — VARCHAR(255)
- content_type — VARCHAR(100)
- created_at — DATETIME — NOT NULL
group_study_members
- group_study_member_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- points — INT — NOT NULL
- joined_at — DATETIME — NOT NULL
group_study_quiz_questions
- group_study_quiz_question_id — BIGINT — Primary key — NOT NULL
- quiz_id — BIGINT — Foreign key → group_study_quizzes.group_study_quiz_id — NOT NULL
- question — TEXT — NOT NULL
- options_json — TEXT — NOT NULL
- correct_answer — INT — NOT NULL
- time_limit_seconds — INT — NOT NULL
group_study_quiz_session_answers
- group_study_quiz_session_answer_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → group_study_quiz_sessions.group_study_quiz_session_id — NOT NULL
- user_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- submitted_answer — INT
- is_correct — BOOLEAN
- points_awarded — INT
- submitted_at — DATETIME
- graded_at — DATETIME
- created_at — DATETIME — NOT NULL
group_study_quiz_sessions
- group_study_quiz_session_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- quiz_id — BIGINT — Foreign key → group_study_quizzes.group_study_quiz_id — NOT NULL
- quiz_title_snapshot — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- current_question_index — INT — NOT NULL
- question_duration_seconds — INT — NOT NULL
- question_order_json — TEXT — NOT NULL
- current_question_id — BIGINT
- question_started_at — DATETIME
- question_ends_at — DATETIME
- reveal_at — DATETIME
- next_question_at — DATETIME
- completed_at — DATETIME
- version — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
group_study_quizzes
- group_study_quiz_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- creator_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- reward_points — INT — NOT NULL
- created_at — DATETIME — NOT NULL
group_study_reports
- group_study_report_id — BIGINT — Primary key — NOT NULL
- group_study_id — BIGINT — Foreign key → group_studies.group_study_id — NOT NULL
- reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
- reported_user_id — BIGINT — Foreign key → users.user_id
- reason — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
inquiries
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- reply — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
learning_loop_events
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- event_type — VARCHAR(40) — NOT NULL
- source_type — VARCHAR(20)
- source_id — BIGINT
- material_id — BIGINT
- document_id — BIGINT
- room_id — BIGINT
- planner_id — BIGINT
- wrong_note_id — BIGINT
- quiz_id — BIGINT
- question_id — BIGINT
- input_text — TEXT
- ai_output_summary — TEXT
- ai_output_json — TEXT
- user_action — VARCHAR(100)
- user_memo — TEXT
- is_correct — BOOLEAN
- score — INT
- difficulty — VARCHAR(20)
- recommend_review_in_days — INT
- recommended_review_date — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
material_feedbacks
- feedback_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- feedback_data — TEXT
- created_at — DATETIME — NOT NULL
material_memos
- memo_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
material_questions
- question_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- user_question — VARCHAR(1000) — NOT NULL
- ai_answer — TEXT
- created_at — DATETIME — NOT NULL
material_quizzes
- quiz_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- difficulty — VARCHAR(20)
- question_count — INT
- page_range — VARCHAR(100)
- quiz_data — TEXT
- created_at — DATETIME — NOT NULL
material_study_note_analysis
- id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- user_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- fallback — BOOLEAN
- fallback_reason — VARCHAR(100)
- domain — VARCHAR(100)
- domain_label — VARCHAR(100)
- core_object — VARCHAR(100)
- core_object_label — VARCHAR(100)
- disclaimer — TEXT
- document_overview — TEXT
- keywords_json — TEXT
- core_contents_json — TEXT
- detailed_core_contents_json — TEXT
- page_summaries_json — TEXT
- study_points_json — TEXT
- ai_study_questions_json — TEXT
- wiki_summaries_json — TEXT
- limitations_json — TEXT
- error_message — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
material_summaries
- summary_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id — NOT NULL
- overview — TEXT
- core_contents — TEXT
- created_at — DATETIME — NOT NULL
materials
- material_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- folder_id — BIGINT — Foreign key → folders.folder_id
- title — VARCHAR(255) — NOT NULL
- material_type — VARCHAR(30) — NOT NULL
- keywords — VARCHAR(1000)
- study_date — DATE
- learning_content — TEXT
- next_plan — TEXT
- original_file_name — VARCHAR(255)
- stored_file_name — VARCHAR(255)
- s3_file_url — VARCHAR(500)
- file_size — BIGINT
- extracted_text — TEXT
- extraction_status — VARCHAR(20)
- uploaded_at — DATETIME — NOT NULL
- updated_at — DATETIME
plan_analysis
- analysis_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- material_id — BIGINT — NOT NULL
- planner_id — BIGINT
- source_type — VARCHAR(20)
- summary — TEXT
- recommendation — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
plan_analysis_item
- item_id — BIGINT — Primary key — NOT NULL
- analysis_id — BIGINT — Foreign key → plan_analysis.analysis_id — NOT NULL
- order_index — INT
- type — VARCHAR(20)
- text — TEXT
- source_text — TEXT
- source_type — VARCHAR(20)
- page_number — INT
- chunk_index — INT
- completed — BOOLEAN — NOT NULL
- hidden — BOOLEAN — NOT NULL
- deleted — BOOLEAN — NOT NULL
- completed_at — DATETIME
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
planner_ai_result
- id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → planners.planner_id — NOT NULL
- expanded_goal — TEXT
- expanded_todo — TEXT
- estimated_time — VARCHAR(100)
- study_strategy — TEXT
- risk_points — TEXT
- today_checkpoints — TEXT
- ai_questions — TEXT
- reflection_prompts — TEXT
- ai_summary — TEXT
- refined_goal — TEXT
- task_breakdown — TEXT
- time_feedback — TEXT
- ai_feedback — TEXT
- next_actions — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
planners
- planner_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- year — INT
- month — INT
- day — INT
- day_of_week — VARCHAR(10)
- planner_date — DATE
- goal_time — VARCHAR(50)
- net_study_time — VARCHAR(50)
- wake_up_time — VARCHAR(50)
- d_day — VARCHAR(50)
- study_type — VARCHAR(50)
- priority — VARCHAR(20)
- term — VARCHAR(50)
- subject — VARCHAR(200)
- content — TEXT
- tmi — TEXT
- time_table_json — TEXT
- s3_key — VARCHAR(500)
- material_id — BIGINT
- source_type — VARCHAR(30)
- source_material_id — BIGINT
- source_roadmap_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
refresh_tokens
- token_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- token — VARCHAR(500) — NOT NULL
- expiry_date — DATETIME — NOT NULL
reports
- report_id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
- report_type — VARCHAR(20) — NOT NULL
- reported_user_id — BIGINT — Foreign key → users.user_id
- reported_blog_id — BIGINT — Foreign key → blogs.blog_id
- reported_comment_id — BIGINT — Foreign key → blog_comments.comment_id
- reason — VARCHAR(30) — NOT NULL
- details — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
review_notes
- review_note_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- source_material_id — BIGINT — NOT NULL
- source_title — VARCHAR(255)
- quiz_id — BIGINT
- archive_material_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- s3_key — VARCHAR(500)
- wrong_count — INT
- unanswered_count — INT
- difficulty — VARCHAR(20)
- memo — TEXT
- retry_json — TEXT
- created_at — DATETIME — NOT NULL
roadmap_steps
- step_id — BIGINT — Primary key — NOT NULL
- roadmap_id — BIGINT — Foreign key → roadmaps.roadmap_id — NOT NULL
- step_order — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
roadmap_tasks
- task_id — BIGINT — Primary key — NOT NULL
- step_id — BIGINT — Foreign key → roadmap_steps.step_id — NOT NULL
- task_order — INT — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- is_completed — BOOLEAN — NOT NULL
roadmaps
- roadmap_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- material_id — BIGINT — Foreign key → materials.material_id
- planner_id — BIGINT
- source_type — VARCHAR(20)
- title — VARCHAR(255) — NOT NULL
- goal — VARCHAR(255)
- summary — TEXT
- roadmap_json — TEXT
- created_at — DATETIME — NOT NULL
socratic_review_sessions
- id — BIGINT — Primary key — NOT NULL
- session_id — VARCHAR(100) — NOT NULL
- material_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- title — VARCHAR(255)
- recommend_review_in_days — INT
- recommended_review_date — DATE
- summary_for_planner — TEXT
- weak_concepts_json — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
study_journals
- id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- type — VARCHAR(40) — NOT NULL
- s3_key — VARCHAR(500) — NOT NULL
- content_hash — VARCHAR(64)
- byte_size — BIGINT
- content_type — VARCHAR(100)
- validation_decision — VARCHAR(30)
- validation_category — VARCHAR(50)
- relation_type — VARCHAR(40)
- relation_path — VARCHAR(300)
- confidence — DOUBLE
- status — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
timers
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- duration_seconds — BIGINT
- status — VARCHAR(20) — NOT NULL
- group_study_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
todos
- todo_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- text — VARCHAR(255) — NOT NULL
- completed — BOOLEAN — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(50) — NOT NULL
- photo_url — VARCHAR(300)
- major — VARCHAR(50)
- status — VARCHAR(20)
- is_subscribed — BOOLEAN — NOT NULL
- role — VARCHAR(20)
- suspension_end_date — DATETIME
- suspension_reason — TEXT
- suspension_memo — TEXT
- created_at — DATETIME — NOT NULL