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   |     | 0000-00-00 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   |     | 0000-00-00 00:00:00 |                |
  45 | success_update            | Date of the last successful contact update                | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  46 | failure_update            | Date of the last failed update                            | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  47 | name-date                 |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  48 | uri-date                  |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  49 | avatar-date               |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  50 | term-date                 |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
  51 | last-item                 | date of the last post                                     | datetime     | NO   |     | 0000-00-00 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   |     | 0000-00-00          |                |
  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)