]> git.mxchange.org Git - friendica.git/blob - doc/database/db_post-delivery-data.md
HTML-escape notification contact names
[friendica.git] / doc / database / db_post-delivery-data.md
1 Table post-delivery-data
2 ===========
3
4 Delivery data for items
5
6 Fields
7 ------
8
9 | Field        | Description                                                                                                                                                | Type         | Null | Key | Default | Extra |
10 | ------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------ | ---- | --- | ------- | ----- |
11 | uri-id       | Id of the item-uri table entry that contains the item uri                                                                                                  | int unsigned | NO   | PRI | NULL    |       |
12 | postopts     | External post connectors add their network name to this comma-separated string to identify that they should be delivered to these networks during delivery | text         | YES  |     | NULL    |       |
13 | inform       | Additional receivers of the linked item                                                                                                                    | mediumtext   | YES  |     | NULL    |       |
14 | queue_count  | Initial number of delivery recipients, used as item.delivery_queue_count                                                                                   | mediumint    | NO   |     | 0       |       |
15 | queue_done   | Number of successful deliveries, used as item.delivery_queue_done                                                                                          | mediumint    | NO   |     | 0       |       |
16 | queue_failed | Number of unsuccessful deliveries, used as item.delivery_queue_failed                                                                                      | mediumint    | NO   |     | 0       |       |
17 | activitypub  | Number of successful deliveries via ActivityPub                                                                                                            | mediumint    | NO   |     | 0       |       |
18 | dfrn         | Number of successful deliveries via DFRN                                                                                                                   | mediumint    | NO   |     | 0       |       |
19 | legacy_dfrn  | Number of successful deliveries via legacy DFRN                                                                                                            | mediumint    | NO   |     | 0       |       |
20 | diaspora     | Number of successful deliveries via Diaspora                                                                                                               | mediumint    | NO   |     | 0       |       |
21 | ostatus      | Number of successful deliveries via OStatus                                                                                                                | mediumint    | NO   |     | 0       |       |
22
23 Indexes
24 ------------
25
26 | Name    | Fields |
27 | ------- | ------ |
28 | PRIMARY | uri-id |
29
30 Foreign Keys
31 ------------
32
33 | Field | Target Table | Target Field |
34 |-------|--------------|--------------|
35 | uri-id | [item-uri](help/database/db_item-uri) | id |
36
37 Return to [database documentation](help/database)