...
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.