manual_task


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
manual_task_log.task_id fk_manual_task_log_task_idx R
task_name VARCHAR 100 null
description VARCHAR 1000 √ null
assigned_user_id INT 10 null
sys_users.user_id fk_manual_task_sys_user_assigned_idx R
accountable_user_id INT 10 null
sys_users.user_id fk_manual_task_sys_user_accountable_idx R
store_id INT 10 √ null
site.id fk_manual_task_site_idx R
project_id INT 10 √ null
project.id fk_manual_task_project_idx R
project_list_id INT 10 √ null
projectlist_custom.id fk_manual_task_project_list_idx R
create_date DATETIME 19 null
created_by_id INT 10 null
sys_users.user_id fk_manual_task_created_by_idx R
last_update_by_id INT 10 √ null
sys_users.user_id fk_manual_task_updated_by_idx R
last_update_date DATETIME 19 null
due_date DATE 10 √ null
completed_date DATETIME 19 √ null
last_edited_date DATETIME 19 √ null
assigned_read_date DATETIME 19 √ null
scheduled_completion_date DATETIME 19 √ null
deleted BIT 1 √ b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_manual_task_created_by_idx Performance Asc created_by_id
fk_manual_task_project_idx Performance Asc project_id
fk_manual_task_project_list_idx Performance Asc project_list_id
fk_manual_task_site_idx Performance Asc store_id
fk_manual_task_sys_user_accountable_idx Performance Asc accountable_user_id
fk_manual_task_sys_user_assigned_idx Performance Asc assigned_user_id
fk_manual_task_updated_by_idx Performance Asc last_update_by_id

Relationships

Close relationships within degrees of separation