MyServer

Tables (3)

CharacterInfoData

  • id — INT — NOT NULL
  • characterID — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • basicSkillId — INT — NOT NULL
  • prefabName — VARCHAR(100) — NOT NULL
  • basicSkinId — INT — Foreign key → PortraitData.id — NOT NULL

CharacterTrait

  • id — INT — NOT NULL
  • characterInfoId — INT — Foreign key → CharacterInfoData.id — NOT NULL
  • traitValue — VARCHAR(100) — NOT NULL

PortraitData

  • id — INT — NOT NULL
  • characterID — VARCHAR(50) — Foreign key → CharacterInfoData.characterID — NOT NULL
  • characterName — VARCHAR(100) — NOT NULL
  • characterType — TINYINT — NOT NULL — 0=Base, 1=Skin
  • sprite — VARCHAR(100) — NOT NULL
  • locked — VARCHAR(100) — NOT NULL
  • localizeKey — VARCHAR(100) — NOT NULL
  • loreSprite — VARCHAR(100) — NOT NULL