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