TEXT-ARENA_BE

Tables (6)

character_equipments

  • character_equipment_id — BIGINT — Primary key — NOT NULL
  • character_id — BIGINT — Foreign key → characters.character_id — NOT NULL
  • equipment_id — VARCHAR(255) — Foreign key → equipments_mongodb.equipment_id — NOT NULL

characters

  • character_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • character_name — VARCHAR(50) — NOT NULL
  • hp — INT
  • hp_reason — VARCHAR(255)
  • attack — INT
  • attack_reason — VARCHAR(255)
  • defense — INT
  • defense_reason — VARCHAR(255)
  • exp — INT
  • level — INT
  • critical_chance — DOUBLE
  • critical_chance_reason — VARCHAR(255)
  • critical_damage — DOUBLE
  • critical_damage_reason — VARCHAR(255)
  • speed — INT
  • speed_reason — VARCHAR(255)
  • dodge_chance — DOUBLE
  • dodge_chance_reason — VARCHAR(255)
  • accuracy — DOUBLE
  • accuracy_reason — VARCHAR(255)
  • wins — INT
  • losses — INT

equipment_effects_mongodb

  • equipment_effect_id — BIGINT — Primary key — NOT NULL
  • equipment_id — VARCHAR(255) — Foreign key → equipments_mongodb.equipment_id — NOT NULL
  • effect_type — VARCHAR(100)
  • effect_type_reason — VARCHAR(255)
  • chance — DOUBLE
  • duration — INT
  • bonus_increase_per_turn — INT

equipments_mongodb

  • equipment_id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • bonus_type — VARCHAR(100)
  • bonus_type_reason — VARCHAR(255)
  • bonus_value — DOUBLE
  • image_url — VARCHAR(500)

status_effects

  • status_effect_id — BIGINT — Primary key — NOT NULL
  • character_id — BIGINT — Foreign key → characters.character_id — NOT NULL
  • status_effect — VARCHAR(255) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255)