lgcns 2차 미니 플젝 ERD

테이블 (19)

Badge (Untitled11)

  • Key (id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (type)

Daily_Score_Stats (Untitled14)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (total_score_sum)
  • Field3 (quiz_count)
  • Field4 (correct_count)
  • Field5 (wrong_count)
  • Field6 (avg_score)
  • Field7 (created_at)
  • Field8 (updated_at)

Exp_Logs (Untitled13)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (amount)
  • Field3 (source_type)
  • Field4 (description)
  • Field5 (earned_at)

User_Badge (Untitled12)

  • Key (user_id) — 기본 키 — NOT NULL
  • Field (badge_id)
  • Field2 (earned_at)

User_Exp_Status (Untitled10)

  • Key (user_id) — 기본 키 — NOT NULL
  • Field (total_exp)
  • Field2 (current_level)

ai_feedback_log (AI Feedback)

  • Key (feedback_id) — Long — 기본 키 — NOT NULL
  • Key (quiz_id) — Long — 외래 키 → quiz_tbl.Key — NOT NULL
  • Field (user_id) — Long
  • Field (content) — Text

difficulty_test_question_tbl (Test Question)

  • Key (test_id) — Long — 기본 키 — NOT NULL
  • Field (target_age_group) — String
  • Field (question) — String
  • Field (options) — Text
  • Field (correct_answer) — String
  • Field (page_number) — Integer

genre_performance_stat (Untitled16)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (genre)
  • Field3 (attempted_count)
  • Field4 (correct_rate)
  • Field5 (avg_score)
  • Field6 (last_solved_at)
  • Field7 (created_at)
  • Field8 (updated_at)

genre_tbl (Genre)

  • Key (genre_id) — Long — 기본 키 — NOT NULL
  • Field (genre_name) — String

interest_tbl (Interest)

  • Key (interest_id) — Long — 기본 키 — NOT NULL
  • Field (interest_name) — String

quiz_tbl (Quiz)

  • Key (quiz_id) — Long — 기본 키 — NOT NULL
  • Field (story_id) — Long — NOT NULL
  • Field (question) — String
  • Field (answer) — String
  • Field (difficulty) — Integer

recommendation_request_log (Untitled18)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (interest_summary)
  • Field3 (level)
  • Field4 (difficulty)
  • Field5 (recommended_count)
  • Field6 (generated_at)
  • Field7 (status)

story_selection_tbl (Want to Read)

  • Key (user_system_id) — Long — 외래 키 → user_tbl.Key — NOT NULL
  • Field (story_id) — Long

story_tbl (Story)

  • Key (story_id) — Long — 기본 키 — NOT NULL
  • Key (genre_id) — Long — 외래 키 → genre_tbl.Key — NOT NULL
  • Field (api_id) — Long
  • Field (title) — String
  • Field (author) — String
  • Field (content) — Text
  • Field (char_count) — Integer
  • Field (ai_image_url) — String
  • Field (source_url) — String
  • Field (origin_thumb_url) — String

study_record_tbl (Record)

  • Key (id) — Long — 기본 키 — NOT NULL
  • Field (user_id) — Long
  • Field (story_id) — Long
  • Field (base_correct_count) — Integer
  • Field (bonus_correct_count) — Integer
  • Field (is_bonus_triggered) — Boolean
  • Field (is_highest_difficulty) — Integer
  • Field (total_score) — Integer
  • Field (created_at) — Date

user_growth_snapshot (Untitled15)

  • Key (id) — 기본 키 — NOT NULL
  • Key (user_id)
  • Field2 (snapshot_date)
  • Field3 (current_level)
  • Field4 (total_score)
  • Field5 (total_quiz_count)
  • Field6 (total_correct_count)
  • Field7 (overall_correct_rate)
  • Field8 (created_at)

user_interest_relationship (User Interest)

  • FK (user_system_id) — Long — 외래 키 → user_tbl.Key — NOT NULL
  • FK (interest_id) — Long — 외래 키 → interest_tbl.Key — NOT NULL

user_recommendation (Untitled17)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user_id)
  • Field2 (story_id)
  • Field3 (rank_order)
  • Field4 (reason)
  • Field5 (based_age)
  • Field6 (based_level)
  • Field7 (based_difficulty)
  • Field8 (generated_at)
  • Field9 (expires_at)

user_tbl (User)

  • Key (user_system_id) — Long — 기본 키 — NOT NULL
  • Field (login_id) — String — NOT NULL
  • Field (password) — String — NOT NULL
  • Field (age) — Integer
  • Field (current_level) — Integer
  • Field (assigned_difficulty) — String