미니게임
테이블 (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