| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| employee_code | varchar(30) | |
| full_name | varchar(100) | |
| varchar(100) | ||
| phone | varchar(20) | |
| password | varchar(255) | |
| department | varchar(50) | |
| designation | varchar(50) | |
| joining_date | date | |
| basic_salary | decimal(10,2) | |
| profile_picture | varchar(255) | |
| status | tinyint(1) | |
| created_at | timestamp | |
| device_number | varchar(64) | |
| device_public_key | text | |
| device_name | varchar(255) | |
| device_registered_at | datetime | |
| device_last_seen_at | datetime | |
| device_last_seen_ip | varchar(45) | |
| device_status | enum('pending','active','blocked','revoked') |