| id |
int(11)
|
|
|
|
| name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| contact |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| age |
int(11)
|
|
|
|
| avatar_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| cover_gradient |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| cover_image_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| avatar_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| bio |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| privacy_default |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| message_privacy |
enum('everyone', 'friends_only')
|
utf8mb4_general_ci
|
|
|
| monetization_enabled |
tinyint(1)
|
|
|
|
| default_ad_enabled |
tinyint(1)
|
|
|
|
| preview_sound_enabled |
tinyint(1)
|
|
|
|
| is_admin |
tinyint(1)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| is_verified |
tinyint(1)
|
|
|
|
| is_disabled |
tinyint(1)
|
|
|
|
| suspended_until |
datetime
|
|
|
|
| social_links |
text
|
utf8mb4_general_ci
|
|
|
| show_profile_visits |
tinyint(1)
|
|
|
|
| google_id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| call_privacy |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| vp_duration_limit |
int(11)
|
|
|
|
| vp_quota_mb |
int(11)
|
|
|
|
| is_hidden |
tinyint(1)
|
|
|
|
| hidden_at |
datetime
|
|
|
|
| phone_hash |
char(64)
|
utf8mb4_general_ci
|
|
|
| email_hash |
char(64)
|
utf8mb4_general_ci
|
|
|
| country |
char(2)
|
utf8mb4_general_ci
|
|
|
| city |
varchar(60)
|
utf8mb4_general_ci
|
|
|