guild_bank_item

Back-to:Characters

The `guild_bank_item` table

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

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guildid

int(10)

unsigned

PRI

NO

0

 

 

TabId

tinyint(3)

unsigned

PRI

NO

0

 

 

SlotId

tinyint(3)

unsigned

PRI

NO

0

 

 

item_guid

int(10)

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