트센

테이블 (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)