Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One npc_spells_id npc_spells id
One-to-One spellid spells_new id


Column Data Type Description
id int Unique NPC Spell Entry Identifier
npc_spells_id int Unique NPC Spell Set Identifier
spellid smallint Spell Identifier
type int Spell Type Bitmask
minlevel tinyint Minimum Level
maxlevel tinyint Maximum Level
manacost smallint Mana Cost
recast_delay int Recast Delay
priority smallint Priority: 0 = Innate, 1 = Highest Priority, 5 = Lower Priority, 10 = Even Lower Priority
resist_adjust int Resist Adjustment
min_hp smallint Minimum Health Percentage
max_hp smallint Maximum Health Percentage