| id |
int(11)
|
|
|
|
| login |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| hashed_password |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| firstname |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| lastname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| admin |
tinyint(1)
|
|
|
|
| status |
int(11)
|
|
|
|
| last_login_on |
datetime
|
|
|
|
| language |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| auth_source_id |
int(11)
|
|
|
|
| created_on |
timestamp
|
|
|
|
| updated_on |
timestamp
|
|
|
|
| type |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| mail_notification |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| salt |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| must_change_passwd |
tinyint(1)
|
|
|
|
| passwd_changed_on |
datetime
|
|
|
|
| twofa_scheme |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| twofa_totp_key |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| twofa_totp_last_used_at |
int(11)
|
|
|
|
| twofa_required |
tinyint(1)
|
|
|
|
