guild_bank

Relationships

erDiagram
    guild_bank {
        varchar donator
        intunsigned guildid
        intunsigned itemid
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    guilds {
        int id
        int leader
        varchar motd_setter
    }
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    guild_bank ||--o{ character_data : "One-to-One"
    guild_bank ||--o{ guilds : "One-to-One"
    guild_bank ||--o{ items : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	donator	character_data	name
One-to-One	guildid	guilds	id
One-to-One	itemid	items	id

Schema

Column	Data Type	Description
guildid	int	Guild Identifier
area	tinyint	Area
slot	int	Slot Identifier
itemid	int	Item Identifier
qty	int	Quantity
donator	varchar	Character Identifier
permissions	tinyint	Permissions
whofor	varchar	Who For