| id |
int(11)
|
|
|
|
| company_id |
int(11)
|
|
|
|
| branch_id |
int(11)
|
|
|
|
| role_id |
int(11)
|
|
|
|
| employee_id |
int(11)
|
|
|
|
| user_type |
enum('admin', 'staff', 'teacher', 'accountant', 'librarian', 'security', 'parent', 'student', 'other')
|
utf8mb4_unicode_ci
|
|
|
| full_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| username |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| profile_photo |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| password_hash |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_unicode_ci
|
|
|
| force_password_change |
tinyint(4)
|
|
|
|
| last_login_at |
datetime
|
|
|
|
| last_login_ip |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| login_attempts |
int(11)
|
|
|
|
| locked_until |
datetime
|
|
|
|
| is_super_admin |
tinyint(4)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| delete_status |
tinyint(4)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|