Item instance tc2

Back to characters database list of tables.

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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

charges

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

flags

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

enchantments

Enchantments from SpellItemEnchantment.dbc

randomPropertyId

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

durability

Current item durability.

playedTime

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

text

The text contained in that specific item.