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