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 (승패 결과)