| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int |
10 |
|
√ |
|
|
| notify.id
|
Implied Constraint R |
|
| profile_guid |
char |
64 |
|
|
|
|
|
| aid |
int unsigned |
10 |
|
|
0 |
|
|
| uid |
int |
10 |
|
|
0 |
|
|
| profile_name |
char |
255 |
|
|
|
|
|
| is_default |
bit |
0 |
|
|
0 |
|
|
| hide_friends |
bit |
0 |
|
|
0 |
|
|
| name |
char |
255 |
|
|
|
|
|
| pdesc |
char |
255 |
|
|
|
|
|
| chandesc |
text |
65535 |
|
|
|
|
|
| dob |
char |
32 |
|
|
0000-00-00 |
|
|
| dob_tz |
char |
255 |
|
|
UTC |
|
|
| address |
char |
255 |
|
|
|
|
|
| locality |
char |
255 |
|
|
|
|
|
| region |
char |
255 |
|
|
|
|
|
| postal_code |
char |
32 |
|
|
|
|
|
| country_name |
char |
255 |
|
|
|
|
|
| hometown |
char |
255 |
|
|
|
|
|
| gender |
char |
32 |
|
|
|
|
|
| marital |
char |
255 |
|
|
|
|
|
| with |
text |
65535 |
|
|
|
|
|
| howlong |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| sexual |
char |
255 |
|
|
|
|
|
| politic |
char |
255 |
|
|
|
|
|
| religion |
char |
255 |
|
|
|
|
|
| keywords |
text |
65535 |
|
|
|
|
|
| likes |
text |
65535 |
|
|
|
|
|
| dislikes |
text |
65535 |
|
|
|
|
|
| about |
text |
65535 |
|
|
|
|
|
| summary |
char |
255 |
|
|
|
|
|
| music |
text |
65535 |
|
|
|
|
|
| book |
text |
65535 |
|
|
|
|
|
| tv |
text |
65535 |
|
|
|
|
|
| film |
text |
65535 |
|
|
|
|
|
| interest |
text |
65535 |
|
|
|
|
|
| romance |
text |
65535 |
|
|
|
|
|
| work |
text |
65535 |
|
|
|
|
|
| education |
text |
65535 |
|
|
|
|
|
| contact |
text |
65535 |
|
|
|
|
|
| channels |
text |
65535 |
|
|
|
|
|
| homepage |
char |
255 |
|
|
|
|
|
| photo |
char |
255 |
|
|
|
|
|
| thumb |
char |
255 |
|
|
|
|
|
| publish |
bit |
0 |
|
|
0 |
|
|
Table contained 4 rows at on aug 19 21:08 CEST 2015
|
