summaryrefslogtreecommitdiff
path: root/docs/item_refund_instance.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/item_refund_instance.md')
-rw-r--r--docs/item_refund_instance.md100
1 files changed, 92 insertions, 8 deletions
diff --git a/docs/item_refund_instance.md b/docs/item_refund_instance.md
index 22ff069..566cd46 100644
--- a/docs/item_refund_instance.md
+++ b/docs/item_refund_instance.md
@@ -1,8 +1,92 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [item_refund_instance](item_refund_instance)
-
-Column | Type | Description
---- | --- | ---
-Item_guid | int(10) unsigned |
-Player_guid | int(10) unsigned |
-PaidMoney | int(10) unsigned |
-PaidExtendedCost | smallint(5) unsigned |
+# item\_refund\_instance
+
+`Back-to:Characters`
+
+**The \`item\_refund\_instance\` table**
+
+This table serves as a receipt of refundable purchases during a 2 hour ingame time window. It holds information on what currency was spent to purchase the item.
+
+**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="#item_refund_instance-item_guid">item_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> </p></td>
+<td><p>Unique</p></td>
+<td><p>Item GUID</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#item_refund_instance-player_guid">player_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> </p></td>
+<td><p> </p></td>
+<td><p>Player GUID</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#item_refund_instance-paidMoney">paidMoney</a></p></td>
+<td><p>int(10)</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="odd">
+<td><p><a href="#item_refund_instance-paidExtendedCost">paidExtendedCost</a></p></td>
+<td><p>smallint(5)</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**
+
+### item\_guid
+
+The GUID of the item bought by the vendor. See item\_instance.guid.
+
+### player\_guid
+
+The GUID of the player eligible for the refund. See characters.guid.
+
+### paidMoney
+
+The amount of money (in copper) paid for the item.
+
+### paidExtendedCost
+
+The ItemExtendedCost.dbc ID that was paid for the item.