item_instance

Back-to:Characters

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 auctionhouses, in guild banks or in mails.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO	0
itemEntry	mediumint(8)	unsigned		NO	0
owner_guid	int(10)	unsigned		NO	0
creatorGuid	int(10)	unsigned		NO	0
giftCreatorGuid	int(10)	unsigned		NO	0
count	int(10)	unsigned		NO	1
duration	int(10)	unsigned		NO	0
charges	tinytext	signed		YES
flags	mediunint(8)	unsigned		NO	0
enchantments	text	signed		NO
randomPropertyId	smallint(5)	signed		NO	0
durability	smallint(5)	unsigned		NO	0
playedTime	int(10)	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.

itemEnry

Item entry.

owner_guid

The GUID of the character who has ownership of this item. See characters.guid

creatorGuid

GUID of character who created the item.

giftCreatorGuid

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

randomPropertyId

field-no-description|10

durability

Current item durability.

playedTime

Time in seconds

text

The text contained in that specific item.

data-anchor=