ssss

Tables (9)

auth

  • auth_id — BIBINT — Primary key — NOT NULL
  • id — BIGINT — Foreign key → member.id
  • token_type — VARCHAR(20)
  • access_token — VARCHAR(20)
  • refresh_token — VARCHAR(20)
  • created_at — TIMESAMP
  • updated_at — TIMESTAMP

charactor_info

  • charecter_id — BIGINT — Primary key — NOT NULL
  • id — BIGINT — Foreign key → member.id
  • level — BIGINT
  • hp — BIGINT
  • mp — BIGINT
  • str — BIGINT
  • vit — BIGINT
  • int — BIGINT
  • wis — BIGINT
  • dex — BIGINT
  • lux — BIGINT
  • physical_ — Attack"
  • magic_ — Attack"

chat_room

  • id — BIGINT
  • title — TEXT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • is_private — BOOLEAN
  • created_at — TIMESTAMP

chat_room_member

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • chat_room_id — BIGINT — NOT NULL
  • joined_at — TIMESTAMP

dice_result

  • id — BIGINT
  • turn_id — BIGINT — NOT NULL
  • dice_type — TEXT
  • value — INT
  • rolled_at — TIMESTAMP

game

  • id — BIGINT
  • room_id — BIGINT — NOT NULL
  • gm_id — BIGINT — NOT NULL
  • status — TEXT
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP

member

  • id — BIGINT
  • username — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • nickname — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

race_skills

  • skill_id — BIGINT — Primary key — NOT NULL
  • skill_name — TEXT
  • Field — VARCHAR(255)

turn_log

  • id — BIGINT
  • game_id — BIGINT — NOT NULL
  • player_id — BIGINT — NOT NULL
  • turn_index — INT
  • action_text — TEXT
  • result_summary — TEXT
  • created_at — TIMESTAMP