| id |
int(11)
|
|
|
|
| username |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| fullname |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| email |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| role_id |
int(11)
|
|
|
|
| department_id |
int(11)
|
|
|
|
| phone |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| avatar |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| signature_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_file |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| active |
tinyint(1)
|
|
|
|
| last_login |
datetime
|
|
|
|
| position |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| activation_code |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| qr_token |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| activated |
tinyint(1)
|
|
|
|
| signature_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_serial |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| certificate_subject |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_issuer |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_from |
date
|
|
|
|
| certificate_to |
date
|
|
|
|
| default_signer |
tinyint(4)
|
|
|
|
