character_inventory Table

Every item a character carries: bag/slot mapping from item_instance.

---

Schema Summary

Field	Type	Key	Null	Default	Extra
guid	int(11) unsigned	MUL	NO	0
bag	int(11) unsigned		NO	0
slot	tinyint(3) unsigned		NO	0
item_guid	int(11) unsigned	PRI	NO	0
item_id	int(11) unsigned		NO	0

---

Field Breakdown

• guid - Character owning the item (characters.guid).
• bag - Container item guid; 0 whenever the item sits directly on the player (equipment 0-18, bags 19-22, backpack 23-38, bank main slots 39-62, bank bag slots 63-68, keyring 81+).
• slot - Slot inside the container or equipment slot on the paperdoll.
• item_guid - Primary Key. Item Global Unique Identifier
• item_id - Item Identifier