doc/database/db_mail.md

   1 Table mail
   2 ==========
   3
   4 | Field      | Description                                  | Type             | Null | Key | Default             | Extra           |
   5 | ---------- | -------------------------------------------- | ---------------- | ---- | --- | ------------------- | --------------- |
   6 | id         | sequential ID                                | int(10) unsigned | NO   | PRI | NULL                | auto_increment  |
   7 | uid        | user.id of the owner of this data            | int(10) unsigned | NO   | MUL | 0                   |                 |
   8 | guid       | A unique identifier for this private message | int(10) unsigned | NO   | MUL |                     |                 |
   9 | from-name  | name of the sender                           | varchar(255)     | NO   |     |                     |                 |
  10 | from-photo | contact photo link of the sender             | varchar(255)     | NO   |     |                     |                 |
  11 | from-url   | profile linke of the sender                  | varchar(255)     | NO   |     |                     |                 |
  12 | contact-id | contact.id                                   | varchar(255)     | NO   |     |                     |                 |
  13 | convid     | conv.id                                      | int(11) unsigned | NO   | MUL | 0                   |                 |
  14 | title      |                                              | varchar(255)     | NO   |     |                     |                 |
  15 | body       |                                              | mediumtext       | NO   |     | NULL                |                 |
  16 | seen       | if message visited it is 1                   | varchar(255)     | NO   |     | 0                   |                 |
  17 | reply      |                                              | varchar(255)     | NO   | MUL | 0                   |                 |
  18 | replied    |                                              | varchar(255)     | NO   |     | 0                   |                 |
  19 | unknown    | if sender not in the contact table this is 1 | varchar(255)     | NO   |     | 0                   |                 |
  20 | uri        |                                              | varchar(255)     | NO   | MUL |                     |                 |
  21 | parent-uri |                                              | varchar(255)     | NO   | MUL |                     |                 |
  22 | created    | creation time of the private message         | datetime         | NO   |     | 0000-00-00 00:00:00 |                 |
  23
  24 Return to [database documentation](help/database)