| id |
int(11)
|
|
|
|
| username |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| update_time |
datetime(6)
|
|
|
|
| first_name |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| emp_pin |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(254)
|
utf8mb4_general_ci
|
|
|
| tele_phone |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| auth_time_dept |
int(11)
|
|
|
|
| login_id |
int(11)
|
|
|
|
| login_type |
int(11)
|
|
|
|
| login_count |
int(11)
|
|
|
|
| is_staff |
tinyint(1)
|
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| is_superuser |
tinyint(1)
|
|
|
|
| is_public |
tinyint(1)
|
|
|
|
| can_manage_all_dept |
tinyint(1)
|
|
|
|
| del_flag |
int(11)
|
|
|
|
| date_joined |
datetime(6)
|
|
|
|
| last_login |
datetime(6)
|
|
|
|
| session_key |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| login_ip |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| photo |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| assign_company |
int(11)
|
|
|
|
| password_reset |
datetime(6)
|
|
|
|