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