| id |
int(11)
|
|
|
|
| task_code |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(180)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| source |
enum('management', 'verbal_instruction', 'meeting', 'phone_call', 'chat_message', 'email', 'other')
|
utf8mb4_general_ci
|
|
|
| requestor_user_id |
int(11)
|
|
|
|
| responsible_user_id |
int(11)
|
|
|
|
| accountable_user_id |
int(11)
|
|
|
|
| department |
varchar(140)
|
utf8mb4_general_ci
|
|
|
| expected_result |
text
|
utf8mb4_general_ci
|
|
|
| actual_result |
text
|
utf8mb4_general_ci
|
|
|
| priority |
enum('low', 'normal', 'high', 'urgent')
|
utf8mb4_general_ci
|
|
|
| start_date |
date
|
|
|
|
| deadline |
date
|
|
|
|
| status |
enum('draft', 'for_confirmation', 'confirmed', 'not_started', 'in_progress', 'blocked', 'for_review', 'returned', 'completed', 'cancelled')
|
utf8mb4_general_ci
|
|
|
| progress_percent |
tinyint(3)
|
|
|
|
| blocker |
text
|
utf8mb4_general_ci
|
|
|
| confirmed_by |
int(11)
|
|
|
|
| confirmed_at |
datetime
|
|
|
|
| completed_at |
datetime
|
|
|
|
| is_deleted |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|