Guild bank item

From OregonCore Wiki
Jump to: navigation, search

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.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
guildid int(11) unsigned PRI NO 0
TabId tinyint(1) unsigned PRI NO 0
SlotId tinyint(3) unsigned PRI NO 0
item_guid int(11) unsigned NO 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