1 files changed, 244 insertions, 20 deletions
diff --git a/docs/character_aura.md b/docs/character_aura.md
index 048b285..ade1c23 100644
--- a/docs/character_aura.md
+++ b/docs/character_aura.md
@@ -1,20 +1,244 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_aura](character_aura)
-
-Column | Type | Description
---- | --- | ---
-Guid | int(10) unsigned | 
-CasterGuid | bigint(20) unsigned | 
-ItemGuid | bigint(20) unsigned | 
-Spell | mediumint(8) unsigned | 
-EffectMask | tinyint(3) unsigned | 
-RecalculateMask | tinyint(3) unsigned | 
-StackCount | tinyint(3) unsigned | 
-Amount0 | int(11) | 
-Amount1 | int(11) | 
-Amount2 | int(11) | 
-Base_amount0 | int(11) | 
-Base_amount1 | int(11) | 
-Base_amount2 | int(11) | 
-MaxDuration | int(11) | 
-RemainTime | int(11) | 
-RemainCharges | tinyint(3) unsigned | 
+# character\_aura
+
+`Back-to:Characters`
+
+**The \`character\_aura\` table**
+
+Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects.
+
+**Structure**
+
+<table>
+<colgroup>
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+</colgroup>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-guid">guid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p>Global Unique Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-caster_guid">caster_guid</a></p></td>
+<td><p>bigint(20)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p>Full Global Unique Identifier</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-item_guid">item_guid</a></p></td>
+<td><p>bigint(20)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-spell">spell</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-effect_mask">effect_mask</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-recalculate_mask">recalculate_mask</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-stackcount">stackcount</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>1</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-amount">amount0</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-amount">amount1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-amount">amount2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-base_amount">base_amount0</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-base_amount">base_amount1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-base_amount">base_amount2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-maxduration">maxduration</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#character_aura-remaintime">remaintime</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#character_aura-remaincharges">remaincharges</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+The GUID of the target affected by the aura. See characters.guid
+
+### caster\_guid
+
+The GUID of the player who casted the aura. See characters.guid
+
+### item\_guid
+
+The GUID of the item which casted the aura. See item\_instance.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 in ms.
+
+### remaintime
+
+The time remaining in ms on the aura. -1 means that the aura is indefinite.
+
+### remaincharges
+
+The number of charges remaining on the aura.