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 | gcontact-id | Global Contact   | int(11) unsigned | NO   |     | 0                   |       |
  10 | owner-id    | Item owner       | int(11) unsigned | NO   | MUL | 0                   |       |
  11 | author-id   | Item author      | int(11) unsigned | NO   | MUL | 0                   |       |
  12 | created     |                  | datetime         | NO   | MUL | 0001-01-01 00:00:00 |       |
  13 | edited      |                  | datetime         | NO   |     | 0001-01-01 00:00:00 |       |
  14 | commented   |                  | datetime         | NO   | MUL | 0001-01-01 00:00:00 |       |
  15 | received    |                  | datetime         | NO   |     | 0001-01-01 00:00:00 |       |
  16 | changed     |                  | datetime         | NO   |     | 0001-01-01 00:00:00 |       |
  17 | wall        |                  | tinyint(1)       | NO   | MUL | 0                   |       |
  18 | private     |                  | tinyint(1)       | NO   |     | 0                   |       |
  19 | pubmail     |                  | tinyint(1)       | NO   |     | 0                   |       |
  20 | moderated   |                  | tinyint(1)       | NO   |     | 0                   |       |
  21 | visible     |                  | tinyint(1)       | NO   |     | 0                   |       |
  22 | spam        |                  | tinyint(1)       | NO   |     | 0                   |       |
  23 | starred     |                  | tinyint(1)       | NO   |     | 0                   |       |
  24 | ignored     |                  | tinyint(1)       | NO   |     | 0                   |       |
  25 | bookmark    |                  | tinyint(1)       | NO   |     | 0                   |       |
  26 | unseen      |                  | tinyint(1)       | NO   |     | 1                   |       |
  27 | deleted     |                  | tinyint(1)       | NO   |     | 0                   |       |
  28 | origin      |                  | tinyint(1)       | NO   |     | 0                   |       |
  29 | forum_mode  |                  | tinyint(1)       | NO   |     | 0                   |       |
  30 | mention     |                  | tinyint(1)       | NO   |     | 0                   |       |
  31 | network     |                  | varchar(32)      | NO   |     |                     |       |
  32
  33 Return to [database documentation](help/database)