diff options
Diffstat (limited to 'docs/mail_items.md')
| -rw-r--r-- | docs/mail_items.md | 83 |
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. |
