Table profile
-=============
-
-| Field | Description | Type | Null | Key | Default | Extra |
-|--------------|-----------------------------------------------|--------------|------|-----|---------------------|----------------|
-| id | sequential ID | int(11) | NO | PRI | NULL | auto_increment |
-| uid | user.id of the owner of this data | int(11) | NO | | 0 | |
-| profile-name | Name of the profile | varchar(255) | NO | | | |
-| is-default | Mark this profile as default profile | tinyint(1) | NO | | 0 | |
-| hide-friends | Hide friend list from viewers of this profile | tinyint(1) | NO | | 0 | |
-| name | | varchar(255) | NO | | | |
-| pdesc | Deprecated | varchar(255) | NO | | | |
-| dob | Day of birth | varchar(32) | NO | | 0001-01-01 | |
-| address | | varchar(255) | NO | | | |
-| locality | | varchar(255) | NO | | | |
-| region | | varchar(255) | NO | | | |
-| postal-code | | varchar(32) | NO | | | |
-| country-name | | varchar(255) | NO | | | |
-| hometown | Deprecated | varchar(255) | NO | MUL | | |
-| gender | Deprecated | varchar(32) | NO | | | |
-| marital | Deprecated | varchar(255) | NO | | | |
-| with | Deprecated | text | NO | | NULL | |
-| howlong | Deprecated | datetime | NO | | 0001-01-01 00:00:00 | |
-| sexual | Deprecated | varchar(255) | NO | | | |
-| politic | Deprecated | varchar(255) | NO | | | |
-| religion | Deprecated | varchar(255) | NO | | | |
-| pub_keywords | | text | NO | | NULL | |
-| prv_keywords | | text | NO | | NULL | |
-| likes | Deprecated | text | NO | | NULL | |
-| dislikes | Deprecated | text | NO | | NULL | |
-| about | Profile description | text | NO | | | |
-| summary | Deprecated | varchar(255) | NO | | | |
-| music | Deprecated | text | NO | | NULL | |
-| book | Deprecated | text | NO | | NULL | |
-| tv | Deprecated | text | NO | | NULL | |
-| film | Deprecated | text | NO | | NULL | |
-| interest | Deprecated | text | NO | | NULL | |
-| romance | Deprecated | text | NO | | NULL | |
-| work | Deprecated | text | NO | | NULL | |
-| education | Deprecated | text | NO | | NULL | |
-| contact | Deprecated | text | NO | | NULL | |
-| homepage | | varchar(255) | NO | | | |
-| photo | | varchar(255) | NO | | | |
-| thumb | | varchar(255) | NO | | | |
-| publish | publish default profile in local directory | tinyint(1) | NO | | 0 | |
-| net-publish | publish profile in global directory | tinyint(1) | NO | | 0 | |
+===========
+
+user profiles data
+
+Fields
+------
+
+| Field | Description | Type | Null | Key | Default | Extra |
+| ----------------- | -------------------------------------------------------------- | ------------------ | ---- | --- | ---------- | -------------- |
+| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
+| uid | Owner User id | mediumint unsigned | NO | | 0 | |
+| profile-name | Deprecated | varchar(255) | YES | | NULL | |
+| is-default | Deprecated | boolean | YES | | NULL | |
+| hide-friends | Hide friend list from viewers of this profile | boolean | NO | | 0 | |
+| name | | varchar(255) | NO | | | |
+| pdesc | Deprecated | varchar(255) | YES | | NULL | |
+| dob | Day of birth | varchar(32) | NO | | 0000-00-00 | |
+| address | | varchar(255) | NO | | | |
+| locality | | varchar(255) | NO | | | |
+| region | | varchar(255) | NO | | | |
+| postal-code | | varchar(32) | NO | | | |
+| country-name | | varchar(255) | NO | | | |
+| hometown | Deprecated | varchar(255) | YES | | NULL | |
+| gender | Deprecated | varchar(32) | YES | | NULL | |
+| marital | Deprecated | varchar(255) | YES | | NULL | |
+| with | Deprecated | text | YES | | NULL | |
+| howlong | Deprecated | datetime | YES | | NULL | |
+| sexual | Deprecated | varchar(255) | YES | | NULL | |
+| politic | Deprecated | varchar(255) | YES | | NULL | |
+| religion | Deprecated | varchar(255) | YES | | NULL | |
+| pub_keywords | | text | YES | | NULL | |
+| prv_keywords | | text | YES | | NULL | |
+| likes | Deprecated | text | YES | | NULL | |
+| dislikes | Deprecated | text | YES | | NULL | |
+| about | Profile description | text | YES | | NULL | |
+| summary | Deprecated | varchar(255) | YES | | NULL | |
+| music | Deprecated | text | YES | | NULL | |
+| book | Deprecated | text | YES | | NULL | |
+| tv | Deprecated | text | YES | | NULL | |
+| film | Deprecated | text | YES | | NULL | |
+| interest | Deprecated | text | YES | | NULL | |
+| romance | Deprecated | text | YES | | NULL | |
+| work | Deprecated | text | YES | | NULL | |
+| education | Deprecated | text | YES | | NULL | |
+| contact | Deprecated | text | YES | | NULL | |
+| homepage | | varchar(255) | NO | | | |
+| homepage_verified | was the homepage verified by a rel-me link back to the profile | boolean | NO | | 0 | |
+| xmpp | XMPP address | varchar(255) | NO | | | |
+| matrix | Matrix address | varchar(255) | NO | | | |
+| photo | | varbinary(383) | NO | | | |
+| thumb | | varbinary(383) | NO | | | |
+| publish | publish default profile in local directory | boolean | NO | | 0 | |
+| net-publish | publish profile in global directory | boolean | NO | | 0 | |
+
+Indexes
+------------
+
+| Name | Fields |
+| -------------- | ---------------------- |
+| PRIMARY | id |
+| uid_is-default | uid, is-default |
+| pub_keywords | FULLTEXT, pub_keywords |
+
+Foreign Keys
+------------
+
+| Field | Target Table | Target Field |
+|-------|--------------|--------------|
+| uid | [user](help/database/db_user) | uid |
Return to [database documentation](help/database)
projects / friendica.git / blobdiff