| Field | Description | Type | Null | Key | Default |
|---|
| id | | int(11) | NO | PRI | NULL |
| profile_guid | | char(64) | NO | MUL | |
| aid | | int(10) unsigned | NO | MUL | 0 |
| uid | | int(11) | NO | MUL | 0 |
| profile_name | | char(191) | NO | | |
| is_default | | tinyint(1) | NO | MUL | 0 |
| hide_friends | | tinyint(1) | NO | MUL | 0 |
| fullname | | char(191) | NO | | |
| pdesc | | char(191) | NO | | |
| chandesc | | text | NO | | |
| dob | | char(32) | NO | | 0000-00-00 |
| dob_tz | | char(191) | NO | | UTC |
| address | | char(191) | NO | | |
| locality | | char(191) | NO | MUL | |
| region | | char(191) | NO | | |
| postal_code | | char(32) | NO | MUL | |
| country_name | | char(191) | NO | MUL | |
| hometown | | char(191) | NO | MUL | |
| gender | | char(32) | NO | MUL | |
| marital | | char(191) | NO | MUL | |
| partner | | text | NO | | |
| howlong | | datetime | NO | | 0001-01-01 00:00:00 |
| sexual | | char(191) | NO | MUL | |
| politic | | char(191) | NO | | |
| religion | | char(191) | NO | | |
| keywords | | text | NO | | |
| likes | | text | NO | | |
| dislikes | | text | NO | | |
| about | | text | NO | | |
| summary | | char(191) | NO | | |
| music | | text | NO | | |
| book | | text | NO | | |
| tv | | text | NO | | |
| film | | text | NO | | |
| interest | | text | NO | | |
| romance | | text | NO | | |
| employment | | text | NO | | |
| education | | text | NO | | |
| contact | | text | NO | | |
| channels | | text | NO | | |
| homepage | | char(191) | NO | | |
| photo | | char(191) | NO | | |
| thumb | | char(191) | NO | | |
| publish | | tinyint(1) | NO | MUL | 0 |
| profile_vcard | | text | NO | | |
➔ Datenbank