|
id
|
bigint(20) unsigned
|
|
|
|
|
template_id
|
bigint(20) unsigned
|
|
|
|
|
title
|
varchar(180)
|
|
|
|
|
description
|
text
|
|
|
|
|
assigned_to_user_id
|
bigint(20) unsigned
|
|
|
|
|
assigned_by_user_id
|
bigint(20) unsigned
|
|
|
|
|
due_at
|
datetime
|
|
|
2026-08-09 01:25:57.000000
|
|
priority
|
enum
|
-- |
|
normal
|
|
proof_required
|
tinyint(1)
|
|
|
0
|
|
proof_path
|
varchar(255)
|
|
|
|
|
completion_remarks
|
text
|
|
|
|
|
points
|
decimal(8,2)
|
|
|
1.00
|
|
status
|
enum
|
-- |
|
pending
|
|
completed_at
|
datetime
|
|
|
|
|
approved_by
|
bigint(20) unsigned
|
|
|
|
|
approved_at
|
datetime
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
not_completed_reason
|
text
|
|
|
|
|
carried_forward_from_id
|
bigint(20) unsigned
|
|
|
|
|
approver_user_id
|
bigint(20) unsigned
|
|
|
|
|
tat_minutes
|
int(10) unsigned
|
|
|
|