CamON-Redis

테이블 (19)

... : round : {n} : attack (닌자 공격 정보)

  • HASH (attacker_token) — VARCHAR
  • (target_token) — VARCHAR
  • (skill_id) — INT
  • (judged_at) — INT

... : round : {n} : guesses (몸으로 말해요 정답)

  • ZSET (member) — VARCHAR
  • (score) — BIGINT

... : round : {n} : results (라운드 점수)

  • HASH (guest_token) — VARCHAR
  • (score) — INT

... : round : {n} : submissions (물건 가져오기 제출)

  • ZSET (member) — VARCHAR
  • (score) — BIGINT

... : session : {seq} : alive_players (닌자 생존자)

  • SET (member) — VARCHAR

... : session : {seq} : eliminated (닌자 탈락 순서)

  • ZSET (member) — VARCHAR
  • (score) — BIGINT

... : session : {seq} : player_hp (닌자 체력)

  • HASH (guest_token) — VARCHAR
  • (hp) — INT

... : session : {seq} : round : {n} (진행 중인 라운드)

  • HASH (mission_id) — INT
  • (skill_id) — INT
  • (presenter_token) — VARCHAR
  • (started_at) — BIGINT
  • (closed) — VARCHAR

... : session : {seq} : skill_order (CopyOf닌자 체력)

  • LIST (element) — INT

... : session : {seq} : totals (게임 누적 점수)

  • HASH (guest_token) — INT
  • (score) — INT

Key 패턴 (설명)

  • 자료구조 (컬럼1) — 타입
  • (컬럼2) — 타입
  • (컬럼 3) — 타입

room : {code} (방 정보)

  • HASH (host_token) — VARCHAR
  • (max_players) — INT
  • (course_length) — INT
  • (current_session_seq) — INT
  • (created_at) — BIGINT

room : {code} : course : totals (코드 전체 누적)

  • HASH (guest_token) — VAR_CHAR
  • (score) — INT

room : {code} : course : {idx} (코스 정보)

  • HASH (game_id) — INT
  • (round_count) — INT

room : {code} : nicknames (닉네임 중복 체크)

  • SET (member) — VARCHAR

room : {code} : participant : {token} (참가자 상세)

  • HASH (nickname) — VARCHAR
  • (connection_status) — VARCHAR
  • (ready) — BOOLEAN
  • (joined_at) — BIGINT

room : {code} : participants (방 참가자 목록)

  • SET (member) — VARCHAR

room : {code} : session: {seq} (진행 중인 세션)

  • HASH (game_id) — INT
  • (total_rounds) — INT
  • (current_round) — INT

session : {token} : alive (하트비트)

  • STRING (value) — INT