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