RPG

Tables (5)

Dungeon (Untitled2)

  • dungeon_id (Key) — Primary key — NOT NULL
  • level_requirement (Field)
  • Field2

Item (Untitled5)

  • item_id (Key) — Primary key — NOT NULL
  • Nickname (Key2) — Foreign key → Player.Nickname — NOT NULL
  • name (Field)
  • effect (Field2)
  • price (Field3)

Monster (Untitled3)

  • monster_id (Key) — Primary key — NOT NULL
  • dungeon_id (Key2) — Foreign key → Dungeon.dungeon_id — NOT NULL
  • health (Field)
  • attack (Field2)
  • defense (Field3)
  • level (Field4)
  • experience_reward (Field5)

Player (Untitled)

  • Nickname (Key) — Primary key — NOT NULL
  • level (Field3)
  • health (Field)
  • now_experience (Field2)
  • attack (Field5)
  • defense (Field6)
  • total_experience (Field7)
  • money (Field4)

Shop (Untitled4)

  • shop_id (Key) — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → Item.item_id — NOT NULL
  • Nickname (Key22) — Foreign key → Item.Nickname — NOT NULL
  • price (Field2)