트센
테이블 (3)
GAME (Untitled2)
- id (Key) — INT — 기본 키 — NOT NULL
- username1 (FK1) — INT — 외래 키 → USER.id — NOT NULL
- username2 (FK2) — INT — 외래 키 → USER.id — NOT NULL
- nickname1 (Field3)
- nickname2 (Field4)
- score1 (Field5)
- score2 (Field6)
- winner (Field7)
LOG (Untitled3)
- id (Key) — INT — 기본 키 — NOT NULL
- game_id (FK) — INT — 외래 키 → GAME.id — NOT NULL
- order (Field) — INT
- score1 (Field2) — INT
- score2 (Field3) — INT
USER (Untitled)
- id (Key) — INT — 기본 키 — NOT NULL
- username (Field)
- password (Field2)
- email (Field3)
- match_count (Field4)
- tournament_count (Field5)
- match_win_count (Field6)
- code (Field7)
- code_created_at (Field8)