| id |
int(10)
|
|
|
|
| name |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| role |
enum('admin', 'manager', 'sales', 'accountant', 'inventory', 'custom')
|
utf8mb4_unicode_ci
|
|
|
| permissions |
longtext
|
utf8mb4_bin
|
|
|
| avatar |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'disabled')
|
utf8mb4_unicode_ci
|
|
|
| last_login_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| avatar_seed |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| avatar_style |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| employee_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| job_title |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| department |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| session_version |
int(10)
|
|
|
|
