Skip to content

item_instance Table

One row per physical item in the world: owner, enchantments, charges, durability, flags.

Schema Summary

Field Type Key Null Default Extra
guid int(10) unsigned PRI NO 0
item_id mediumint(8) unsigned MUL NO 0
owner_guid int(10) unsigned MUL NO 0
creator_guid int(10) unsigned NO 0
gift_creator_guid int(10) unsigned NO 0
count int(10) unsigned NO 1
duration int(10) NO 0
charges tinytext YES
flags mediumint(8) unsigned NO 0
enchantments text NO
random_property_id smallint(5) NO 0
durability smallint(5) unsigned NO 0
text int(10) unsigned NO 0
generated_loot tinyint(4) YES 0

Field Breakdown

  • guid - Item GUID. Referenced from character_inventory.guid, mail_items.item_guid, auction.item_guid and character_gifts.item_guid.
  • item_id - item_template.entry.
  • owner_guid - Character that currently possesses the item (characters.guid).
  • creator_guid - Character that crafted the item.
  • gift_creator_guid - Character that gift-wrapped the item.
  • count - Stack size.
  • duration - Remaining duration seconds for temp items.
  • charges - Space-separated remaining charges per charged spell.
  • flags - Item state flags (ItemDynFlags, ItemDefines.h): soulbound, wrapped/gift-wrapped, unlocked, readable…
  • enchantments - Enchantment triplets (id, duration, charges) concatenated for each slot.
  • random_property_id - Random enchant suffix id (rolled from item_enchantment_template.ench where entry = the item's random_property) chosen at creation.
  • durability - Current durability points.
  • text - Readable-book text id (from item_text.id).
  • generated_loot - Loot already rolled and stored in item_loot (rows keyed by the item's guid).