Skip to content



    qs_player_speech {
        varchar from
        varchar to
        int guilddbid
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    guilds {
        int id
        int leader
        varchar motd_setter
    qs_player_speech ||--o{ character_data : "One-to-One"
    qs_player_speech ||--o{ character_data : "One-to-One"
    qs_player_speech ||--o{ guilds : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One from character_data name
One-to-One to character_data name
One-to-One guilddbid guilds id


Column Data Type Description
id int Unique Speech Identifier
from varchar From Character Identifier
to varchar To Character Identifier
message varchar Message
minstatus smallint Minimum Status
guilddbid int Guild Database Identifier
type tinyint Type
timerecorded timestamp Time Recorded Timestamp