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)