슬금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`