这是本文档旧的修订版！
目录
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
创建物品的角色 GUID。See characters.guid.
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.