GameLog-own
Tables (17)
friendships
- id — BIGINT — Primary key — NOT NULL
- requester_id — BIGINT — Foreign key → users.id — NOT NULL
- receiver_id — BIGINT — Foreign key → users.id — NOT NULL
- status — ENUM( 'PENDING', 'ACCEPTED', 'REJECTED', 'BLOCKED' ) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
game_genres
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- genre_id — BIGINT — Foreign key → genres.id — NOT NULL
game_platforms
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- platform_id — BIGINT — Foreign key → platforms.id — NOT NULL
game_series
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
game_series_games
- series_id — BIGINT — Foreign key → game_series.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
games
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- cover_image_url — VARCHAR(500)
- developer — VARCHAR(255)
- description — TEXT
- release_date — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
genres
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
platforms
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
review_comment_likes
- comment_id — BIGINT — Foreign key → review_comments.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
review_comments
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
review_reports
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.id — NOT NULL
- reporter_id — BIGINT — Foreign key → users.id — NOT NULL
- reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
reviews
- id — BIGINT — Primary key — NOT NULL
- user_game_id — BIGINT — Foreign key → user_games.id — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- content — TEXT
- is_spoiler — BOOLEAN — NOT NULL
- finish_time_hours — DECIMAL(8,2)
- master_time_hours — DECIMAL(8,2)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_favorite_games
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- display_order — INT — NOT NULL
user_games
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
- play_status — ENUM( 'PLAYED', 'COMPLETED', 'RETIRED', 'SHELVED', 'ABANDONED' ) NULL
- is_playing — BOOLEAN — NOT NULL
- is_backlog — BOOLEAN — NOT NULL
- is_wishlist — BOOLEAN — NOT NULL
- is_liked — BOOLEAN — NOT NULL
- platform_id — BIGINT — Foreign key → platforms.id
- play_time_hours — DECIMAL(8,2)
- started_at — DATE
- completed_at — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_preference_games
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- game_id — BIGINT — Foreign key → games.id — NOT NULL
user_preference_genres
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- genre_id — BIGINT — Foreign key → genres.id — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- bio — VARCHAR(255)
- onboarding_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL