9 | Field | Description | Type | Null | Key | Default | Extra |
10 | ------------------------- | --------------------------------------------------------- | ------------------ | ---- | --- | ------------------- | -------------- |
11 | id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
12 | uid | Owner User id | mediumint unsigned | NO | | 0 | |
13 | created | | datetime | NO | | 0001-01-01 00:00:00 | |
14 | updated | Date of last contact update | datetime | YES | | 0001-01-01 00:00:00 | |
15 | self | 1 if the contact is the user him/her self | boolean | NO | | 0 | |
16 | remote_self | | boolean | NO | | 0 | |
17 | rel | The kind of the relation between the user and the contact | tinyint unsigned | NO | | 0 | |
18 | duplex | | boolean | NO | | 0 | |
19 | network | Network of the contact | char(4) | NO | | | |
20 | protocol | Protocol of the contact | char(4) | NO | | | |
21 | name | Name that this contact is known by | varchar(255) | NO | | | |
22 | nick | Nick- and user name of the contact | varchar(255) | NO | | | |
23 | location | | varchar(255) | YES | | | |
24 | about | | text | YES | | NULL | |
25 | keywords | public keywords (interests) of the contact | text | YES | | NULL | |
26 | gender | Deprecated | varchar(32) | NO | | | |
27 | xmpp | | varchar(255) | NO | | | |
28 | attag | | varchar(255) | NO | | | |
29 | avatar | | varchar(255) | NO | | | |
30 | photo | Link to the profile photo of the contact | varchar(255) | YES | | | |
31 | thumb | Link to the profile photo (thumb size) | varchar(255) | YES | | | |
32 | micro | Link to the profile photo (micro size) | varchar(255) | YES | | | |
33 | header | Header picture | varchar(255) | YES | | NULL | |
34 | site-pubkey | | text | YES | | NULL | |
35 | issued-id | | varchar(255) | NO | | | |
36 | dfrn-id | | varchar(255) | NO | | | |
37 | url | | varchar(255) | NO | | | |
38 | nurl | | varchar(255) | NO | | | |
39 | addr | | varchar(255) | NO | | | |
40 | alias | | varchar(255) | NO | | | |
41 | pubkey | RSA public key 4096 bit | text | YES | | NULL | |
42 | prvkey | RSA private key 4096 bit | text | YES | | NULL | |
43 | batch | | varchar(255) | NO | | | |
44 | request | | varchar(255) | YES | | NULL | |
45 | notify | | varchar(255) | YES | | NULL | |
46 | poll | | varchar(255) | YES | | NULL | |
47 | confirm | | varchar(255) | YES | | NULL | |
48 | subscribe | | varchar(255) | YES | | NULL | |
49 | poco | | varchar(255) | YES | | NULL | |
50 | aes_allow | | boolean | NO | | 0 | |
51 | ret-aes | | boolean | NO | | 0 | |
52 | usehub | | boolean | NO | | 0 | |
53 | subhub | | boolean | NO | | 0 | |
54 | hub-verify | | varchar(255) | NO | | | |
55 | last-update | Date of the last try to update the contact info | datetime | NO | | 0001-01-01 00:00:00 | |
56 | success_update | Date of the last successful contact update | datetime | NO | | 0001-01-01 00:00:00 | |
57 | failure_update | Date of the last failed update | datetime | NO | | 0001-01-01 00:00:00 | |
58 | failed | Connection failed | boolean | YES | | NULL | |
59 | name-date | | datetime | NO | | 0001-01-01 00:00:00 | |
60 | uri-date | | datetime | NO | | 0001-01-01 00:00:00 | |
61 | avatar-date | | datetime | NO | | 0001-01-01 00:00:00 | |
62 | term-date | | datetime | NO | | 0001-01-01 00:00:00 | |
63 | last-item | date of the last post | datetime | NO | | 0001-01-01 00:00:00 | |
64 | last-discovery | date of the last follower discovery | datetime | NO | | 0001-01-01 00:00:00 | |
65 | priority | | tinyint unsigned | NO | | 0 | |
66 | blocked | Node-wide block status | boolean | NO | | 1 | |
67 | block_reason | Node-wide block reason | text | YES | | NULL | |
68 | readonly | posts of the contact are readonly | boolean | NO | | 0 | |
69 | writable | | boolean | NO | | 0 | |
70 | forum | contact is a forum | boolean | NO | | 0 | |
71 | prv | contact is a private group | boolean | NO | | 0 | |
72 | contact-type | | tinyint | NO | | 0 | |
73 | manually-approve | | boolean | YES | | NULL | |
74 | hidden | | boolean | NO | | 0 | |
75 | archive | | boolean | NO | | 0 | |
76 | pending | | boolean | NO | | 1 | |
77 | deleted | Contact has been deleted | boolean | NO | | 0 | |
78 | rating | | tinyint | NO | | 0 | |
79 | unsearchable | Contact prefers to not be searchable | boolean | NO | | 0 | |
80 | sensitive | Contact posts sensitive content | boolean | NO | | 0 | |
81 | baseurl | baseurl of the contact | varchar(255) | YES | | | |
82 | gsid | Global Server ID | int unsigned | YES | | NULL | |
83 | reason | | text | YES | | NULL | |
84 | closeness | | tinyint unsigned | NO | | 99 | |
85 | info | | mediumtext | YES | | NULL | |
86 | profile-id | Deprecated | int unsigned | YES | | NULL | |
87 | bdyear | | varchar(4) | NO | | | |
88 | bd | | date | NO | | 0001-01-01 | |
89 | notify_new_posts | | boolean | NO | | 0 | |
90 | fetch_further_information | | tinyint unsigned | NO | | 0 | |
91 | ffi_keyword_denylist | | text | YES | | NULL | |
97 | --------------------------- | ------------------------------------ |
99 | uid_name | uid, name(190) |
100 | self_uid | self, uid |
101 | alias_uid | alias(128), uid |
102 | pending_uid | pending, uid |
103 | blocked_uid | blocked, uid |
104 | uid_rel_network_poll | uid, rel, network, poll(64), archive |
105 | uid_network_batch | uid, network, batch(64) |
106 | batch_contact-type | batch(64), contact-type |
107 | addr_uid | addr(128), uid |
108 | nurl_uid | nurl(128), uid |
109 | nick_uid | nick(128), uid |
110 | attag_uid | attag(96), uid |
111 | dfrn-id | dfrn-id(64) |
112 | issued-id | issued-id(64) |
113 | network_uid_lastupdate | network, uid, last-update |
114 | uid_network_self_lastupdate | uid, network, self, last-update |
115 | uid_lastitem | uid, last-item |
116 | baseurl | baseurl(64) |
117 | uid_contact-type | uid, contact-type |
118 | uid_self_contact-type | uid, self, contact-type |
119 | self_network_uid | self, network, uid |
125 | Field | Target Table | Target Field |
126 |-------|--------------|--------------|
127 | uid | [user](help/database/db_user) | uid |
128 | gsid | [gserver](help/database/db_gserver) | id |
130 Return to [database documentation](help/database)
projects / friendica.git / blob