| id |
int(11)
|
|
|
|
| logid |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| username |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| mb_limit |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| mb_comid |
int(11)
|
|
|
|
| mb_link_str |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| department |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| position |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| is_locked |
tinyint(4)
|
|
|
|
| last_login_time |
datetime
|
|
|
|
| last_login_ip |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| login_count |
int(11)
|
|
|
|
| last_password_change |
datetime
|
|
|
|
| create_date |
datetime
|
|
|
|
| create_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| last_modify_date |
datetime
|
|
|
|
| last_modify_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
