Skip to content



    guild_members {
        int char_id
        mediumintunsigned guild_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    guilds {
        int id
        int leader
        varchar motd_setter
    guild_members ||--o{ character_data : "One-to-One"
    guild_members ||--o{ guilds : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
One-to-One guild_id guilds id


Column Data Type Description
char_id int Character Identifier
guild_id mediumint Guild Identifier
rank tinyint Rank
tribute_enable tinyint Tribute Enable: 0 = False, 1 = True
total_tribute int Total Tribute
last_tribute int Last Tribute
banker tinyint Banked: 0 = False, 1 = True
public_note text Public Note
alt tinyint Alt: 0 = False, 1 = True
online tinyint