]> git.mxchange.org Git - friendica.git/blob - doc/database/db_notification.md
5858151a3e70c5d208e5f3613e306183632e4e94
[friendica.git] / doc / database / db_notification.md
1 Table notification
2 ===========
3 notifications
4
5 | Field | Description | Type | Null | Key | Default | Extra |
6 | ----- | ----------- | ---- | ---- | --- | ------- | ----- |
7 | id            | sequential ID                                                                  | int unsigned       | NO  | PRI | NULL | auto_increment |    
8 | uid           | Owner User id                                                                  | mediumint unsigned | YES |     | NULL |                |    
9 | vid           | Id of the verb table entry that contains the activity verbs                    | smallint unsigned  | YES |     | NULL |                |    
10 | type          |                                                                                | tinyint unsigned   | YES |     | NULL |                |    
11 | actor-id      | Link to the contact table with uid=0 of the actor that caused the notification | int unsigned       | YES |     | NULL |                |    
12 | target-uri-id | Item-uri id of the related post                                                | int unsigned       | YES |     | NULL |                |    
13 | parent-uri-id | Item-uri id of the parent of the related post                                  | int unsigned       | YES |     | NULL |                |    
14 | created       |                                                                                | datetime           | YES |     | NULL |                |    
15 | seen          |                                                                                | boolean            | YES |     | 0    |                |    
16
17 Return to [database documentation](help/database)