doc/database/db_conversation.md

   1 Table conversation
   2 ===========
   3
   4 Raw data and structure information for messages
   5
   6 Fields
   7 ------
   8
   9 | Field             | Description                                                          | Type             | Null | Key | Default             | Extra |
  10 | ----------------- | -------------------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | ----- |
  11 | item-uri          | Original URI of the item - unrelated to the table with the same name | varbinary(255)   | NO   | PRI | NULL                |       |
  12 | reply-to-uri      | URI to which this item is a reply                                    | varbinary(255)   | NO   |     |                     |       |
  13 | conversation-uri  | GNU Social conversation URI                                          | varbinary(255)   | NO   |     |                     |       |
  14 | conversation-href | GNU Social conversation link                                         | varbinary(255)   | NO   |     |                     |       |
  15 | protocol          | The protocol of the item                                             | tinyint unsigned | NO   |     | 255                 |       |
  16 | direction         | How the message arrived here: 1=push, 2=pull                         | tinyint unsigned | NO   |     | 0                   |       |
  17 | source            | Original source                                                      | mediumtext       | YES  |     | NULL                |       |
  18 | received          | Receiving date                                                       | datetime         | NO   |     | 0001-01-01 00:00:00 |       |
  19
  20 Indexes
  21 ------------
  22
  23 | Name             | Fields           |
  24 | ---------------- | ---------------- |
  25 | PRIMARY          | item-uri         |
  26 | conversation-uri | conversation-uri |
  27 | received         | received         |
  28
  29
  30 Return to [database documentation](help/database)