Skip to content



    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


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