]> git.mxchange.org Git - friendica.git/blob - doc/database/db_mail.md
Merge branch 'develop' of https://github.com/friendica/friendica into issue/#3039...
[friendica.git] / 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)