슬금4
테이블 (15)
account_book_entries
- id — BINARY(16) — 기본 키 — NOT NULL
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL
- episode_key — VARCHAR(100) — episodes.episode_key. 역추적용 (FK 없음)
- entry_type — ENUM('CHOICE', 'FIXED_EXPENSE', 'INCOME', 'ADJUSTMENT') — NOT NULL
- title — VARCHAR(100) — NOT NULL — 예: 이어폰 구매, 월세, 월급
- description — VARCHAR(255)
- amount — INT — NOT NULL — 지출 음수, 수입 양수
- created_at — DATETIME — NOT NULL
- INDEX — `idx_account_entries_session_time`
choice_result_dialogues
- id — BINARY(16) — 기본 키 — NOT NULL
- story_choice_option_id — BINARY(16) — 외래 키 → story_choice_options.id — NOT NULL
- order_index — TINYINT — NOT NULL — >= 1
- 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
- INDEX — `idx_result_dialogues_option`
diagnosis_reports
- id — BINARY(16) — 기본 키 — NOT NULL
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL
- 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) — 기본 키 — NOT NULL
- episode_asset_id — BINARY(16) — 외래 키 → episode_assets.id — NOT NULL
- order_index — TINYINT — NOT NULL — >= 1
- 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
- INDEX — `idx_dialogues_asset`
episode_assets
- id — BINARY(16) — 기본 키 — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- scene_key — VARCHAR(100) — NOT NULL — 예: scene-1
- scene_order — TINYINT — NOT NULL — >= 1
- 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
- INDEX — `idx_episode_assets_episode`
episode_fixed_events
- id — BINARY(16) — 기본 키 — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- entry_type — ENUM('FIXED_EXPENSE', 'INCOME', 'ADJUSTMENT') — NOT NULL
- title — VARCHAR(100) — NOT NULL — 예: 월급, 월세
- description — VARCHAR(255)
- amount — INT — NOT NULL — 지출 음수, 수입 양수
- apply_order — TINYINT — NOT NULL — 같은 에피소드 내 적용 순서
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `idx_fixed_events_episode`
episodes
- id — BINARY(16) — 기본 키 — NOT NULL
- episode_key — VARCHAR(100) — NOT NULL — 예: episode-1w-earphone
- month — TINYINT — NOT NULL — 1~6
- week — TINYINT — NOT NULL — 1~3
- 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) — 기본 키 — NOT NULL
- 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
- current_month — TINYINT — NOT NULL — 1~6
- current_week — TINYINT — NOT NULL — 1~3
- balance — INT — NOT NULL — 잔액 단일 진실 공급원
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `idx_game_sessions_member`
members
- id — BINARY(16) — 기본 키 — NOT NULL
- 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
quiz_choices
- id — BINARY(16) — 기본 키 — NOT NULL
- question_id — BINARY(16) — 외래 키 → quiz_questions.id — NOT NULL
- choice_text — VARCHAR(300) — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `idx_quiz_choices_question`
quiz_questions
- id — BINARY(16) — 기본 키 — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- question_number — TINYINT — NOT NULL — 1~5 고정
- question_text — TEXT — NOT NULL
- explanation — TEXT — NOT NULL — 오답 해설
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `idx_quiz_questions_episode`
seminars
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- seminar_title — VARCHAR(100) — NOT NULL
- summary — VARCHAR(255)
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
session_quiz_answers
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL — game_sessions.id
- question_id — BINARY(16) — 외래 키 → quiz_questions.id — NOT NULL — quiz_questions.id
- choice_id — BINARY(16) — 외래 키 → quiz_choices.id — NOT NULL — quiz_choices.id
- answered_at — DATETIME — NOT NULL
- INDEX — `idx_quiz_answers_session`
session_story_answers
- session_id — BINARY(16) — 외래 키 → game_sessions.id — NOT NULL — game_sessions.id
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL — episodes.id
- choice_id — BINARY(16) — 외래 키 → story_choice_options.id — NOT NULL — story_choice_options.id
- answered_at — DATETIME — NOT NULL
- INDEX — `idx_story_answers_session`
story_choice_options
- id — BINARY(16) — 기본 키 — NOT NULL
- episode_id — BINARY(16) — 외래 키 → episodes.id — NOT NULL
- 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
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `idx_story_choice_options_episode`