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 | NO | | 0 | |
9 | created | | datetime | NO | | 0001-01-01 00:00:00 | |
10 | updated | Date of last contact update | datetime | YES | | 0001-01-01 00:00:00 | |
11 | self | 1 if the contact is the user him/her self | boolean | NO | | 0 | |
12 | remote_self | | boolean | NO | | 0 | |
13 | rel | The kind of the relation between the user and the contact | tinyint unsigned | NO | | 0 | |
14 | duplex | | boolean | NO | | 0 | |
15 | network | Network of the contact | char(4) | NO | | | |
16 | protocol | Protocol of the contact | char(4) | NO | | | |
17 | name | Name that this contact is known by | varchar(255) | NO | | | |
18 | nick | Nick- and user name of the contact | varchar(255) | NO | | | |
19 | location | | varchar(255) | YES | | | |
20 | about | | text | YES | | NULL | |
21 | keywords | public keywords (interests) of the contact | text | YES | | NULL | |
22 | gender | Deprecated | varchar(32) | NO | | | |
23 | xmpp | | varchar(255) | NO | | | |
24 | attag | | varchar(255) | NO | | | |
25 | avatar | | varchar(255) | NO | | | |
26 | photo | Link to the profile photo of the contact | varchar(255) | YES | | | |
27 | thumb | Link to the profile photo (thumb size) | varchar(255) | YES | | | |
28 | micro | Link to the profile photo (micro size) | varchar(255) | YES | | | |
29 | site-pubkey | | text | YES | | NULL | |
30 | issued-id | | varchar(255) | NO | | | |
31 | dfrn-id | | varchar(255) | NO | | | |
32 | url | | varchar(255) | NO | | | |
33 | nurl | | varchar(255) | NO | | | |
34 | addr | | varchar(255) | NO | | | |
35 | alias | | varchar(255) | NO | | | |
36 | pubkey | RSA public key 4096 bit | text | YES | | NULL | |
37 | prvkey | RSA private key 4096 bit | text | YES | | NULL | |
38 | batch | | varchar(255) | NO | | | |
39 | request | | varchar(255) | YES | | NULL | |
40 | notify | | varchar(255) | YES | | NULL | |
41 | poll | | varchar(255) | YES | | NULL | |
42 | confirm | | varchar(255) | YES | | NULL | |
43 | subscribe | | varchar(255) | YES | | NULL | |
44 | poco | | varchar(255) | YES | | NULL | |
45 | aes_allow | | boolean | NO | | 0 | |
46 | ret-aes | | boolean | NO | | 0 | |
47 | usehub | | boolean | NO | | 0 | |
48 | subhub | | boolean | NO | | 0 | |
49 | hub-verify | | varchar(255) | NO | | | |
50 | last-update | Date of the last try to update the contact info | datetime | NO | | 0001-01-01 00:00:00 | |
51 | success_update | Date of the last successful contact update | datetime | NO | | 0001-01-01 00:00:00 | |
52 | failure_update | Date of the last failed update | datetime | NO | | 0001-01-01 00:00:00 | |
53 | failed | Connection failed | boolean | YES | | NULL | |
54 | name-date | | datetime | NO | | 0001-01-01 00:00:00 | |
55 | uri-date | | datetime | NO | | 0001-01-01 00:00:00 | |
56 | avatar-date | | datetime | NO | | 0001-01-01 00:00:00 | |
57 | term-date | | datetime | NO | | 0001-01-01 00:00:00 | |
58 | last-item | date of the last post | datetime | NO | | 0001-01-01 00:00:00 | |
59 | last-discovery | date of the last follower discovery | datetime | NO | | 0001-01-01 00:00:00 | |
60 | priority | | tinyint unsigned | NO | | 0 | |
61 | blocked | Node-wide block status | boolean | NO | | 1 | |
62 | block_reason | Node-wide block reason | text | YES | | NULL | |
63 | readonly | posts of the contact are readonly | boolean | NO | | 0 | |
64 | writable | | boolean | NO | | 0 | |
65 | forum | contact is a forum | boolean | NO | | 0 | |
66 | prv | contact is a private group | boolean | NO | | 0 | |
67 | contact-type | | tinyint | NO | | 0 | |
68 | manually-approve | | boolean | YES | | NULL | |
69 | hidden | | boolean | NO | | 0 | |
70 | archive | | boolean | NO | | 0 | |
71 | pending | | boolean | NO | | 1 | |
72 | deleted | Contact has been deleted | boolean | NO | | 0 | |
73 | rating | | tinyint | NO | | 0 | |
74 | unsearchable | Contact prefers to not be searchable | boolean | NO | | 0 | |
75 | sensitive | Contact posts sensitive content | boolean | NO | | 0 | |
76 | baseurl | baseurl of the contact | varchar(255) | YES | | | |
77 | gsid | Global Server ID | int unsigned | YES | | NULL | |
78 | reason | | text | YES | | NULL | |
79 | closeness | | tinyint unsigned | NO | | 99 | |
80 | info | | mediumtext | YES | | NULL | |
81 | profile-id | Deprecated | int unsigned | YES | | NULL | |
82 | bdyear | | varchar(4) | NO | | | |
83 | bd | | date | NO | | 0001-01-01 | |
84 | notify_new_posts | | boolean | NO | | 0 | |
85 | fetch_further_information | | tinyint unsigned | NO | | 0 | |
86 | ffi_keyword_denylist | | text | YES | | NULL | |
88 Return to [database documentation](help/database)