슬금슬금

테이블 (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