]> git.mxchange.org Git - friendica.git/blob - doc/database/db_profile.md
add the homepage_verified field to the profile table and the owner-view
[friendica.git] / 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)