Contents
xprof - stores searchable public profile information on directory servers| Field | Description | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|---|
| xprof_hash | xchan.xchan_hash of this channel | char(255) | NO | PRI | NULL | |
| xprof_age | current age (updated monthly) | tinyint(3) unsigned | NO | MUL | 0 | |
| xprof_desc | char(255) | NO | MUL | |||
| xprof_dob | char(12) | NO | MUL | |||
| xprof_gender | char(255) | NO | MUL | |||
| xprof_marital | char(255) | NO | MUL | |||
| xprof_sexual | char(255) | NO | MUL | |||
| xprof_locale | char(255) | NO | MUL | |||
| xprof_region | char(255) | NO | MUL | |||
| xprof_postcode | char(32) | NO | MUL | |||
| xprof_country | char(255) | NO | MUL | |||
| xprof_keywords | text | NO | NULL | |||
| xprof_about | text | NO | NULL | |||
| xprof_homepage | char(255) | NO | ||||
| xprof_hometown | char(255) | NO | MUL |
Return to database documentation