ECK

Tables (6)

Champions

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • image_url (Field2)

Matches

  • id (Key) — Primary key — NOT NULL
  • schedule_date (Field)
  • status (Field2)
  • win_team (이긴 팀 번호) — ENUM

Members

  • uuid (Key) — Primary key — NOT NULL
  • id (롤 닉네임)
  • tag (롤 태그)
  • name (이름)
  • prefer_line (선호 포지션)

Participants

  • id (Key) — Primary key — NOT NULL
  • member_uuid (Key2) — Foreign key → Members.uuid — NOT NULL
  • match_id (Key3) — Foreign key → Matches.id — NOT NULL
  • line (라인) — ENUM
  • team (팀) — ENUM

Set

  • id (Key) — Primary key — NOT NULL
  • match_id (Key2) — Foreign key → Matches.id — NOT NULL
  • round (라운드)
  • image_url (게임 결과 화면)

participant_set

  • id (Key) — Primary key — NOT NULL
  • member_uuid (Key2) — Foreign key → Participants.id — NOT NULL
  • set_id (Key3) — Foreign key → Set.id — NOT NULL
  • champion_id (Key4) — Foreign key → Champions.id — NOT NULL
  • side (진영)
  • result (승패 결과)