2-project

Tables (6)

game_genres

  • id — BIGINT — Primary key — NOT NULL
  • game_id — BIGINT — Foreign key → games.id — NOT NULL
  • genre_id — BIGINT — Foreign key → genres.id — NOT NULL

game_libraries

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • game_id — BIGINT — Foreign key → games.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • platform — VARCHAR(30)
  • started_at — DATE
  • completed_at — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

games

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • release_date — DATE
  • image_url — VARCHAR(1000)
  • developer — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

genres

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

reviews

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • game_id — BIGINT — Foreign key → games.id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL