# pet\_aura [<-Back-to:Characters](database-characters.md) **The \`pet\_aura\` table** `table-no-description` **Structure**

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

 

NO

0

 

Global Unique Identifier

caster_guid

bigint(20)

unsigned

 

NO

0

 

Full Global Unique Identifier

spell

mediumint(8)

unsigned

 

NO

0

 

 

effect_mask

tinyint(3)

unsigned

 

NO

0

 

 

recalculate_mask

tinyint(3)

unsigned

 

NO

0

 

 

stackcount

tinyint(3)

unsigned

 

NO

1

 

 

amount0

mediumint(8)

signed

 

NO

0

 

 

amount1

mediumint(8)

signed

 

NO

0

 

 

amount2

mediumint(8)

signed

 

NO

0

 

 

base_amount0

mediumint(8)

signed

 

NO

0

 

 

base_amount1

mediumint(8)

signed

 

NO

0

 

 

base_amount2

mediumint(8)

signed

 

NO

0

 

 

maxduration

int(11)

signed

 

NO

0

 

 

remaintime

int(11)

signed

 

NO

0

 

 

remaincharges

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.