Skip to content



    mail {
        intunsigned charid
        varchar from
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    mail ||--o{ character_data : "One-to-One"
    mail ||--o{ character_data : "One-to-One"

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


Column Data Type Description
msgid int Unique Message Identifier
charid int Character Identifier
timestamp int UNIX Timestamp
from varchar From Character Name
subject varchar Subject
body text Body
to text To Character Name
status tinyint Status