Back-to:Characters
The `pet_aura` table
table-no-description
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
|
NO |
0 |
|
Global Unique Identifier |
|
bigint(20) |
unsigned |
|
NO |
0 |
|
Full Global Unique Identifier |
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
1 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
mediumint(8) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
int(11) |
signed |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
guid
The GUID of the target affected by the aura. See character_pet.id
caster_guid
The GUID of the player who casted the aura. See characters.guid
spell
The spell from which the aura was applied. See Spell.dbc column 1
effect_mask
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.
recalculate_mask
field-no-description|5
stackcount
Determines how many stacks of the spell the character has.
amount
The modifier value associated with the aura.
base_amount
field-no-description|8
maxduration
The maximum duration of the aura.
remaintime
The time remaining in seconds on the aura. -1 means that the aura is indefinite.
remaincharges
The number of charges remaining on the aura.