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