doc/database/db_profile.md

   1 Table profile
   2 ===========
   3
   4 user profiles data
   5
   6 Fields
   7 ------
   8
   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 | profile-name      | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  14 | is-default        | Deprecated                                                     | boolean            | YES  |     | NULL       |                |
  15 | hide-friends      | Hide friend list from viewers of this profile                  | boolean            | NO   |     | 0          |                |
  16 | name              |                                                                | varchar(255)       | NO   |     |            |                |
  17 | pdesc             | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  18 | dob               | Day of birth                                                   | varchar(32)        | NO   |     | 0000-00-00 |                |
  19 | address           |                                                                | varchar(255)       | NO   |     |            |                |
  20 | locality          |                                                                | varchar(255)       | NO   |     |            |                |
  21 | region            |                                                                | varchar(255)       | NO   |     |            |                |
  22 | postal-code       |                                                                | varchar(32)        | NO   |     |            |                |
  23 | country-name      |                                                                | varchar(255)       | NO   |     |            |                |
  24 | hometown          | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  25 | gender            | Deprecated                                                     | varchar(32)        | YES  |     | NULL       |                |
  26 | marital           | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  27 | with              | Deprecated                                                     | text               | YES  |     | NULL       |                |
  28 | howlong           | Deprecated                                                     | datetime           | YES  |     | NULL       |                |
  29 | sexual            | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  30 | politic           | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  31 | religion          | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  32 | pub_keywords      |                                                                | text               | YES  |     | NULL       |                |
  33 | prv_keywords      |                                                                | text               | YES  |     | NULL       |                |
  34 | likes             | Deprecated                                                     | text               | YES  |     | NULL       |                |
  35 | dislikes          | Deprecated                                                     | text               | YES  |     | NULL       |                |
  36 | about             | Profile description                                            | text               | YES  |     | NULL       |                |
  37 | summary           | Deprecated                                                     | varchar(255)       | YES  |     | NULL       |                |
  38 | music             | Deprecated                                                     | text               | YES  |     | NULL       |                |
  39 | book              | Deprecated                                                     | text               | YES  |     | NULL       |                |
  40 | tv                | Deprecated                                                     | text               | YES  |     | NULL       |                |
  41 | film              | Deprecated                                                     | text               | YES  |     | NULL       |                |
  42 | interest          | Deprecated                                                     | text               | YES  |     | NULL       |                |
  43 | romance           | Deprecated                                                     | text               | YES  |     | NULL       |                |
  44 | work              | Deprecated                                                     | text               | YES  |     | NULL       |                |
  45 | education         | Deprecated                                                     | text               | YES  |     | NULL       |                |
  46 | contact           | Deprecated                                                     | text               | YES  |     | NULL       |                |
  47 | homepage          |                                                                | varchar(255)       | NO   |     |            |                |
  48 | homepage_verified | was the homepage verified by a rel-me link back to the profile | boolean            | NO   |     | 0          |                |
  49 | xmpp              | XMPP address                                                   | varchar(255)       | NO   |     |            |                |
  50 | matrix            | Matrix address                                                 | varchar(255)       | NO   |     |            |                |
  51 | photo             |                                                                | varbinary(383)     | NO   |     |            |                |
  52 | thumb             |                                                                | varbinary(383)     | NO   |     |            |                |
  53 | publish           | publish default profile in local directory                     | boolean            | NO   |     | 0          |                |
  54 | net-publish       | publish profile in global directory                            | boolean            | NO   |     | 0          |                |
  55
  56 Indexes
  57 ------------
  58
  59 | Name           | Fields                 |
  60 | -------------- | ---------------------- |
  61 | PRIMARY        | id                     |
  62 | uid_is-default | uid, is-default        |
  63 | pub_keywords   | FULLTEXT, pub_keywords |
  64
  65 Foreign Keys
  66 ------------
  67
  68 | Field | Target Table | Target Field |
  69 |-------|--------------|--------------|
  70 | uid | [user](help/database/db_user) | uid |
  71
  72 Return to [database documentation](help/database)