| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| employee_code | varchar(50) | |
| full_name | varchar(100) | |
| varchar(100) | ||
| phone | varchar(20) | |
| department | enum('Sales','Design','Development','Marketing') | |
| designation | varchar(50) | |
| joining_date | date | |
| basic_salary | decimal(10,2) | |
| profile_picture | varchar(255) | |
| password | varchar(255) | |
| reset_token | varchar(255) | |
| reset_token_expiry | datetime | |
| email_verified | tinyint(1) | |
| must_change_password | tinyint(1) | |
| status | tinyint(1) | |
| access_restricted | tinyint(1) | |
| created_by_hr | int(11) | |
| 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') |