Skip to content



    bot_guild_members {
        varchar bot_id
        varchar guild_id
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    guilds {
        int id
        int leader
        varchar motd_setter
    bot_guild_members ||--o{ bot_data : "One-to-One"
    bot_guild_members ||--o{ guilds : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One bot_id bot_data bot_id
One-to-One guild_id guilds id


Column Data Type Description
bot_id int Bot Identifier
guild_id mediumint Guild Identifier
rank tinyint Guild Rank
tribute_enable tinyint Tribute Enabled: 0 = False, 1= True
total_tribute int Total Tribute
last_tribute int Last Tribute
banker tinyint Banker: 0 = False, 1 = True
public_note text Public Note
alt tinyint Alt: 0 = False, 1 = True