4 ActivityPub compatible contacts - used in the ActivityPub implementation
6 | Field | Description | Type | Null | Key | Default | Extra |
7 | ---------------- | ---------------------------- | -------------- | ---- | --- | ------------------- | ----- |
8 | url | URL of the contact | varbinary(255) | NO | PRI | NULL | |
9 | uuid | | varchar(255) | YES | | NULL | |
10 | type | | varchar(20) | NO | | NULL | |
11 | following | | varchar(255) | YES | | NULL | |
12 | followers | | varchar(255) | YES | | NULL | |
13 | inbox | | varchar(255) | NO | | NULL | |
14 | outbox | | varchar(255) | YES | | NULL | |
15 | sharedinbox | | varchar(255) | YES | | NULL | |
16 | manually-approve | | boolean | YES | | NULL | |
17 | nick | | varchar(255) | NO | | | |
18 | name | | varchar(255) | YES | | NULL | |
19 | about | | text | YES | | NULL | |
20 | photo | | varchar(255) | YES | | NULL | |
21 | addr | | varchar(255) | YES | | NULL | |
22 | alias | | varchar(255) | YES | | NULL | |
23 | pubkey | | text | YES | | NULL | |
24 | subscribe | | varchar(255) | YES | | NULL | |
25 | baseurl | baseurl of the ap contact | varchar(255) | YES | | NULL | |
26 | gsid | Global Server ID | int unsigned | YES | | NULL | |
27 | generator | Name of the contact's system | varchar(255) | YES | | NULL | |
28 | following_count | Number of following contacts | int unsigned | YES | | 0 | |
29 | followers_count | Number of followers | int unsigned | YES | | 0 | |
30 | statuses_count | Number of posts | int unsigned | YES | | 0 | |
31 | updated | | datetime | NO | | 0001-01-01 00:00:00 | |
33 Return to [database documentation](help/database)