qs_player_speech

Relationships

erDiagram
    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

Schema

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