db

Tables (5)

Account

  • ID — String — Primary key — NOT NULL
  • Password — String — NOT NULL
  • Rune — Vector
  • Spell — Vector — NOT NULL

Character (Game)

  • ID — String — Primary key — NOT NULL
  • ID (ID2) — String — Foreign key → Account.ID — NOT NULL
  • Game — Int — NOT NULL
  • Character (Charater) — String — NOT NULL

Skill

  • Skill — Primary key — NOT NULL
  • Character — String — Foreign key → Stats.Character — NOT NULL
  • Damage — Float
  • Target — Bool — NOT NULL
  • Cost — Int
  • Cooltime — float — NOT NULL
  • Effect — Effect — NOT NULL
  • Range (LevCool) — float — NOT NULL
  • LevCost (LevDamage) — Int
  • LevCool (LevRange) — Int
  • CC — String
  • Movable — bool

Stats (Character)

  • Character — String — Primary key — NOT NULL
  • ID — Foreign key → Character.ID — NOT NULL
  • ID (ID2) — String — Foreign key → Character.ID — NOT NULL
  • Hp (HP) — Int — NOT NULL
  • CostType — String — NOT NULL
  • Skill (SkillSet) — Vector<String> — NOT NULL
  • LevHP — Float — NOT NULL
  • LevCost — Float
  • Def — Float — NOT NULL
  • Resis — Float — NOT NULL
  • LevDef — Float
  • LevRes — Float
  • AD — Float — NOT NULL
  • LevAD — Float — NOT NULL
  • Range — Int — NOT NULL
  • AS — Float — NOT NULL
  • Speed — Int — NOT NULL
  • Field (ItemSet) — Vector<String>.

Untitled (Item)

  • Key (Base) — Primary key — NOT NULL
  • ID — String — Foreign key → Character.ID — NOT NULL
  • ID (ID2) — String — Foreign key → Character.ID — NOT NULL
  • Field (ItemName) — NOT NULL
  • Field2 (Cost) — NOT NULL