====== item_instance 表 ======
----
[[数据库:characters数据库:首页|<-返回:Characters 数据库]]

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|guid]]|INT|UNSIGNED|PRI|NO|0| | |
|[[#itemEntry|itemEntry]]|MEDIUMINT|UNSIGNED| |NO|0| | |
|[[#owner_guid|owner_guid]]|INT|UNSIGNED| |NO|0| | |
|[[#creatorGuid|creatorGuid]]|INT|UNSIGNED| |NO|0| | |
|[[#giftCreatorGuid|giftCreatorGuid]]|INT|UNSIGNED| |NO|0| | |
|[[#count|count]]|INT|UNSIGNED| |NO|1| | |
|[[#duration|duration]]|INT|SIGNED| |NO|0| | |
|[[#charges|charges]]|TINYTEXT|SIGNED| |YES| | | |
|[[#flags|flags]]|MEDIUMINT|UNSIGNED| |NO|0| | |
|[[#enchantments|enchantments]]|TEXT|SIGNED| |NO| | | |
|[[#randomPropertyId|randomPropertyId]]|SMALLINT|SIGNED| |NO|0| | |
|[[#durability|durability]]|SMALLINT|UNSIGNED| |NO|0| | |
|[[#playedTime|playedTime]]|INT|UNSIGNED| |NO|0| | |
|[[#text|text]]|TEXT|SIGNED| |YES| | | |



===== 字段说明 =====
----
==== guid ====

物品的 GUID。此编号对于每个物品实例都是唯一的。

==== itemEntry ====

[[数据库:world数据库:item_template#entry|Item_template.entry]].

==== owner_guid ====

拥有此物品所有权的角色的 GUID。 See [[characters#guid|characters.guid]].

==== creatorGuid ====

创建物品的角色 GUID。See [[characters#guid|characters.guid]].

==== giftCreatorGuid ====

Characters.guid of character who created the item.

==== count ====

当前物品的数量（弹药、施法材料堆叠的数量）。
==== duration ====

物品的持续时间（单位：秒），<color #ed1c24>下线后仍然计时？？？？</color>，时间结束后物品会消失。

==== 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 ====

随机属性的 id。

==== durability ====

物品剩余的耐久度（耐久度等于0时，需要修理才能使用）。

==== playedTime ====

已使用的时间（单位：秒）

==== text ====

The text contained in that specific item.