Back-to:Characters
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 |
int(10) |
unsigned |
PRI |
NO |
0 |
|
|
|
mediumint(8) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
1 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
tinytext |
signed |
|
YES |
|
|
|
|
mediunint(8) |
unsigned |
|
NO |
0 |
|
|
|
text |
signed |
|
NO |
|
|
|
|
smallint(5) |
signed |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
text |
signed |
|
YES |
|
|
|
Description of the fields
guid
The GUID of the item. This number is unique for each item instance.
itemEnry
Item entry.
owner_guid
The GUID of the character who has ownership of this item. See characters.guid
creatorGuid
GUID of character who created the item.
giftCreatorGuid
GUID of character who created the item.
count
Current number of item copies in the stack.
duration
field-no-description|6
charges
field-no-description|7
flags
field-no-description|8
enchantments
Enchantments from SpellItemEnchantment.dbc
randomPropertyId
field-no-description|10
durability
Current item durability.
playedTime
field-no-description|11
text
The text contained in that specific item.