4 | Field | Description | Type | Null | Key | Default | Extra |
5 |--------------|-----------------------------------------------|--------------|------|-----|---------------------|----------------|
6 | id | sequential ID | int(11) | NO | PRI | NULL | auto_increment |
7 | uid | user.id of the owner of this data | int(11) | NO | | 0 | |
8 | profile-name | Name of the profile | varchar(255) | NO | | | |
9 | is-default | Mark this profile as default profile | tinyint(1) | NO | | 0 | |
10 | hide-friends | Hide friend list from viewers of this profile | tinyint(1) | NO | | 0 | |
11 | name | | varchar(255) | NO | | | |
12 | pdesc | Deprecated | varchar(255) | NO | | | |
13 | dob | Day of birth | varchar(32) | NO | | 0001-01-01 | |
14 | address | | varchar(255) | NO | | | |
15 | locality | | varchar(255) | NO | | | |
16 | region | | varchar(255) | NO | | | |
17 | postal-code | | varchar(32) | NO | | | |
18 | country-name | | varchar(255) | NO | | | |
19 | hometown | Deprecated | varchar(255) | NO | MUL | | |
20 | gender | Deprecated | varchar(32) | NO | | | |
21 | marital | Deprecated | varchar(255) | NO | | | |
22 | with | Deprecated | text | NO | | NULL | |
23 | howlong | Deprecated | datetime | NO | | 0001-01-01 00:00:00 | |
24 | sexual | Deprecated | varchar(255) | NO | | | |
25 | politic | Deprecated | varchar(255) | NO | | | |
26 | religion | Deprecated | varchar(255) | NO | | | |
27 | pub_keywords | | text | NO | | NULL | |
28 | prv_keywords | | text | NO | | NULL | |
29 | likes | Deprecated | text | NO | | NULL | |
30 | dislikes | Deprecated | text | NO | | NULL | |
31 | about | Profile description | text | NO | | | |
32 | summary | Deprecated | varchar(255) | NO | | | |
33 | music | Deprecated | text | NO | | NULL | |
34 | book | Deprecated | text | NO | | NULL | |
35 | tv | Deprecated | text | NO | | NULL | |
36 | film | Deprecated | text | NO | | NULL | |
37 | interest | Deprecated | text | NO | | NULL | |
38 | romance | Deprecated | text | NO | | NULL | |
39 | work | Deprecated | text | NO | | NULL | |
40 | education | Deprecated | text | NO | | NULL | |
41 | contact | Deprecated | text | NO | | NULL | |
42 | homepage | | varchar(255) | NO | | | |
43 | photo | | varchar(255) | NO | | | |
44 | thumb | | varchar(255) | NO | | | |
45 | publish | publish default profile in local directory | tinyint(1) | NO | | 0 | |
46 | net-publish | publish profile in global directory | tinyint(1) | NO | | 0 | |
48 Return to [database documentation](help/database)