The `pet_aura` table
Description of the fields
The GUID of the target affected by the aura. See character_pet.id
The GUID of the player who casted the aura. See characters.guid
The spell from which the aura was applied. See Spell.dbc column 1
The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2.
Determines how many stacks of the spell the character has.
The modifier value associated with the aura.
The maximum duration of the aura.
The time remaining in seconds on the aura. -1 means that the aura is indefinite.
The number of charges remaining on the aura.