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