]> git.mxchange.org Git - friendica.git/blob - doc/database/db_notify.md
Merge branch 'develop' of https://github.com/friendica/friendica into issue/#3039...
[friendica.git] / 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   | YES  |     | NULL                |                 |
14 | uid        | user.id of the owner of this data | int(11)      | NO   | MUL | 0                   |                 |
15 | link       |                                   | varchar(255) | NO   |     |                     |                 |
16 | iid        | item.id                           | int(11)      | NO   |     | 0                   |                 |
17 | parent     |                                   | int(11)      | NO   |     | 0                   |                 |
18 | seen       |                                   | tinyint(1)   | NO   |     | 0                   |                 |
19 | verb       |                                   | varchar(255) | NO   |     |                     |                 |
20 | otype      |                                   | varchar(16)  | NO   |     |                     |                 |
21 | name_cache | Cached bbcode parsing of name     | tinytext     | YES  |     | NULL                |                 |
22 | msg_cache  | Cached bbcode parsing of msg      | mediumtext   | YES  |     | NULL                |                 |
23
24 Return to [database documentation](help/database)