- 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.
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
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
I think you need 3 tables
tasks like you have
task_id, task, assigned, deadline
ststus_id,task_Id, status, Added_on,EmployeeId