character_inventory

Contains all the character inventory data, including the bank data.

Structure

Field	Type	Attributes	Key	Null	Default	Comment
guid	int	unsigned	MUL	NO	0	Global Unique Identifier
bag	int	unsigned		NO	0
slot	tinyint	unsigned		NO	0
item	int	unsigned	PRI	NO	0	Item Global Unique Identifier

The guid of the character.

bag = 0: item is equipped, in basic backpack, in basic bank, on keyring or similar.
bag > 0: This is the item guid of the container where item it kept.

bag > 0: the slot in the bag where the item is kept. (0 – (ContainerSlots - 1))
bag = 0: slot from INVENTORY_SLOT_BAG_0 as described by the table below:

Slot #	Description
0	Head
1	Neck
2	Shoulders
3	Body
4	Chest
5	Waist
6	Legs
7	Feet
8	Wrists
9	Hands
10	Finger 1
11	Finger 2
12	Trinket 1
13	Trinket 2
14	Back
15	Main Hand
16	Off Hand
17	Ranged
18	Tabard
19 – 22	Bags equipped on Character
23 – 38	Main Backpack
39 – 66	Main Bank
67 – 73	Bags equipped on Bank
74 – 85	Vendor Buyback Slots
86 – 117	Keys in Keyring
118 – 149	Currencies (Emblems, Badges, Marks, etc.)

The item guid in inventory.