ID | NAME | JOB_ID | CURRENT_TASK_ID
--------------------------------------------
01 | Frank | 01 | 01
02 | Sharon | 01 | null
03 | John | 02 | 02
04 | Jennifer | 05 | 03
TASKS:
TASK_ID | COMMENT
-----------------------
01 | Project #1
02 | Project #2
03 | Project #3
CURRENT_TASK_ID field in EMPLOYEES table is a foreign key referring to TASK_ID field of TASKS table.
Login in to like
Login in to comment