4 ActivityPub compatible contacts - used in the ActivityPub implementation
9 | Field | Description | Type | Null | Key | Default | Extra |
10 | ---------------- | ------------------------------------------------------------------- | -------------- | ---- | --- | ------------------- | ----- |
11 | url | URL of the contact | varbinary(255) | NO | PRI | NULL | |
12 | uri-id | Id of the item-uri table entry that contains the apcontact url | int unsigned | YES | | NULL | |
13 | uuid | | varchar(255) | YES | | NULL | |
14 | type | | varchar(20) | NO | | NULL | |
15 | following | | varchar(255) | YES | | NULL | |
16 | followers | | varchar(255) | YES | | NULL | |
17 | inbox | | varchar(255) | NO | | NULL | |
18 | outbox | | varchar(255) | YES | | NULL | |
19 | sharedinbox | | varchar(255) | YES | | NULL | |
20 | manually-approve | | boolean | YES | | NULL | |
21 | discoverable | Mastodon extension: true if profile is published in their directory | boolean | YES | | NULL | |
22 | nick | | varchar(255) | NO | | | |
23 | name | | varchar(255) | YES | | NULL | |
24 | about | | text | YES | | NULL | |
25 | photo | | varchar(255) | YES | | NULL | |
26 | header | Header picture | varchar(255) | YES | | NULL | |
27 | addr | | varchar(255) | YES | | NULL | |
28 | alias | | varchar(255) | YES | | NULL | |
29 | pubkey | | text | YES | | NULL | |
30 | subscribe | | varchar(255) | YES | | NULL | |
31 | baseurl | baseurl of the ap contact | varchar(255) | YES | | NULL | |
32 | gsid | Global Server ID | int unsigned | YES | | NULL | |
33 | generator | Name of the contact's system | varchar(255) | YES | | NULL | |
34 | following_count | Number of following contacts | int unsigned | YES | | 0 | |
35 | followers_count | Number of followers | int unsigned | YES | | 0 | |
36 | statuses_count | Number of posts | int unsigned | YES | | 0 | |
37 | updated | | datetime | NO | | 0001-01-01 00:00:00 | |
43 | ----------- | ---------------- |
46 | alias | alias(190) |
47 | followers | followers(190) |
48 | baseurl | baseurl(190) |
49 | sharedinbox | sharedinbox(190) |
51 | uri-id | UNIQUE, uri-id |
56 | Field | Target Table | Target Field |
57 |-------|--------------|--------------|
58 | uri-id | [item-uri](help/database/db_item-uri) | id |
59 | gsid | [gserver](help/database/db_gserver) | id |
61 Return to [database documentation](help/database)