doc/database/db_diaspora-contact.md

   1 Table diaspora-contact
   2 ===========
   3
   4 Diaspora compatible contacts - used in the Diaspora implementation
   5
   6 Fields
   7 ------
   8
   9 | Field             | Description                                                  | Type         | Null | Key | Default             | Extra |
  10 | ----------------- | ------------------------------------------------------------ | ------------ | ---- | --- | ------------------- | ----- |
  11 | uri-id            | Id of the item-uri table entry that contains the contact URL | int unsigned | NO   | PRI | NULL                |       |
  12 | addr              |                                                              | varchar(255) | YES  |     | NULL                |       |
  13 | alias             |                                                              | varchar(255) | YES  |     | NULL                |       |
  14 | nick              |                                                              | varchar(255) | YES  |     | NULL                |       |
  15 | name              |                                                              | varchar(255) | YES  |     | NULL                |       |
  16 | given-name        |                                                              | varchar(255) | YES  |     | NULL                |       |
  17 | family-name       |                                                              | varchar(255) | YES  |     | NULL                |       |
  18 | photo             |                                                              | varchar(255) | YES  |     | NULL                |       |
  19 | photo-medium      |                                                              | varchar(255) | YES  |     | NULL                |       |
  20 | photo-small       |                                                              | varchar(255) | YES  |     | NULL                |       |
  21 | batch             |                                                              | varchar(255) | YES  |     | NULL                |       |
  22 | notify            |                                                              | varchar(255) | YES  |     | NULL                |       |
  23 | poll              |                                                              | varchar(255) | YES  |     | NULL                |       |
  24 | subscribe         |                                                              | varchar(255) | YES  |     | NULL                |       |
  25 | searchable        |                                                              | boolean      | YES  |     | NULL                |       |
  26 | pubkey            |                                                              | text         | YES  |     | NULL                |       |
  27 | gsid              | Global Server ID                                             | int unsigned | YES  |     | NULL                |       |
  28 | created           |                                                              | datetime     | NO   |     | 0001-01-01 00:00:00 |       |
  29 | updated           |                                                              | datetime     | NO   |     | 0001-01-01 00:00:00 |       |
  30 | interacting_count | Number of contacts this contact interacts with               | int unsigned | YES  |     | 0                   |       |
  31 | interacted_count  | Number of contacts that interacted with this contact         | int unsigned | YES  |     | 0                   |       |
  32 | post_count        | Number of posts and comments                                 | int unsigned | YES  |     | 0                   |       |
  33
  34 Indexes
  35 ------------
  36
  37 | Name    | Fields       |
  38 | ------- | ------------ |
  39 | PRIMARY | uri-id       |
  40 | addr    | UNIQUE, addr |
  41 | alias   | alias        |
  42 | gsid    | gsid         |
  43
  44 Foreign Keys
  45 ------------
  46
  47 | Field | Target Table | Target Field |
  48 |-------|--------------|--------------|
  49 | uri-id | [item-uri](help/database/db_item-uri) | id |
  50 | gsid | [gserver](help/database/db_gserver) | id |
  51
  52 Return to [database documentation](help/database)