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