| Column | Type | Actions |
|---|---|---|
| team_id | int(10) unsigned | |
| team_name | varchar(100) | |
| team_code | varchar(50) | |
| team_leader_name | varchar(100) | |
| target_month | date | |
| target_amount | decimal(15,2) | |
| total_sales | decimal(34,2) | |
| total_payment_received | decimal(34,2) | |
| total_payment_remaining | decimal(34,2) | |
| total_tips | decimal(34,2) | |
| target_achieved_amount | decimal(15,2) | |
| achievement_percentage | decimal(43,6) | |
| target_status | enum('pending','active','achieved','failed') | |
| month_year | varchar(69) |