Skip to content

guilds

Relationships

erDiagram
    guilds {
        int id
        int leader
        varchar motd_setter
    }
    guild_bank {
        varchar donator
        intunsigned guildid
        intunsigned itemid
    }
    guild_ranks {
        mediumintunsigned guild_id
    }
    guild_members {
        int char_id
        mediumintunsigned guild_id
    }
    guild_relations {
        mediumintunsigned guild1
        mediumintunsigned guild2
    }
    qs_player_speech {
        varchar from
        varchar to
        int guilddbid
    }
    guilds ||--o{ guild_bank : "Has-Many"
    guilds ||--o{ guild_ranks : "Has-Many"
    guilds ||--o{ guild_members : "Has-Many"
    guilds ||--o{ guild_relations : "Has-Many"
    guilds ||--o{ guild_relations : "Has-Many"
    guilds ||--o{ qs_player_speech : "Has-Many"


erDiagram
    guilds {
        int id
        int leader
        varchar motd_setter
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    guilds ||--o{ character_data : "One-to-One"
    guilds ||--o{ character_data : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
Has-Many id guild_bank guildid
Has-Many id guild_ranks guild_id
Has-Many id guild_members guild_id
Has-Many id guild_relations guild1
Has-Many id guild_relations guild2
Has-Many id qs_player_speech guilddbid
One-to-One leader character_data id
One-to-One motd_setter character_data name

Schema

Column Data Type Description
id int Unique Guild Identifier
name varchar Name
leader int Character Identifier
minstatus smallint Minimum Status
motd text Message of the Day
tribute int Tribute
motd_setter varchar Character Identifier
channel varchar Channel
url varchar Website URL
favor int