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)