naengmyeon pong

Tables (6)

Copy Of Untitled (CopyOfgame_record)

  • Key (id) — number — Primary key — NOT NULL
  • Key (mode_id) — number — Foreign key → Untitled.Key — NOT NULL — 일반 모드, 가속 모드
  • Key (type_id) — number — Foreign key → Untitled.Key — NOT NULL — 일반 게임, 랭크 게임
  • Key (user_id) — string — Foreign key → Untitled.Key — NOT NULL — intra id
  • Field (상대_id) — string — NOT NULL
  • Field2 (user_score) — number — NOT NULL
  • Field3 (상대_score) — number — NOT NULL
  • Field (is_win) — boolean — NOT NULL

Untitled (user)

  • Key (id) — string — Primary key — NOT NULL — intra id
  • Field (password) — string — NOT NULL
  • Field (nickname) — string — NOT NULL
  • Field (image_path) — string — NOT NULL
  • Field (is_2fa_enabled) — boolean — NOT NULL

Untitled (signup)

  • Key (id) — string — Foreign key → Untitled.Key — NOT NULL — intra id
  • Field (is_nickname_same) — boolean — NOT NULL

Untitled (game_record)

  • Key (id) — number — Primary key — NOT NULL
  • Key (mode_id) — number — Foreign key → Untitled.Key — NOT NULL — 일반 모드, 가속 모드
  • Key (type_id) — number — Foreign key → Untitled.Key — NOT NULL — 일반 게임, 랭크 게임
  • Field (winner_id) — string — NOT NULL
  • Field (loser_id) — string — NOT NULL
  • Field2 (winner_score) — number — NOT NULL
  • Field3 (loser_score) — number — NOT NULL
  • Field (is_forfeit) — boolean — NOT NULL — 몰수승/패 여부 확인

Untitled (game_mode)

  • Key (id) — number — Primary key — NOT NULL
  • Key (mode) — string — NOT NULL — unique

Untitled (game_type)

  • Key (id) — number — Primary key — NOT NULL
  • Key (type) — string — NOT NULL — unique