scrimmanager
테이블 (10)
Copy Of Untitled (match_stats)
- Key (id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
- Key (game_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(40) — NOT NULL
- Field (value) — int — NOT NULL
Untitled (group_member)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (name) — varchar(40)
- Field (permission) — int — NOT NULL
- Field (in_game_id) — varchar(40)
- Key (group_id) — varchar(40) — 외래 키 → 그룹.Key — NOT NULL
- Key (user_id) — varchar(40) — 외래 키 → user.Key — NOT NULL
Untitled (group_member_position)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (position) — varchar(40)
- Field (elo) — int — NOT NULL
- Key (group_member_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (match)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (date) — date
- Field (winning_team) — varchar(40)
- Key (match_type) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (group_id) — varchar(40) — 외래 키 → 그룹.Key — NOT NULL
- Key (game_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (match_member)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (team) — varchar(40) — NOT NULL
- Field (elo_delta) — int — NOT NULL
- Key (match_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
- Key (group_member_position_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (match_type)
- Key (index) — int — 기본 키 — NOT NULL
- Field (match_type) — varchar(40) — NOT NULL
Untitled (statistics)
- Key (id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
- Key (game_id) — varchar(40) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(40) — NOT NULL
- Field (value) — int — NOT NULL
Untitled (game_name)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (name) — varchar(40)
user
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (name) — varchar(40)
- Field (discord_id) — varchar(20)
그룹 (scrim_group)
- Key (id) — varchar(40) — 기본 키 — NOT NULL
- Field (name) — varchar(40) — NOT NULL
- Field (is_private) — int — NOT NULL
- Key (user_id) — varchar(40) — 외래 키 → user.Key — NOT NULL
- Field (discord_guild_id) — varchar(20)