GameBalance

Tables (35)

ai_chat_message_intents

  • id — BIGINT — Primary key — NOT NULL
  • message_id — BIGINT — Foreign key → ai_chat_messages.id — NOT NULL
  • intent_tag — VARCHAR(100) — NOT NULL

ai_chat_message_scores

  • id — BIGINT — Primary key — NOT NULL
  • message_id — BIGINT — Foreign key → ai_chat_messages.id — NOT NULL
  • score_type — VARCHAR(50) — NOT NULL
  • score_value — INT — NOT NULL

ai_chat_messages

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → ai_chat_sessions.id — NOT NULL
  • sender_type — VARCHAR(20) — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id
  • message_text — TEXT — NOT NULL
  • created_at — DATETIME

ai_chat_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100)
  • session_type — VARCHAR(30)
  • is_private — TINYINT(1)
  • is_active — TINYINT(1)
  • last_response_id — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME

beta_feedback

  • id — BIGINT — Primary key — NOT NULL
  • participation_id — BIGINT — Foreign key → test_participations.id — NOT NULL
  • rating — TINYINT
  • answers_json — JSON
  • bug_report — VARCHAR(2000)
  • status — VARCHAR(20)
  • created_at — DATETIME

beta_test_details

  • post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
  • genre — VARCHAR(100)
  • stage — VARCHAR(30)
  • estimated_minutes — INT
  • build_link_url — VARCHAR(500)
  • questions_json — JSON
  • deadline — DATETIME

board_comments

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → board_comments.id
  • content — VARCHAR(2000) — NOT NULL
  • is_accepted — TINYINT(1)
  • created_at — DATETIME

board_post_images

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT

board_posts

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id
  • tag — VARCHAR(50)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(500)
  • is_anonymous — TINYINT(1)
  • view_count — INT
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • expires_at — DATETIME

budgets

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • year_month — CHAR(7) — NOT NULL
  • limit_amount — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

content_interactions

  • id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • interaction_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME

daily_fortune_draws

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • draw_date — DATE — NOT NULL
  • card_result_json — JSON — NOT NULL
  • ai_message — VARCHAR(500)

external_reviews

  • id — BIGINT — Primary key — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL
  • source — VARCHAR(30) — NOT NULL
  • external_review_id — VARCHAR(64) — NOT NULL
  • sentiment — VARCHAR(10) — NOT NULL
  • excerpt — VARCHAR(500) — NOT NULL
  • summary_ko — VARCHAR(500)
  • helpful_votes — INT
  • author_playtime_minutes — INT
  • source_url — VARCHAR(500) — NOT NULL
  • language — VARCHAR(10)
  • posted_at — DATETIME
  • collected_at — DATETIME

game_dropouts

  • id — BIGINT — Primary key — NOT NULL
  • user_owned_game_id — BIGINT — Foreign key → user_owned_games.id — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL
  • playtime_at_drop_minutes — INT — NOT NULL
  • reason_code — VARCHAR(20) — NOT NULL
  • reason_text — VARCHAR(200)
  • created_at — DATETIME

game_genres

  • genre — VARCHAR(50) — Primary key — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL

game_requirements_cache

  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL
  • min_cpu_model — VARCHAR(100)
  • min_gpu_model — VARCHAR(100)
  • rec_cpu_model — VARCHAR(100)
  • rec_gpu_model — VARCHAR(100)
  • parsed_at — DATETIME

games

  • app_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • genre — VARCHAR(255)
  • price_info — VARCHAR(100)
  • discount_percent — TINYINT
  • review_count — INT
  • positive_rate — DECIMAL(5,2)
  • min_spec_raw_text — TEXT
  • rec_spec_raw_text — TEXT
  • thumbnail_url — VARCHAR(500)
  • description — TEXT
  • last_synced_at — DATETIME

login_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • logged_in_at — DATETIME

news_articles

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • source_name — VARCHAR(100)
  • source_url — VARCHAR(500) — NOT NULL
  • summary — VARCHAR(500)
  • thumbnail_url — VARCHAR(500)
  • category — VARCHAR(20)
  • published_at — DATETIME
  • collected_at — DATETIME

password_reset_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token — VARCHAR(64) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used — TINYINT(1)
  • created_at — DATETIME

purchase_emotions

  • id — BIGINT — Primary key — NOT NULL
  • user_owned_game_id — BIGINT — Foreign key → user_owned_games.id — NOT NULL
  • emotion — VARCHAR(20) — NOT NULL
  • created_at — DATETIME

purchase_plans

  • user_owned_game_id — BIGINT — Foreign key → user_owned_games.id — NOT NULL
  • pledge_type — VARCHAR(20)
  • planned_playtime_minutes — INT
  • planned_exit_date — DATE
  • created_at — DATETIME

reports

  • id — BIGINT — Primary key — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(1000) — NOT NULL
  • status — VARCHAR(30)
  • reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME

reviews

  • id — BIGINT — Primary key — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • emotion — VARCHAR(20)
  • content — VARCHAR(2000) — NOT NULL
  • created_at — DATETIME

room_placements

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • user_item_id — BIGINT — Foreign key → user_items.id — NOT NULL
  • pos_x — INT — NOT NULL
  • pos_y — INT — NOT NULL

shop_items

  • id — BIGINT — Primary key — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • item_type — VARCHAR(30) — NOT NULL
  • point_cost — INT — NOT NULL
  • thumbnail_url — VARCHAR(500)

social_accounts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • access_token — TEXT
  • connected_at — DATETIME

taste_choices

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • option_a — VARCHAR(100) — NOT NULL
  • option_b — VARCHAR(100) — NOT NULL
  • selected — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

test_participations

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → board_posts.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • started_at — DATETIME

user_community_stats

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • activity_points — INT
  • level — INT
  • is_promoted — TINYINT(1)
  • updated_at — DATETIME

user_flags

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • flag_type — VARCHAR(30)
  • reason — VARCHAR(500)
  • report_id — BIGINT — Foreign key → reports.id
  • flagged_by — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME
  • released_at — DATETIME

user_items

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • item_id — BIGINT — Foreign key → shop_items.id — NOT NULL
  • acquired_at — DATETIME

user_owned_games

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • app_id — BIGINT — Foreign key → games.app_id — NOT NULL
  • playtime_minutes — INT
  • purchase_price — INT
  • purchase_date — DATE
  • purchase_was_on_sale — TINYINT(1)
  • source — VARCHAR(20)
  • last_played_at — DATETIME
  • last_synced_at — DATETIME

user_pc_specs

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • cpu_model — VARCHAR(100)
  • gpu_model — VARCHAR(100)
  • ram_tier — VARCHAR(20)
  • updated_at — DATETIME

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • withdrawn_at — DATETIME