Hello

* my HR manager will create tasks and assign to one or more employees
* Tasks has a dead line. ex : 5 days
* so when a task is assigned to employee(s), during the task execution period, those employees will keep adding status updates, so HR manager can see what is going on with a given task.

Table tasks

task_id (AI) | task | assigned | deadline
--------------------------------------
10 | take vehicle stocks | 10/12/2012 | 16/12/2012
11 | prepare time sheets | 12/12/2012 | 17/12/2012

Table status_updates

status_id (AI) | status | added_on | by (empno)
---------------------------------------
16 | just started with the yard A | 12/12/2012 | 2340
17 | 200 vehicles finished in yard A | 13/12/2012 | 2340

now when a comment is added to a task, where can i link that status with the particulate task?
should i add another column in status_updates table as task_id ?

so it will be

task_id | status_id (AI) | status | added_on | by (empno)
---------------------------------------
10 | 16 | just started with the yard A | 12/12/2012 | 2340
10 | 17 | 200 vehicles finished in yard A | 13/12/2012 | 2340