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