슬금2

테이블 (12)

choice_dialogues

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • choice_id — CHAR(36) — 외래 키 → episode_choices.id — NOT NULL — UUID
  • speaker — VARCHAR(20) — NOT NULL — ME | MOM | FRIEND | PARTNER | NPC | SYSTEM
  • talk — TEXT — NOT NULL
  • order_index — SMALLINT — NOT NULL — >= 1
  • character_key — VARCHAR(50)
  • emotion — VARCHAR(30)
  • sfx_key — VARCHAR(100)
  • INDEX — idx_choice_dialogues_choice

diagnosis_reports

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • session_id — CHAR(36) — 외래 키 → game_sessions.id — NOT NULL — UUID
  • 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 — CHAR(36) — 기본 키 — NOT NULL — UUID
  • scene_id — CHAR(36) — 외래 키 → episode_scenes.id — NOT NULL — UUID
  • speaker — VARCHAR(20) — NOT NULL — ME | MOM | FRIEND | PARTNER | NPC | SYSTEM
  • talk — TEXT — NOT NULL
  • order_index — SMALLINT — NOT NULL — >= 1
  • character_key — VARCHAR(50)
  • emotion — VARCHAR(30)
  • sfx_key — VARCHAR(100)
  • INDEX — idx_dialogues_scene

episode_choices

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • scene_id — CHAR(36) — 외래 키 → episode_scenes.id — NOT NULL — UUID
  • choice_label — VARCHAR(5) — NOT NULL — A | B
  • description — VARCHAR(300) — NOT NULL
  • balance_delta — INT — NOT NULL
  • next_scene_id — CHAR(36) — 외래 키 → episode_scenes.id — NOT NULL — UUID
  • report_category — VARCHAR(20) — NOT NULL — IMPULSE | FRAUD | FINANCIAL | NONE
  • is_counted — TINYINT — NOT NULL
  • INDEX — idx_episode_choices_scene

episode_scenes

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • episode_id — CHAR(36) — 외래 키 → episodes.id — NOT NULL — UUID
  • scene_order — SMALLINT — NOT NULL — >= 1
  • scene_type — VARCHAR(20) — NOT NULL — STORY | CHOICE | RESULT | QUIZ
  • title — VARCHAR(100)
  • background_key — VARCHAR(100)
  • bgm_key — VARCHAR(100)
  • next_episode_scene_id — CHAR(36) — 외래 키 → episode_scenes.id — UUID | 자기참조
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_episode_scenes_episode

episodes

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • month — TINYINT — NOT NULL — 1~6
  • week — TINYINT — NOT NULL — 0~4
  • title — VARCHAR(100) — NOT NULL
  • episode_type — VARCHAR(20) — NOT NULL — ONBOARDING | STORY | QUIZ

game_sessions

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • member_id — CHAR(36) — 외래 키 → members.id — NOT NULL — UUID
  • nickname — VARCHAR(255)
  • gender — VARCHAR(20) — NOT NULL — MAN | WOMAN | UNKNOWN
  • status — VARCHAR(20) — NOT NULL — IN_PROGRESS | COMPLETED
  • current_month — TINYINT — NOT NULL
  • current_week — TINYINT — NOT NULL
  • balance — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

members

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • provider — VARCHAR(20) — NOT NULL — GOOGLE | NAVER | KAKAO
  • provider_id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

player_choices

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • session_id — CHAR(36) — 외래 키 → game_sessions.id — NOT NULL — UUID
  • episode_id — CHAR(36) — 외래 키 → episodes.id — NOT NULL — UUID
  • episode_choice_id — CHAR(36) — 외래 키 → episode_choices.id — NOT NULL — UUID
  • balance_before — INT — NOT NULL
  • balance_after — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_player_choices_session

quiz_answers

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • session_id — CHAR(36) — 외래 키 → game_sessions.id — NOT NULL — UUID
  • question_id — CHAR(36) — 외래 키 → quiz_questions.id — NOT NULL — UUID
  • quiz_choice_id — CHAR(36) — 외래 키 → quiz_choices.id — NOT NULL — UUID
  • is_correct — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_quiz_answers_session

quiz_choices

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • question_id — CHAR(36) — 외래 키 → quiz_questions.id — NOT NULL — UUID
  • choice_label — VARCHAR(5) — NOT NULL — A | B
  • choice_text — VARCHAR(300) — NOT NULL
  • is_correct — TINYINT — NOT NULL
  • INDEX — idx_quiz_choices_question

quiz_questions

  • id — CHAR(36) — 기본 키 — NOT NULL — UUID
  • episode_id — CHAR(36) — 외래 키 → episodes.id — NOT NULL — UUID
  • question_text — TEXT — NOT NULL
  • explanation — TEXT — NOT NULL
  • INDEX — idx_quiz_questions_episode