|
id
|
int(11)
|
|
|
|
|
organisation_id
|
int(11)
|
|
|
1
|
|
related_to
|
int(11)
|
|
|
|
|
related_preferred_communication
|
enum
|
-- |
|
|
|
parent_task_id
|
int(11)
|
|
|
|
|
is_subtask
|
int(11)
|
|
|
0
|
|
is_recurring
|
tinyint(1)
|
|
|
0
|
|
subtask_order
|
int(11)
|
|
|
|
|
sector_id
|
int(11)
|
|
|
|
|
responsible_person_id
|
int(11)
|
|
|
|
|
responsible_preferred_communication
|
enum
|
-- |
|
|
|
supervisor_id
|
int(11)
|
|
|
|
|
supervisor_preferred_communication
|
enum
|
-- |
|
|
|
title
|
varchar(255)
|
|
|
|
|
short_description
|
text
|
|
|
|
|
long_description
|
text
|
|
|
|
|
from_date
|
date
|
|
|
|
|
till_date
|
date
|
|
|
|
|
subtask_offset
|
int(11)
|
|
|
0
|
|
completion_time
|
enum
|
-- |
|
|
|
file_name
|
varchar(255)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
task_status
|
enum
|
-- |
|
not_started
|
|
is_informed
|
tinyint(1)
|
|
|
0
|
|
is_execut_informed
|
tinyint(1)
|
|
|
0
|
|
is_respon_informed
|
tinyint(1)
|
|
|
0
|
|
execut_informed_on
|
datetime
|
|
|
|
|
respon_informed_on
|
datetime
|
|
|
|
|
execut_informed_by
|
int(11)
|
|
|
|
|
respon_informed_by
|
int(11)
|
|
|
|
|
informed_on
|
datetime
|
|
|
|
|
informed_by
|
int(11)
|
|
|
|
|
partially_completed_reason_id
|
int(11)
|
|
|
|
|
partially_completed_notes
|
text
|
|
|
|
|
is_extended
|
tinyint(1)
|
|
|
0
|
|
original_task_id
|
int(11)
|
|
|
|
|
extension_days
|
int(11)
|
|
|
0
|
|
extension_date
|
date
|
|
|
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 09:33:46.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|
|
is_communication_task
|
tinyint(1)
|
|
|
0
|
|
communication_type
|
enum
|
-- |
|
|
|
communication_to
|
enum
|
-- |
|
staff
|
|
contact_info
|
varchar(255)
|
|
|
|
|
original_communication_title
|
text
|
|
|
|