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)