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)