슬금슬금
테이블 (16)
account_book_entries
- id — BINARY(16)
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — 에피소드 연동 내역이면 값 존재
- player_choice_id — BINARY(16) — 외래 키 → player_choices.id — 선택지 연동 내역이면 값 존재
- entry_type — ENUM('CHOICE', 'FIXED_EXPENSE', 'INCOME', 'ADJUSTMENT') — NOT NULL
- title — VARCHAR(100) — NOT NULL — 예: 이어폰 구매, 월세, 월급
- description — VARCHAR(255)
- amount — INT — NOT NULL — 지출은 음수, 수입은 양수
- balance_after — INT — NOT NULL — 해당 내역 반영 후 잔액
- occurred_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_account_book_entries_session_occurred_at
choice_result_dialogues
- id — BINARY(16)
- choice_option_id — BINARY(16) — 외래 키 → story_choice_options.id — NOT NULL
- episode_asset_id — BINARY(16) — 외래 키 → episode_assets.id — NOT NULL
- order_index — TINYINT — NOT NULL
- speaker — VARCHAR(20) — NOT NULL — ME | MOM | FRIEND | PARTNER | NPC | SYSTEM
- talk — TEXT — NOT NULL
- character_key — VARCHAR(100)
- emotion — VARCHAR(50)
- sfx_key — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
diagnosis_reports
- id — BINARY(16)
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL — 1:1
- ending_grade — VARCHAR(5) — NOT NULL — S | A | B | F
- final_balance — INT — NOT NULL
- impulse_count — INT — NOT NULL
- fraud_count — INT — NOT NULL
- financial_behavior_count — INT — NOT NULL
- risk_detection_feedback — TEXT
- overall_feedback — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dialogues
- id — BINARY(16)
- episode_asset_id — BINARY(16) — 외래 키 → episode_assets.id — NOT NULL
- speaker — VARCHAR(20) — NOT NULL — ME | MOM | FRIEND | PARTNER | NPC | SYSTEM
- talk — TEXT — NOT NULL
- order_index — TINYINT — NOT NULL
- character_key — VARCHAR(100) — 예: me
- emotion — VARCHAR(50) — 예: confused
- sfx_key — VARCHAR(100) — 효과음 키
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
episode_assets
- id — BINARY(16)
- story_episode_id — BINARY(16) — 외래 키 → story_episodes.episode_id — NOT NULL
- scene_key — VARCHAR(100) — NOT NULL — 예: scene-1
- scene_order — TINYINT — NOT NULL
- background_key — VARCHAR(100) — NOT NULL — 예: home_morning
- bgm_key — VARCHAR(100) — 예: bgm_home_morning
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
episodes
- id — BINARY(16)
- episode_key — VARCHAR(100) — NOT NULL — 예: episode-1w-earphone
- month — TINYINT — NOT NULL — 1~6
- week — TINYINT — NOT NULL — 0~4
- title — VARCHAR(100) — NOT NULL
- episode_type — ENUM('QUIZ', 'STORY', 'SEMINAR') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
game_sessions
- id — BINARY(16)
- member_id — BINARY(16) — 외래 키 → members.id — NOT NULL
- nickname — VARCHAR(100) — 사용자 입력 이름
- gender — ENUM('man', 'woman', 'unknown') — NOT NULL
- status — ENUM('IN_PROGRESS', 'COMPLETED', 'ABANDONED') — NOT NULL — 중단 = ABANDONED
- current_month — TINYINT — NOT NULL — 1~6
- current_week — TINYINT — NOT NULL — 0~4
- balance — INT — NOT NULL — 현재 잔고 스냅샷
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
members
- id — BINARY(16)
- provider — ENUM('GOOGLE', 'NAVER', 'KAKAO') — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL — OAuth2 고유 식별자
- email — VARCHAR(255) — 소셜 로그인 이메일
- name — VARCHAR(100) — 소셜 로그인 실명
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
player_choices
- id — BINARY(16)
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- choice_option_id — BINARY(16) — 외래 키 → story_choice_options.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_player_choices_session
quiz_answers
- id — BINARY(16)
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL
- question_id — BINARY(16) — 외래 키 → quiz_questions.id — NOT NULL
- choice_id — BINARY(16) — 외래 키 → quiz_choices.id — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_quiz_answers_session
quiz_choices
- id — BINARY(16)
- question_id — BINARY(16) — 외래 키 → quiz_questions.id — NOT NULL
- choice_label — VARCHAR(5) — NOT NULL — A | B
- choice_text — VARCHAR(300) — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
quiz_questions
- id — BINARY(16)
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL — 퀴즈 에피소드 1개당 문제 1세트 기준
- question_text — TEXT — NOT NULL
- explanation — TEXT — NOT NULL — 오답 노트용 해설
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
seminars
- episode_id — BINARY(16) — 외래 키 → episodes.id
- seminar_title — VARCHAR(100) — NOT NULL
- summary — VARCHAR(255)
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
story_choice_options
- id — BINARY(16)
- story_choice_id — BINARY(16) — 외래 키 → story_choices.id — NOT NULL
- option_key — VARCHAR(100) — NOT NULL — 예: choice-a
- option_label — VARCHAR(5) — NOT NULL — A | B
- display_cost — VARCHAR(50) — NOT NULL — 예: 20만원 소비
- description — VARCHAR(300) — NOT NULL
- balance_delta — INT — NOT NULL — 음수 = 지출, 양수 = 수입
- report_category — ENUM('IMPULSE', 'FRAUD', 'FINANCIAL', 'NONE') — NOT NULL
- is_counted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
story_choices
- id — BINARY(16)
- story_episode_id — BINARY(16) — 외래 키 → story_episodes.episode_id — NOT NULL
- choice_key — VARCHAR(100) — NOT NULL — 예: choice-1w
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
story_episodes
- episode_id — BINARY(16) — 외래 키 → episodes.id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL