pet_aura Table

Auras persisting on pets across logout.

---

Schema Summary

Field	Type	Key	Null	Default	Extra
guid	int(11) unsigned	PRI	NO	0
caster_guid	bigint(20) unsigned	PRI	NO	0
item_guid	int(11) unsigned	PRI	NO	0
spell	int(11) unsigned	PRI	NO	0
stacks	int(11) unsigned		NO	1
charges	int(11) unsigned		NO	0
base_points0	float		NO	0
base_points1	float		NO	0
base_points2	float		NO	0
periodic_time0	int(11) unsigned		NO	0
periodic_time1	int(11) unsigned		NO	0
periodic_time2	int(11) unsigned		NO	0
max_duration	int(11)		NO	0
duration	int(11)		NO	0
effect_index_mask	tinyint(3) unsigned		NO	0

---

Field Breakdown

• guid - Primary Key. Global Unique Identifier
• caster_guid - Primary Key. Unit guid of the aura caster (the pet's own guid for self-cast auras; 0 only for system/null casters).
• item_guid - Primary Key. Item that granted the aura (proc/enchant), else 0.
• spell - Primary Key. Spell id producing this aura.
• stacks - Current stack count (refreshable auras).
• charges - Remaining proc/consumable charges.
• base_points0 - Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.
• base_points1 - Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.
• base_points2 - Rolled base points (damage/heal magnitude) per effect, overriding DBC dice.
• periodic_time0 - Tick interval in ms for periodic effects 1-3.
• periodic_time1 - Tick interval in ms for periodic effects 1-3.
• periodic_time2 - Tick interval in ms for periodic effects 1-3.
• max_duration - Total duration in ms when applied.
• duration - Remaining duration in ms at save time.
• effect_index_mask - Bitmask of active effect indexes (bit0 = effect1 …).