| id |
bigint(20)
|
|
|
|
| template_id |
bigint(20)
|
|
|
|
| title |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| assigned_to_user_id |
bigint(20)
|
|
|
|
| assigned_by_user_id |
bigint(20)
|
|
|
|
| due_at |
datetime
|
|
|
|
| priority |
enum('low', 'normal', 'high', 'urgent')
|
utf8mb4_unicode_ci
|
|
|
| proof_required |
tinyint(1)
|
|
|
|
| proof_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| completion_remarks |
text
|
utf8mb4_unicode_ci
|
|
|
| points |
decimal(8,2)
|
|
|
|
| status |
enum('pending', 'in_progress', 'submitted', 'approved', 'rejected', 'overdue', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| completed_at |
datetime
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| not_completed_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| carried_forward_from_id |
bigint(20)
|
|
|
|
| approver_user_id |
bigint(20)
|
|
|
|
| tat_minutes |
int(10)
|
|
|
|
