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