]> git.mxchange.org Git - friendica.git/blob - doc/database/db_contact.md
eb5c505d13ef27dc1587ca1c9396df7494daf59b
[friendica.git] / doc / database / db_contact.md
1 Table contact
2 =============
3
4 | Field                     | Description                                               | Type         | Null | Key | Default             | Extra          |
5 |---------------------------|-----------------------------------------------------------|--------------|------|-----|---------------------|----------------|
6 | id                        | sequential ID                                             | int(11)      | NO   | PRI | NULL                | auto_increment |
7 | uid                       | user.id of the owner of this data                         | int(11)      | NO   | MUL | 0                   |                |
8 | created                   |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
9 | self                      | 1 if the contact is the user him/her self                 | tinyint(1)   | NO   |     | 0                   |                |
10 | remote_self               |                                                           | tinyint(1)   | NO   |     | 0                   |                |
11 | rel                       | The kind of the relation between the user and the contact | tinyint(1)   | NO   |     | 0                   |                |
12 | duplex                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
13 | network                   | Network protocol of the contact                           | varchar(255) | NO   |     |                     |                |
14 | name                      | Name that this contact is known by                        | varchar(255) | NO   |     |                     |                |
15 | nick                      | Nick- and user name of the contact                        | varchar(255) | NO   |     |                     |                |
16 | location                  |                                                           | varchar(255) | NO   |     |                     |                |
17 | about                     |                                                           | text         | NO   |     | NULL                |                |
18 | keywords                  | public keywords (interests) of the contact                | text         | NO   |     | NULL                |                |
19 | gender                    |                                                           | varchar(32)  | NO   |     |                     |                |
20 | attag                     |                                                           | varchar(255) | NO   |     |                     |                |
21 | photo                     | Link to the profile photo of the contact                  | text         | NO   |     | NULL                |                |
22 | thumb                     | Link to the profile photo (thumb size)                    | text         | NO   |     | NULL                |                |
23 | micro                     | Link to the profile photo (micro size)                    | text         | NO   |     | NULL                |                |
24 | site-pubkey               |                                                           | text         | NO   |     | NULL                |                |
25 | issued-id                 |                                                           | varchar(255) | NO   |     |                     |                |
26 | dfrn-id                   |                                                           | varchar(255) | NO   |     |                     |                |
27 | url                       |                                                           | varchar(255) | NO   |     |                     |                |
28 | nurl                      |                                                           | varchar(255) | NO   |     |                     |                |
29 | addr                      |                                                           | varchar(255) | NO   |     |                     |                |
30 | alias                     |                                                           | varchar(255) | NO   |     |                     |                |
31 | pubkey                    | RSA public key 4096 bit                                   | text         | NO   |     | NULL                |                |
32 | prvkey                    | RSA private key 4096 bit                                  | text         | NO   |     | NULL                |                |
33 | batch                     |                                                           | varchar(255) | NO   |     |                     |                |
34 | request                   |                                                           | text         | NO   |     | NULL                |                |
35 | notify                    |                                                           | text         | NO   |     | NULL                |                |
36 | poll                      |                                                           | text         | NO   |     | NULL                |                |
37 | confirm                   |                                                           | text         | NO   |     | NULL                |                |
38 | poco                      |                                                           | text         | NO   |     | NULL                |                |
39 | aes_allow                 |                                                           | tinyint(1)   | NO   |     | 0                   |                |
40 | ret-aes                   |                                                           | tinyint(1)   | NO   |     | 0                   |                |
41 | usehub                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
42 | subhub                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
43 | hub-verify                |                                                           | varchar(255) | NO   |     |                     |                |
44 | last-update               | Date of the last try to update the contact info           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
45 | success_update            | Date of the last successful contact update                | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
46 | failure_update            | Date of the last failed update                            | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
47 | name-date                 |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
48 | uri-date                  |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
49 | avatar-date               |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
50 | term-date                 |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
51 | last-item                 | date of the last post                                     | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
52 | priority                  |                                                           | tinyint(3)   | NO   |     | 0                   |                |
53 | blocked                   |                                                           | tinyint(1)   | NO   |     | 1                   |                |
54 | readonly                  | posts of the contact are readonly                         | tinyint(1)   | NO   |     | 0                   |                |
55 | writable                  |                                                           | tinyint(1)   | NO   |     | 0                   |                |
56 | forum                     | contact is a forum                                        | tinyint(1)   | NO   |     | 0                   |                |
57 | prv                       | contact is a private group                                | tinyint(1)   | NO   |     | 0                   |                |
58 | hidden                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
59 | archive                   |                                                           | tinyint(1)   | NO   |     | 0                   |                |
60 | pending                   |                                                           | tinyint(1)   | NO   |     | 1                   |                |
61 | rating                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
62 | reason                    |                                                           | text         | NO   |     | NULL                |                |
63 | closeness                 |                                                           | tinyint(2)   | NO   |     | 99                  |                |
64 | info                      |                                                           | mediumtext   | NO   |     | NULL                |                |
65 | profile-id                |                                                           | int(11)      | NO   |     | 0                   |                |
66 | bdyear                    |                                                           | varchar(4)   | NO   |     |                     |                |
67 | bd                        |                                                           | date         | NO   |     | 0001-01-01          |                |
68 | notify_new_posts          |                                                           | tinyint(1)   | NO   |     | 0                   |                |
69 | fetch_further_information |                                                           | tinyint(1)   | NO   |     | 0                   |                |
70 | ffi_keyword_blacklist     |                                                           | mediumtext   | NO   |     | NULL                |                |
71
72 Return to [database documentation](help/database)