I have two tables, let's call them
leave_request and the other one
The employee submit a
leave_request to take a vacation where he has to fill place of vacation, date of start, date of end, reason etc.
The boss of that employee will proceed that request and decide whether the employee can take the vacation or not. If he gives him one,
leave_given is filled with the details that the employee gave (date start and date end might change as the boss may not like the dates).
Now, regarding the 'Status' of the request. I was first thinking that If
leave_request is not found on
leave_given then It's rejected If it's there then It's accepted which I believe make sense.
I'm however writing an application and I want the user to know If the request has not been proceed yet so I will have to add a
My question is, does it make sense to do the following:
- Once the employee make a request, Status is on hold by default.
- If the boss accepts it,
statuswill change to Accepted and It will be added to
leave_given. If rejected, the status will change to Rejected and nothing will be added to