Let's discuss the scenario,
When a job is not assigned by anyone, the assigned person is field is null
When it is assigned, the field will contain some value, say the assigned person's id
Next the assigned person will review the assigned task to decide whether he accepts or not
I let the supervisor to get the unassigned tasks by
select * from IssueLog where personnel_id IS NULL
Next how do I allow the person who will get assigned the job to get the jobs he has not reviewed, but newly assigned by the supervisor?
Do I make a new boolean field for this? or are there any more "better" practice way?