mail

Relationships

erDiagram
    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

Schema

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