|
id
|
int(11)
|
|
|
|
|
title
|
varchar(255)
|
|
|
|
|
description
|
text
|
|
|
|
|
client_id
|
int(11)
|
|
|
Browse foreign values
|
|
assigned_to
|
int(11)
|
|
|
|
|
assigned_by
|
int(11)
|
|
|
|
|
team
|
varchar(50)
|
|
|
|
|
task_type
|
varchar(50)
|
|
|
|
|
priority
|
varchar(20)
|
|
|
medium
|
|
status
|
varchar(30)
|
|
|
not_started
|
|
deadline
|
datetime
|
|
|
|
|
estimated_time_minutes
|
int(11)
|
|
|
|
|
started_at
|
datetime
|
|
|
|
|
completed_at
|
datetime
|
|
|
|
|
parent_task_id
|
int(11)
|
|
|
|
|
is_recurring
|
tinyint(1)
|
|
|
0
|
|
recurring_task_id
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
assigned_by_team
|
varchar(50)
|
|
|
|