naengmyeon pong
Tables (11)
ban
- id — number — Primary key — NOT NULL
- room_id — number — Foreign key → room.id — NOT NULL
- user_id — string — Foreign key → user.id — NOT NULL — intra id
block_list
- userId — string — Foreign key → user.id — NOT NULL — intra id
- blockId — string — Foreign key → user.id — NOT NULL — intra id
directmessage
- id — number — Primary key — NOT NULL
- userId — string — Foreign key → user.id — NOT NULL — intra id
- someoneId — string — Foreign key → user.id — NOT NULL — intra id
- date — date — NOT NULL — message 온 시간
- message — string — NOT NULL — 1:1 message
- block — string — block 된 사람id
game_mode
- id — number — Primary key — NOT NULL
- mode — string — NOT NULL — unique
game_record
- id — number — Primary key — NOT NULL
- mode_id — number — Foreign key → game_mode.id — NOT NULL — 일반 모드, 가속 모드
- type_id — number — Foreign key → game_type.id — NOT NULL — 일반 게임, 랭크 게임
- user_id — string — Foreign key → user.id — NOT NULL — intra id
- winner_id — string — NOT NULL
- loser_id — string — NOT NULL
- winner_score — number — NOT NULL
- loser_score — number — NOT NULL
- is_forfeit — boolean — NOT NULL — 몰수승/패 여부 확인
game_type
- id — number — Primary key — NOT NULL
- type — string — NOT NULL — unique
members
- id — number — Primary key — NOT NULL
- room_id — number — Foreign key → room.id — NOT NULL
- user_id — string — Foreign key → user.id — NOT NULL — intra id
- permission — number — NOT NULL — user:0 admin:1 owner:2
- mute — date
room
- id — number — Primary key — NOT NULL
- name — string — NOT NULL
- current_nums — number — NOT NULL
- max_nums — number — NOT NULL
- is_public — boolean — NOT NULL
- is_password — boolean — NOT NULL
- password — string
signup
- id — string — Foreign key → user.id — NOT NULL — intra id
- is_nickname_same — boolean — NOT NULL
socket_id
- user_id — string — Foreign key → user.id — NOT NULL — PK, intra_id
- socket_id — string — NOT NULL
user
- id — string — Primary key — NOT NULL — intra id
- password — string — NOT NULL
- nickname — string — NOT NULL
- image_path — string — NOT NULL
- is_2fa_enabled — boolean — NOT NULL
- rank_score — number — NOT NULL