| id |
int(10)
|
|
|
|
| username |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| verified_first_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| verified_last_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| verified_full_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| verified_name_at |
datetime
|
|
|
|
| email |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| registration_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| registration_source_url |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| utm_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| utm_medium |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| utm_campaign |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| phone_verified |
tinyint(1)
|
|
|
|
| email_verified |
tinyint(1)
|
|
|
|
| google_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| facebook_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| apple_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| discord_id |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| avatar_url |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| notification_channel |
enum('sms', 'whatsapp', 'email')
|
utf8mb4_unicode_ci
|
|
|
| avatar |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| role |
enum('admin', 'user', 'seller')
|
utf8mb4_unicode_ci
|
|
|
| balance |
decimal(10,2)
|
|
|
|
| pending_balance |
decimal(10,2)
|
|
|
|
| trust_level |
enum('new', 'trusted', 'suspicious')
|
utf8mb4_unicode_ci
|
|
|
| stripe_customer_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| affiliate_balance |
decimal(15,2)
|
|
|
|
| status |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| ban_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| email_verified_at |
timestamp
|
|
|
|
| verification_code |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| verification_expires |
datetime
|
|
|
|
| remember_token |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_login_at |
timestamp
|
|
|
|
| last_login_ip |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| language |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| preferred_currency |
varchar(8)
|
utf8mb4_unicode_ci
|
|
|
| marketing_emails |
tinyint(1)
|
|
|
|
| marketing_email_consent_at |
datetime
|
|
|
|
| completed_quests |
int(11)
|
|
|
|
| current_rank_id |
int(11)
|
|
|
|
| sms_marketing_consent |
tinyint(1)
|
|
|
|
| sms_consent_date |
timestamp
|
|
|
|
| user_agent |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| device_fingerprint |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| username_changed_at |
datetime
|
|
|
|
| whatsapp_consent |
tinyint(1)
|
|
|
|
| whatsapp_consent_date |
datetime
|
|
|
|
| client_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_channel |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_detail |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| attribution_id |
char(32)
|
utf8mb4_unicode_ci
|
|
|
| signup_method |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_medium |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_campaign |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_term |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| first_touch_at |
datetime
|
|
|
|
| first_landing_page |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| first_referrer |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| last_touch_source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_touch_medium |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| last_touch_campaign |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| last_touch_at |
datetime
|
|
|
|
| last_gclid |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| last_fbclid |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| last_device_type |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| last_browser |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| last_os |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| twitch_id |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| xbox_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| steam_id |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| telegram_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| roblox_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| paypal_id |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| is_passwordless |
tinyint(1)
|
|
|
|
