summaryrefslogtreecommitdiff
path: root/docs/mail_items.md
diff options
context:
space:
mode:
Diffstat (limited to 'docs/mail_items.md')
-rw-r--r--docs/mail_items.md83
1 files changed, 77 insertions, 6 deletions
diff --git a/docs/mail_items.md b/docs/mail_items.md
index b85cd44..3654719 100644
--- a/docs/mail_items.md
+++ b/docs/mail_items.md
@@ -1,7 +1,78 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [mail_items](mail_items)
+# mail\_items
-Column | Type | Description
---- | --- | ---
-Mail_id | int(10) unsigned |
-Item_guid | int(10) unsigned |
-Receiver | int(10) unsigned |
+`Back-to:Characters`
+
+**The \`mail\_items\` table**
+
+This table contains data regarding items from item\_instance which are being sent via email.
+
+**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="#mail_items-mail_id">mail_id</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="#mail_items-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>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#mail_items-receiver">receiver</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>Character Global Unique Identifier</p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### mail\_id
+
+Mail ID the item is attached to.
+
+### item\_guid
+
+This is the guid of the item from item\_instance.guid.
+
+### receiver
+
+Character guid which should receive this item.