|
id
|
int(10) unsigned
|
|
|
|
|
username
|
varchar(30)
|
|
|
|
|
email
|
varchar(190)
|
|
|
|
|
email_verified_at
|
datetime
|
|
|
|
|
email_activation_exempt
|
tinyint(1)
|
|
|
0
|
|
password_hash
|
varchar(255)
|
|
|
|
|
api_token_hash
|
char(64)
|
|
|
|
|
activation_token_hash
|
char(64)
|
|
|
|
|
activation_expires_at
|
datetime
|
|
|
|
|
activation_sent_at
|
datetime
|
|
|
|
|
reset_token_hash
|
char(64)
|
|
|
|
|
reset_expires_at
|
datetime
|
|
|
|
|
reset_sent_at
|
datetime
|
|
|
|
|
bio
|
varchar(160)
|
|
|
|
|
avatar_url
|
varchar(500)
|
|
|
|
|
private_profile
|
tinyint(1)
|
|
|
0
|
|
allow_comments
|
tinyint(1)
|
|
|
1
|
|
discoverable
|
tinyint(1)
|
|
|
1
|
|
show_activity
|
tinyint(1)
|
|
|
1
|
|
role
|
enum
|
-- |
|
user
|
|
status
|
enum
|
-- |
|
active
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
terms_accepted_at
|
datetime
|
|
|
|
|
terms_version
|
varchar(64)
|
|
|
|
|
privacy_acknowledged_at
|
datetime
|
|
|
|
|
privacy_version
|
varchar(64)
|
|
|
|
|
marketing_opt_in
|
tinyint(1)
|
|
|
0
|
|
phone_verification_required
|
tinyint(1)
|
|
|
0
|
|
phone_verified_at
|
datetime
|
|
|
|
|
phone_e164
|
varchar(20)
|
|
|
|
|
firebase_phone_uid
|
varchar(128)
|
|
|
|