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.
表结构
| 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 |
物品的 GUID。此编号对于每个物品实例都是唯一的。
拥有此物品所有权的角色的 GUID。 See characters.guid.
创建物品的角色 GUID。See characters.guid.
Characters.guid of character who created the item.
当前物品的数量（弹药、施法材料堆叠的数量）。
物品的持续时间（单位：秒），下线后仍然计时？？？？，时间结束后物品会消失。
The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.
field-no-description|8
Enchantments from SpellItemEnchantment.dbc see: item_instance_enchantments
随机属性的 id。
物品剩余的耐久度（耐久度等于0时，需要修理才能使用）。
已使用的时间（单位：秒）
The text contained in that specific item.