summaryrefslogtreecommitdiff
path: root/docs/mail_items.md
blob: e5bd3d7f58128107fe094810522888479c421025 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
# mail\_items

[<-Back-to:Characters](database-characters.md)

**The \`mail\_items\` table**

This table contains data regarding items from item\_instance which are being sent via email.

**Structure**

| Field          | Type | Attributes | Key | Null | Default | Extra | Comment                            |
| -------------- | ---- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- |
| [mail_id][1]   | INT  | UNSIGNED   |     | NO   | 0       |       |                                    |
| [item_guid][2] | INT  | UNSIGNED   | PRI | NO   | 0       |       |                                    |
| [receiver][3]  | INT  | UNSIGNED   |     | NO   | 0       |       | Character Global Unique Identifier |

[1]: #mailid
[2]: #itemguid
[3]: #receiver

**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](item_instance#guid).

### receiver

Character guid which should receive this item.