npc_spells_entries

Relationships

erDiagram
    npc_spells_entries {
        int npc_spells_id
        smallintunsigned spellid
    }
    npc_spells {
        intunsigned id
        intunsigned parent_list
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    npc_spells_entries ||--o{ npc_spells : "One-to-One"
    npc_spells_entries ||--o{ spells_new : "One-to-One"

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

Schema

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