...
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | Unique | NO | 0 |
| Global Unique Identifier | |
int(10) | unsigned | Unique | NO | 0 |
|
| |
tinyint(3) | unsigned | Unique | NO | 0 |
|
| |
int(10) | unsigned | PRI | NO | 0 |
| Item Global Unique Identifier |
Description of the fields
guid
The GUID of the character. See characters.guid
bag
If it isn't 0, then it is the bag's item GUID. See item_instance.guid
slot
If the bag field is non-zero, then the slot is the slot in the bag where the item is kept. The range can differ depending on the number of slots the bag has.
...
Slot # | Value |
|---|---|
0 | Head |
1 | Neck |
2 | Shoulders |
3 | Body |
4 | Chest |
5 | Waist |
6 | Legs |
7 | Feet |
8 | Wrists |
9 | Hands |
10 | Finger 1 |
11 | Finger 2 |
12 | Trinket 1 |
13 | Trinket 2 |
14 | Back |
15 | Main Hand |
16 | Off Hand |
17 | Ranged |
18 | Tabard |
19-22 | Equipped Bags |
23-38 | Main Backpack |
39-66 | Main Bank |
67-73 | Bank Bags |
86-117 | Keys in Keyring |
118-135 | Currencies (Emblems,badges,marks etc.) |
item
The item's GUID. See item_instance.guid