blob: f3fbd25f337b3f82305c797ade146b18019320cd (
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
# item\_instance
[<-Back-to:Characters](database-characters.md)
**The \`item\_instance\` table**
This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auctionhouses, in guild banks or in mails.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------------|--------------|------------|-----|------|---------|-------|---------|
| [guid][1] | INT | UNSIGNED | PRI | NO | | | |
| [itemEntry][2] | MEDIUMINT | UNSIGNED | | NO | | | |
| [owner_guid][3] | INT | UNSIGNED | | NO | | | |
| [creatorGuid][4] | INT | UNSIGNED | | NO | | | |
| [giftCreatorGuid][5] | INT | UNSIGNED | | NO | | | |
| [count][6] | INT | UNSIGNED | | NO | | | |
| [duration][7] | INT | UNSIGNED | | NO | | | |
| [charges][8] | tinytext | | | YES | NULL | | |
| [flags][9] | mediunint(8) | UNSIGNED | | NO | | | |
| [enchantments][10] | text | | | NO | | | |
| [randomPropertyId][11] | SMALLINT | SIGNED | | NO | | | |
| [durability][12] | SMALLINT | UNSIGNED | | NO | | | |
| [playedTime][13] | INT | UNSIGNED | | NO | | | |
| [text][14] | text | | | YES | NULL | | |
[1]: #guid
[2]: #itementry
[3]: #owner_guid
[4]: #creatorguid
[5]: #giftcreatorguid
[6]: #count
[7]: #duration
[8]: #charges
[9]: #flags
[10]: #enchantments
[11]: #randompropertyid
[12]: #durability
[13]: #playedtime
[14]: #text
**Description of the fields**
### guid
The GUID of the item. This number is unique for each item instance.
### itemEnry
[Item](item_template_2130222.html#item_template-entry) entry.
### owner\_guid
The GUID of the character who has ownership of this item. See [characters.guid](2129969.html#characters(table)-guid)
### creatorGuid
[GUID](2129969.html#characters(table)-guid) of character who created the item.
### giftCreatorGuid
[GUID](2129969.html#characters(table)-guid) of character who created the [item](character_gifts_2129986.html#character_gifts-item_guid).
### count
Current number of item copies in the stack.
### duration
`field-no-description|6`
### charges
`The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.`
### flags
`field-no-description|8`
### enchantments
Enchantments from SpellItemEnchantment.dbc
### randomPropertyId
`field-no-description|10`
### durability
Current item durability.
### playedTime
Time in seconds
### text
The text contained in that specific item.
data-anchor=
|
