doc/database/db_thread.md

   1 Table thread
   2 ============
   3
   4 | Field      | Description      | Type             | Null | Key | Default             | Extra |
   5 |------------|------------------|------------------|------|-----|---------------------|-------|
   6 | iid        | sequential ID    | int(10) unsigned | NO   | PRI | 0                   |       |
   7 | uid        |                  | int(10) unsigned | NO   | MUL | 0                   |       |
   8 | contact-id |                  | int(11) unsigned | NO   |     | 0                   |       |
   9 | created    |                  | datetime         | NO   | MUL | 0000-00-00 00:00:00 |       |
  10 | edited     |                  | datetime         | NO   |     | 0000-00-00 00:00:00 |       |
  11 | commented  |                  | datetime         | NO   | MUL | 0000-00-00 00:00:00 |       |
  12 | received   |                  | datetime         | NO   |     | 0000-00-00 00:00:00 |       |
  13 | changed    |                  | datetime         | NO   |     | 0000-00-00 00:00:00 |       |
  14 | wall       |                  | tinyint(1)       | NO   | MUL | 0                   |       |
  15 | private    |                  | tinyint(1)       | NO   |     | 0                   |       |
  16 | pubmail    |                  | tinyint(1)       | NO   |     | 0                   |       |
  17 | moderated  |                  | tinyint(1)       | NO   |     | 0                   |       |
  18 | visible    |                  | tinyint(1)       | NO   |     | 0                   |       |
  19 | spam       |                  | tinyint(1)       | NO   |     | 0                   |       |
  20 | starred    |                  | tinyint(1)       | NO   |     | 0                   |       |
  21 | ignored    |                  | tinyint(1)       | NO   |     | 0                   |       |
  22 | bookmark   |                  | tinyint(1)       | NO   |     | 0                   |       |
  23 | unseen     |                  | tinyint(1)       | NO   |     | 1                   |       |
  24 | deleted    |                  | tinyint(1)       | NO   |     | 0                   |       |
  25 | origin     |                  | tinyint(1)       | NO   |     | 0                   |       |
  26 | forum_mode |                  | tinyint(1)       | NO   |     | 0                   |       |
  27 | mention    |                  | tinyint(1)       | NO   |     | 0                   |       |
  28 | network    |                  | varchar(32)      | NO   |     |                     |       |
  29
  30 Return to [database documentation](help/database)