]> git.mxchange.org Git - friendica.git/blob - doc/database/db_conversation.md
Pad the header
[friendica.git] / doc / database / db_conversation.md
1 Table conversation
2 ===========
3 Raw data and structure information for messages
4
5 | Field             | Description                                                          | Type             | Null | Key | Default             | Extra |    
6 | ----------------- | -------------------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | ----- |    
7 | item-uri          | Original URI of the item - unrelated to the table with the same name | varbinary(255)   | NO   | PRI | NULL                |       |    
8 | reply-to-uri      | URI to which this item is a reply                                    | varbinary(255)   | NO   |     |                     |       |    
9 | conversation-uri  | GNU Social conversation URI                                          | varbinary(255)   | NO   |     |                     |       |    
10 | conversation-href | GNU Social conversation link                                         | varbinary(255)   | NO   |     |                     |       |    
11 | protocol          | The protocol of the item                                             | tinyint unsigned | NO   |     | 255                 |       |    
12 | direction         | How the message arrived here: 1=push, 2=pull                         | tinyint unsigned | NO   |     | 0                   |       |    
13 | source            | Original source                                                      | mediumtext       | YES  |     | NULL                |       |    
14 | received          | Receiving date                                                       | datetime         | NO   |     | 0001-01-01 00:00:00 |       |    
15
16 Return to [database documentation](help/database)