doc/database/db_notify.md

   1 Table notify
   2 ============
   3
   4 | Field  | Description                       | Type         | Null | Key | Default             | Extra           |
   5 | ------ | --------------------------------- | ------------ | ---- | --- | ------------------- | --------------- |
   6 | id     | sequential ID                     | int(11)      | NO   | PRI | NULL                | auto_increment  |
   7 | hash   |                                   | varchar(64)  | NO   |     |                     |                 |
   8 | type   |                                   | int(11)      | NO   |     | 0                   |                 |
   9 | name   |                                   | varchar(255) | NO   |     |                     |                 |
  10 | url    |                                   | varchar(255) | NO   |     |                     |                 |
  11 | photo  |                                   | varchar(255) | NO   |     |                     |                 |
  12 | date   |                                   | datetime     | NO   |     | 0000-00-00 00:00:00 |                 |
  13 | msg    |                                   | mediumtext   | NO   |     | NULL                |                 |
  14 | uid    | user.id of the owner of this data | int(11)      | NO   | MUL | 0                   |                 |
  15 | link   |                                   | varchar(255) | NO   |     |                     |                 |
  16 | parent |                                   | int(11)      | NO   |     | 0                   |                 |
  17 | seen   |                                   | tinyint(1)   | NO   |     | 0                   |                 |
  18 | verb   |                                   | varchar(255) | NO   |     |                     |                 |
  19 | otype  |                                   | varchar(16)  | NO   |     |                     |                 |
  20 | iid    | item.id                           | int(11)      | NO   |     | 0                   |                 |
  21
  22 Return to [database documentation](help/database)