mail¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| 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 |