Guild_bank_item

Back to characters database list of tables.

The `guild_bank_item` table

This table holds all item information for items that are stored in the guild bank.

Structure

Field	Type	Null	Key	Default	Extra
guildid	int(11) unsigned	NO	PRI	0
TabId	tinyint(1) unsigned	NO	PRI	0
SlotId	tinyint(3) unsigned	NO	PRI	0
item_guid	int(11) unsigned	NO	MUL	0
item_entry	int(11) unsigned	NO		0

Description of the fields

guildid

The guild ID who owns the bank. See guild.guildid

TabId

The tab ID where the item is currently placed in. See guild_bank_tab.TabId

SlotId

The slot that the item is placed in in the tab.

item_guid

The item guid. See item_instance.guid

item_entry

The item template ID for the item. See item_template.entry