user profiles data
+Fields
+------
+
| Field | Description | Type | Null | Key | Default | Extra |
| ------------ | --------------------------------------------- | ------------------ | ---- | --- | ---------- | -------------- |
| id | sequential ID | int unsigned | NO | PRI | NULL | auto_increment |
| education | Deprecated | text | YES | | NULL | |
| contact | Deprecated | text | YES | | NULL | |
| homepage | | varchar(255) | NO | | | |
-| xmpp | | varchar(255) | NO | | | |
-| photo | | varchar(255) | NO | | | |
-| thumb | | varchar(255) | NO | | | |
+| 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)