这是本文档旧的修订版！
目录
item_instance 表
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。此编号对于每个物品实例都是唯一的。
itemEntry
owner_guid
拥有此物品所有权的角色的 GUID。 See characters.guid.
creatorGuid
Characters.guid of character who created the item. 创建物品的角色 GUID。see
giftCreatorGuid
Characters.guid of character who created the item.
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 see: item_instance_enchantments
randomPropertyId
field-no-description|10
durability
Current item durability.
playedTime
Time in seconds.
text
The text contained in that specific item.