| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| employee_id | varchar(50) | |
| employee_name | varchar(200) | |
| designation | varchar(100) | |
| cnic | varchar(20) | |
| department | varchar(100) | |
| basic_salary | decimal(15,2) | |
| commission | decimal(15,2) | |
| allowance | decimal(15,2) | |
| overtime | decimal(15,2) | |
| deduction_name | varchar(100) | |
| deduction_amount | decimal(15,2) | |
| total_salary | decimal(15,2) | |
| salary_month | int(11) | |
| salary_year | int(11) | |
| created_at | datetime | |
| team_commission | decimal(14,2) |