pingpong

Tables (5)

Blocked (blocked)

  • id — int — Foreign key → User.id — NOT NULL

Friends (friends)

  • id — int — Foreign key → User.id — NOT NULL

Match (match)

  • id — int — Primary key — NOT NULL
  • Winner ID (wid) — int — Foreign key → User.id — NOT NULL
  • Started at (Field) — datetime — NOT NULL
  • Field2

Match log (match_log)

  • Match ID (mid) — int — Foreign key → Match.id — NOT NULL
  • Score (score) — int — NOT NULL
  • Won (Field) — bool — NOT NULL

User (user)

  • id — int — Primary key — NOT NULL
  • Email (email) — NOT NULL
  • Password (password) — NOT NULL — Hashed
  • Nickname (nickname) — NOT NULL
  • Picture (picture) — NOT NULL