summaryrefslogtreecommitdiff
path: root/docs/mail_items.md
blob: de08442e0b1d5c4b27091386782f0181b41a70c4 (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]: #mail_id
[2]: #item_guid
[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.

### receiver

Character guid which should receive this item.