Game Review Site

Tables (3)

games

  • id — uuid — Primary key — NOT NULL
  • title — text — NOT NULL
  • genre — text — NOT NULL
  • platforms — text
  • cover_url — text
  • summary — text
  • avg_rating — numeric(2,1)
  • created_at — timestamptz

profiles

  • id — uuid — Primary key
  • email — text — NOT NULL
  • nickname — text — NOT NULL
  • birthdate — date
  • gender — text
  • created_at — timestamptz

reviews

  • id — uuid — Primary key
  • game_id — uuid
  • user_id — uuid
  • rating — int
  • content — text
  • created_at — timestamptz
  • updated_at — timestamptz