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