BRPG ERD
Tables (11)
Boss
- boss_id — INT — Primary key — NOT NULL
- dungeon_id — INT — Foreign key → Dungeon.dungeon_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- level — INT
- hp — INT
- attack — INT
- reward_exp — INT
- reward_gold — INT
- reward_item_id — INT — Foreign key → Item.item_id
Character_Skill
- character_skill_id — INT — Primary key — NOT NULL
- character_id — INT — Foreign key → Characters.character_id — NOT NULL
- skill_id — INT — Foreign key → Skill.skill_id — NOT NULL
- level — INT
Characters
- character_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- level — INT
- exp — INT
- hp — INT
- attack — INT
- defense — INT
- tier — VARCHAR(30)
- trophy — INT
Dungeon
- dungeon_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- required_level — INT
Equipment
- equipment_id — INT — Primary key — NOT NULL
- character_id — INT — Foreign key → Characters.character_id — NOT NULL
- item_id — INT — Foreign key → Item.item_id — NOT NULL
- type — VARCHAR(30)
- level — INT
Inventory
- inventory_id — INT — Primary key — NOT NULL
- character_id — INT — Foreign key → Characters.character_id — NOT NULL
- item_id — INT — Foreign key → Item.item_id — NOT NULL
- quantity — INT
Item
- item_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — VARCHAR(30)
- description — TEXT
Matches
- match_id — INT — Primary key — NOT NULL
- character1_id — INT — Foreign key → Characters.character_id — NOT NULL
- character2_id — INT — Foreign key → Characters.character_id — NOT NULL
- winner_id — INT — Foreign key → Characters.character_id
- match_date — DATETIME
Monster
- monster_id — INT — Primary key — NOT NULL
- dungeon_id — INT — Foreign key → Dungeon.dungeon_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- level — INT
- hp — INT
- attack — INT
- reward_exp — INT
- reward_gold — INT
- reward_item_id — INT — Foreign key → Item.item_id
Skill
- skill_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — VARCHAR(30)
- damage — INT
- cooldown — INT
- description — TEXT
Users
- user_id — INT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- created_at — DATETIME