]> git.mxchange.org Git - friendica.git/blob - doc/database/db_conv.md
Merge pull request #2527 from annando/1605-entities-link
[friendica.git] / doc / database / db_conv.md
1 Table conv
2 ==========
3
4 | Field   | Description                               | Type             | Null | Key | Default             | Extra           |
5 | ------- | ----------------------------------------- | ---------------- | ---- | --- | ------------------- | --------------- |
6 | id      | sequential ID                             | int(10) unsigned | NO   | PRI | NULL                | auto_increment  |
7 | guid    | A unique identifier for this conversation | varchar(64)      | NO   |     |                     |                 |
8 | recips  | sender_handle;recipient_handle            | mediumtext       | NO   |     | NULL                |                 |
9 | uid     | user_id of the owner of this data         | int(11)          | NO   | MUL | 0                   |                 |
10 | creator | handle of creator                         | varchar(255)     | NO   |     |                     |                 |
11 | created | creation timestamp                        | datetime         | NO   |     | 0000-00-00 00:00:00 |                 |
12 | updated | edited timestamp                          | datetime         | NO   |     | 0000-00-00 00:00:00 |                 |
13 | subject | subject of initial message                | mediumtext       | NO   |     | NULL                |                 |
14
15 Return to [database documentation](help/database)