]> git.mxchange.org Git - friendica.git/blob - doc/database/db_endpoint.md
Merge remote-tracking branch 'origin/2022.12-rc' into fixes
[friendica.git] / doc / database / db_endpoint.md
1 Table endpoint
2 ===========
3
4 ActivityPub endpoints - used in the ActivityPub implementation
5
6 Fields
7 ------
8
9 | Field        | Description                                                    | Type           | Null | Key | Default | Extra |
10 | ------------ | -------------------------------------------------------------- | -------------- | ---- | --- | ------- | ----- |
11 | url          | URL of the contact                                             | varbinary(383) | NO   | PRI | NULL    |       |
12 | type         |                                                                | varchar(20)    | NO   |     | NULL    |       |
13 | owner-uri-id | Id of the item-uri table entry that contains the apcontact url | int unsigned   | YES  |     | NULL    |       |
14
15 Indexes
16 ------------
17
18 | Name              | Fields                     |
19 | ----------------- | -------------------------- |
20 | PRIMARY           | url                        |
21 | owner-uri-id_type | UNIQUE, owner-uri-id, type |
22
23 Foreign Keys
24 ------------
25
26 | Field | Target Table | Target Field |
27 |-------|--------------|--------------|
28 | owner-uri-id | [item-uri](help/database/db_item-uri) | id |
29
30 Return to [database documentation](help/database)