manual_task_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
user_id INT 10 null
sys_users.user_id fk_manual_task_log_user_idx R
proxy_user_id INT 10 √ null
sys_users.user_id fk_manual_task_log_proxy_user_idx R
task_id INT 10 null
manual_task.id fk_manual_task_log_task_idx R
subject LONGTEXT 2147483647 √ null
message LONGTEXT 2147483647 √ null
timestamp DATETIME 23 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_manual_task_log_proxy_user_idx Performance Asc proxy_user_id
fk_manual_task_log_task_idx Performance Asc task_id
fk_manual_task_log_user_idx Performance Asc user_id

Relationships

Close relationships within degrees of separation