GAME
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