미니게임

테이블 (20)

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

board_categories

  • category_id — BIGINT
  • code — ENUM('NOTICE','GUIDE','FINDER','FREE') — NOT NULL
  • name — VARCHAR(60) — NOT NULL
  • 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
  • duration_s — INT
  • score — INT

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
  • uploader_id — BIGINT — NOT NULL
  • category_id — BIGINT
  • title — VARCHAR(120) — NOT NULL
  • slug — VARCHAR(140)
  • summary — VARCHAR(300)
  • description — MEDIUMTEXT
  • 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

likes

  • user_id — BIGINT — 기본 키 — NOT NULL
  • game_id — BIGINT — 기본 키 — NOT NULL
  • created_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

post_comments

  • comment_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • body — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_likes

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

posts

  • post_id — BIGINT
  • category_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • view_count — INT — NOT NULL
  • is_pinned — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • FULLTEXT — KEY

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
  • 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)

users

  • user_id — BIGINT
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • 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