bot_spells_entries

Relationships

erDiagram
    bot_spells_entries {
        varchar type
        varchar npc_spells_id
        varchar spell_id
        varchar spellid
    }
    npc_spells {
        intunsigned id
        intunsigned parent_list
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    bot_spells_entries ||--o{ npc_spells : "One-to-One"
    bot_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	spell_id	spells_new	id

Schema

Column	Data Type	Description
id	int	Unique Bot Spell Entry Identifier
npc_spells_id	int	Bot Spell List Identifier
spellid	smallint	Spell Identifier
type	int	Spell Type
minlevel	tinyint	Minimum Level
maxlevel	tinyint	Maximum Level
manacost	smallint	Mana Cost
recast_delay	int	Recast Delay
priority	smallint	Bot Spell Priority: Lower is better
resist_adjust	int	Resist Adjustment
min_hp	smallint	Minimum Health Percentage
max_hp	smallint	Maximum Health Percentage
bucket_name	varchar	Bucket Name
bucket_value	varchar	Bucket Value
bucket_comparison	tinyint	Bucket Comparison