AzerothCore
item_instance
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 auction houses, in guild banks or in mails.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | PRI | NO | 0 | ||
| itemEntry | MEDIUMINT | UNSIGNED | NO | 0 | |||
| owner_guid | INT | UNSIGNED | NO | 0 | |||
| creatorGuid | INT | UNSIGNED | NO | 0 | |||
| giftCreatorGuid | INT | UNSIGNED | NO | 0 | |||
| count | INT | UNSIGNED | NO | 1 | |||
| duration | INT | SIGNED | NO | 0 | |||
| charges | TINYTEXT | SIGNED | YES | ||||
| flags | MEDIUMINT | UNSIGNED | NO | 0 | |||
| enchantments | TEXT | SIGNED | NO | ||||
| randomPropertyId | SMALLINT | SIGNED | NO | 0 | |||
| durability | SMALLINT | UNSIGNED | NO | 0 | |||
| playedTime | INT | UNSIGNED | NO | 0 | |||
| text | TEXT | SIGNED | YES |
Description of the fields
guid
The GUID of the item. This number is unique for each item instance.
itemEntry
owner_guid
The GUID of the character who has ownership of this item. See characters.guid.
creatorGuid
Characters.guid of character who created the item.
giftCreatorGuid
Characters.guid of character who created the item.
count
Current number of item copies in the stack.
duration
Time in seconds before the item disappears, for items with a limited duration. 0 if the item does not expire.
charges
The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.
flags
| Flag | Name | Description |
|---|---|---|
| 1 | ITEM_FIELD_FLAG_SOULBOUND | The item is soulbound. |
| 4 | ITEM_FIELD_FLAG_UNLOCKED | The item had a lock that has been opened. |
| 8 | ITEM_FIELD_FLAG_WRAPPED | The item is wrapped and contains another item. |
| 256 | ITEM_FIELD_FLAG_BOP_TRADEABLE | The soulbound item can still be traded for a while. |
| 512 | ITEM_FIELD_FLAG_READABLE | Right clicking the item opens a text page. |
| 4096 | ITEM_FIELD_FLAG_REFUNDABLE | The item can still be returned to the vendor. |
enchantments
Enchantments from SpellItemEnchantment.dbc see: item_instance_enchantments
randomPropertyId
The random enchantment of the item. A positive value is an ID from ItemRandomProperties.dbc, a negative value is an ID from ItemRandomSuffix.dbc. 0 if none.
durability
Current item durability.
playedTime
Time in seconds.
text
The text contained in that specific item.