GameLog
Tables (11)
game
- id — BIGINT — Primary key — NOT NULL
- igdb_game_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- cover_image_url — VARCHAR(500)
- developer — VARCHAR(100)
- release_date — DATE
- summary — TEXT
- avg_rating — DECIMAL(2,1)
- review_count — INT
- played_count — INT
- playing_count — INT
- backlog_count — INT
- wishlist_count — INT
game_genre
- id — BIGINT — Primary key — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
- genre_id — BIGINT — Foreign key → genre.id — NOT NULL
game_library
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
- platform_id — BIGINT — Foreign key → platform.id
- status — VARCHAR(20) — NOT NULL — WISHLIST, BACKLOG, PLAYING, PLAYED, DROPPED
- is_favorite — BOOLEAN
- started_at — DATE
- completed_at — DATE
- play_time — INT
- updated_at — DATETIME
game_like
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
- created_at — DATETIME
game_platform
- id — BIGINT — Primary key — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
- platform_id — BIGINT — Foreign key → platform.id — NOT NULL
genre
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20)
- bio — VARCHAR(255)
- profile_image_url — VARCHAR(500)
- preferred_player_count — VARCHAR(20)
- created_at — DATETIME
member_preference_game
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
member_preference_genre
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- genre_id — BIGINT — Foreign key → genre.id — NOT NULL
platform
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- code — VARCHAR(20) — NOT NULL
review
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- game_id — BIGINT — Foreign key → game.id — NOT NULL
- game_library_id — BIGINT — Foreign key → game_library.id — NOT NULL
- rating — DECIMAL(2,1) — NOT NULL
- content — TEXT
- has_spoiler — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME