| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| manager_id | int(11) | |
| employee_id | int(11) | |
| task_title | varchar(255) | |
| task_description | text | |
| task_type | enum('hourly','daily','weekly','monthly') | |
| estimated_hours | decimal(5,2) | |
| estimated_days | int(11) | |
| deadline | datetime | |
| priority | enum('low','medium','high','urgent') | |
| status | enum('pending','in_progress','completed','cancelled','submitted') | |
| assigned_at | timestamp | |
| completed_at | datetime | |
| created_at | timestamp | |
| submission_status | enum('not_submitted','submitted','approved','revision_requested') | |
| submitted_at | datetime | |
| revision_notes | text |