id |
sequential ID |
int unsigned |
NO |
PRI |
NULL |
auto_increment |
uid |
Owner User id |
mediumint unsigned |
NO |
|
0 |
|
created |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
updated |
Date of last contact update |
datetime |
YES |
|
0001-01-01 00:00:00 |
|
network |
Network of the contact |
char(4) |
NO |
|
|
|
name |
Name that this contact is known by |
varchar(255) |
NO |
|
|
|
nick |
Nick- and user name of the contact |
varchar(255) |
NO |
|
|
|
location |
|
varchar(255) |
YES |
|
|
|
about |
|
text |
YES |
|
NULL |
|
keywords |
public keywords (interests) of the contact |
text |
YES |
|
NULL |
|
xmpp |
XMPP address |
varchar(255) |
NO |
|
|
|
matrix |
Matrix address |
varchar(255) |
NO |
|
|
|
avatar |
|
varbinary(383) |
NO |
|
|
|
blurhash |
BlurHash representation of the avatar |
varbinary(255) |
YES |
|
NULL |
|
header |
Header picture |
varbinary(383) |
YES |
|
NULL |
|
url |
|
varbinary(383) |
NO |
|
|
|
nurl |
|
varbinary(383) |
NO |
|
|
|
uri-id |
Id of the item-uri table entry that contains the contact url |
int unsigned |
YES |
|
NULL |
|
addr |
|
varchar(255) |
NO |
|
|
|
alias |
|
varbinary(383) |
NO |
|
|
|
pubkey |
RSA public key 4096 bit |
text |
YES |
|
NULL |
|
prvkey |
RSA private key 4096 bit |
text |
YES |
|
NULL |
|
batch |
|
varbinary(383) |
NO |
|
|
|
notify |
|
varbinary(383) |
YES |
|
NULL |
|
poll |
|
varbinary(383) |
YES |
|
NULL |
|
subscribe |
|
varbinary(383) |
YES |
|
NULL |
|
last-update |
Date of the last try to update the contact info |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
next-update |
Next connection request |
datetime |
YES |
|
NULL |
|
success_update |
Date of the last successful contact update |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
failure_update |
Date of the last failed update |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
failed |
Connection failed |
boolean |
YES |
|
NULL |
|
term-date |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
last-item |
date of the last post |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
last-discovery |
date of the last follower discovery |
datetime |
NO |
|
0001-01-01 00:00:00 |
|
local-data |
Is true when there are posts with this contact on the system |
boolean |
YES |
|
NULL |
|
blocked |
Node-wide block status |
boolean |
NO |
|
1 |
|
block_reason |
Node-wide block reason |
text |
YES |
|
NULL |
|
readonly |
posts of the contact are readonly |
boolean |
NO |
|
0 |
|
contact-type |
Person, organisation, news, community, relay |
tinyint |
NO |
|
0 |
|
manually-approve |
Contact requests have to be approved manually |
boolean |
YES |
|
NULL |
|
archive |
|
boolean |
NO |
|
0 |
|
unsearchable |
Contact prefers to not be searchable |
boolean |
NO |
|
0 |
|
sensitive |
Contact posts sensitive content |
boolean |
NO |
|
0 |
|
baseurl |
baseurl of the contact |
varbinary(383) |
YES |
|
|
|
gsid |
Global Server ID |
int unsigned |
YES |
|
NULL |
|
bd |
|
date |
NO |
|
0001-01-01 |
|
reason |
|
text |
YES |
|
NULL |
|
self |
1 if the contact is the user him/her self |
boolean |
NO |
|
0 |
|
remote_self |
|
boolean |
NO |
|
0 |
|
rel |
The kind of the relation between the user and the contact |
tinyint unsigned |
NO |
|
0 |
|
protocol |
Protocol of the contact |
char(4) |
NO |
|
|
|
subhub |
|
boolean |
NO |
|
0 |
|
hub-verify |
|
varbinary(383) |
NO |
|
|
|
rating |
Automatically detected feed poll frequency |
tinyint |
NO |
|
0 |
|
priority |
Feed poll priority |
tinyint unsigned |
NO |
|
0 |
|
attag |
|
varchar(255) |
NO |
|
|
|
hidden |
|
boolean |
NO |
|
0 |
|
pending |
Contact request is pending |
boolean |
NO |
|
1 |
|
deleted |
Contact has been deleted |
boolean |
NO |
|
0 |
|
info |
|
mediumtext |
YES |
|
NULL |
|
notify_new_posts |
|
boolean |
NO |
|
0 |
|
fetch_further_information |
|
tinyint unsigned |
NO |
|
0 |
|
ffi_keyword_denylist |
|
text |
YES |
|
NULL |
|
photo |
Link to the profile photo of the contact |
varbinary(383) |
YES |
|
|
|
thumb |
Link to the profile photo (thumb size) |
varbinary(383) |
YES |
|
|
|
micro |
Link to the profile photo (micro size) |
varbinary(383) |
YES |
|
|
|
name-date |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
uri-date |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
avatar-date |
|
datetime |
NO |
|
0001-01-01 00:00:00 |
|
request |
|
varbinary(383) |
YES |
|
NULL |
|
confirm |
|
varbinary(383) |
YES |
|
NULL |
|
poco |
|
varbinary(383) |
YES |
|
NULL |
|
writable |
|
boolean |
NO |
|
0 |
|
forum |
contact is a forum. Deprecated, use 'contact-type' = 'community' and 'manually-approve' = false instead |
boolean |
NO |
|
0 |
|
prv |
contact is a private group. Deprecated, use 'contact-type' = 'community' and 'manually-approve' = true instead |
boolean |
NO |
|
0 |
|
bdyear |
|
varchar(4) |
NO |
|
|
|
site-pubkey |
Deprecated |
text |
YES |
|
NULL |
|
gender |
Deprecated |
varchar(32) |
NO |
|
|
|
duplex |
Deprecated |
boolean |
NO |
|
0 |
|
issued-id |
Deprecated |
varbinary(383) |
NO |
|
|
|
dfrn-id |
Deprecated |
varbinary(383) |
NO |
|
|
|
aes_allow |
Deprecated |
boolean |
NO |
|
0 |
|
ret-aes |
Deprecated |
boolean |
NO |
|
0 |
|
usehub |
Deprecated |
boolean |
NO |
|
0 |
|
closeness |
Deprecated |
tinyint unsigned |
NO |
|
99 |
|
profile-id |
Deprecated |
int unsigned |
YES |
|
NULL |
|