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