HK_server

Tables (4)

pick_result

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → room.id — NOT NULL
  • player_id — BIGINT — Foreign key → player.id — NOT NULL
  • item_id — VARCHAR(255) — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

player

  • id — BIGINT — Primary key — NOT NULL
  • player_id — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • profile_image_key — VARCHAR(255)
  • room_id — BIGINT — Foreign key → room.id — NOT NULL
  • created_at — DATETIME — NOT NULL

room

  • id — BIGINT — Primary key — NOT NULL
  • room_code — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • message_sequence — BIGINT — NOT NULL

room_message

  • id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → room.id — NOT NULL
  • player_id — BIGINT — Foreign key → player.id — NOT NULL
  • sequence — BIGINT — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL