미니게임

테이블 (23)

admin_actions

  • action_id — BIGINT
  • admin_id — BIGINT — NOT NULL
  • action_type — VARCHAR(60) — NOT NULL
  • target_type — VARCHAR(60)
  • target_id — BIGINT
  • detail_json — JSON
  • created_at — DATETIME — NOT NULL

audit_logs

  • log_id — BIGINT
  • user_id — BIGINT
  • ip_addr — VARCHAR(45)
  • user_agent — VARCHAR(300)
  • action — VARCHAR(80)
  • created_at — DATETIME — NOT NULL

auth_providers

  • provider_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • provider_type — ENUM('LOCAL','GOOGLE','KAKAO','NAVER','GITHUB') — NOT NULL
  • provider_uid — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

banners

  • banner_id — BIGINT
  • title — VARCHAR(200)
  • image_url — VARCHAR(1000) — NOT NULL
  • link_url — VARCHAR(1000)
  • position — ENUM('HOME_TOP','HOME_MID','LIST_TOP') — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • starts_at — DATETIME
  • ends_at — DATETIME

events

  • event_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • starts_at — DATETIME — NOT NULL
  • ends_at — DATETIME — NOT NULL
  • banner_url — VARCHAR(1000)
  • is_active — TINYINT(1) — NOT NULL
  • created_by — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

faqs

  • faq_id — BIGINT
  • question — VARCHAR(300) — NOT NULL
  • answer — MEDIUMTEXT — NOT NULL
  • category — VARCHAR(100)
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

favorites

  • user_id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME — NOT NULL

game_assets

  • asset_id — BIGINT
  • game_id — BIGINT — NOT NULL
  • type — ENUM('IMAGE','VIDEO') — NOT NULL
  • url — VARCHAR(1000) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

game_categories

  • category_id — BIGINT
  • name — VARCHAR(60) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

game_sessions

  • session_id — BIGINT
  • user_id — BIGINT
  • game_id — BIGINT — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME
  • score — INT
  • meta_json — JSON

game_stats

  • game_id — BIGINT
  • play_count — BIGINT — NOT NULL
  • like_count — BIGINT — NOT NULL
  • favorite_count — BIGINT — NOT NULL
  • review_count — BIGINT — NOT NULL
  • avg_rating — DECIMAL(3,2) — NOT NULL

game_tag_map

  • game_id — BIGINT — 기본 키 — NOT NULL
  • tag_id — BIGINT — 기본 키 — NOT NULL

game_tags

  • tag_id — BIGINT
  • name — VARCHAR(60) — NOT NULL

games

  • game_id — BIGINT
  • category_id — BIGINT
  • title — VARCHAR(120) — NOT NULL
  • slug — VARCHAR(140)
  • summary — VARCHAR(300)
  • description — TEXT
  • play_url — VARCHAR(1000)
  • thumbnail_url — VARCHAR(1000)
  • is_published — TINYINT(1) — NOT NULL
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

leaderboards

  • lb_id — BIGINT
  • game_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • score — INT — NOT NULL
  • rank_date — DATE — NOT NULL
  • scope — ENUM('DAILY','WEEKLY','MONTHLY','ALLTIME') — NOT NULL
  • created_at — DATETIME — NOT NULL

likes

  • user_id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME — NOT NULL

notices

  • notice_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • is_pinned — TINYINT(1) — NOT NULL
  • view_count — INT — NOT NULL
  • created_by — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT — NOT NULL
  • link_url — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL

ratings

  • rating_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • game_id — BIGINT — NOT NULL
  • score — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

reviews

  • review_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • game_id — BIGINT — NOT NULL
  • title — VARCHAR(120)
  • body — TEXT — NOT NULL
  • rating_opt — TINYINT
  • status — ENUM('VISIBLE','HIDDEN','REPORTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_notifications

  • user_id — BIGINT — 기본 키 — NOT NULL
  • notification_id — BIGINT — 기본 키 — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • read_at — DATETIME

user_profiles

  • user_id — BIGINT
  • avatar_url — VARCHAR(500)
  • bio — VARCHAR(500)
  • points — INT — NOT NULL

users

  • user_id — BIGINT
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(40)
  • role — ENUM('USER','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED','DELETED') — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL