lol

Tables (6)

Match (Untitled)

  • matchId (VARCHAR(20)) — VARCHAR(20) — Primary key — NOT NULL
  • patchId (BIGINT) — BIGINT — Foreign key → Patch.id — NOT NULL

Participant (Untitled3)

  • id (BIGINT) — BIGINT — Primary key — NOT NULL
  • matchId (VARCHAR(20)) — VARCHAR(20) — Foreign key → Match.matchId — NOT NULL
  • puuid (VARCHAR(80)) — VARCHAR(80) — Foreign key → User.puuid — NOT NULL

Patch (Untitled5)

  • id (BIGINT) — BIGINT — Primary key — NOT NULL
  • patchVersion (VARCHAR(10)) — VARCHAR(10)
  • server (VARCHAR(8)) — VARCHAR(10)

Pro (Untitled4)

  • id (bigint(20)) — BIGINT — Primary key — NOT NULL
  • name (VARCHAR(30)) — VARCHAR(30)

User (Untitled2)

  • puuid (VARCHAR(80)) — VARCHAR(80) — Primary key — NOT NULL
  • proId (BIGINT) — BIGINT — Foreign key → Pro.id — NOT NULL

puuid_to_matchIds(VO) (Untitled6)

  • puuid (VARCHAR(80)) — VARCHAR(80) — Foreign key → User.puuid — NOT NULL
  • matchIds (JSON)
  • match_counts (INT)