Item instance tc2

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
Item instance tc2	int(10)	unsigned	PRI	NO	0
itemEntry	mediumint(8)	unsigned		NO	0
Item instance tc2	int(10)	unsigned		NO	0
Item instance tc2	int(10)	unsigned		NO	0
Item instance tc2	int(10)	unsigned		NO	0
Item instance tc2	int(10)	unsigned		NO	1
Item instance tc2	int(10)	unsigned		NO	0
Item instance tc2	tinytext	signed		YES
Item instance tc2	mediunint(8)	unsigned		NO	0
Item instance tc2	text	signed		NO
Item instance tc2	smallint(5)	signed		NO	0
Item instance tc2	smallint(5)	unsigned		NO	0
Item instance tc2	int(10)	unsigned		NO	0
Item instance tc2	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.