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