bad design?
Posted by: osman afridi
Date: August 25, 2011 10:17AM

I have a bookings table in my database for shifts for employees.

When an employer offers an employee a shift there is a field called status which is updated to 'offered'. However the employer can offer it to multiple employees so I create a new row in the database everytime it is offered. i.e

employer status employee job
John offered Mark job1
John offered Dave job1


When the employee who is offered the booking accepts it updates that row to status accepted and updates any other row with that job to status taken.

If the employee rejects it it updates his row to status 'rejected'. So:

1. Mark accepts:

John Accepted Mark Job1
John Taken Dave Job1

2. and Dave rejects
John Offered Mark Job1
John Rejected Dave Job1

I'm completely new to the world of databases and I just wondered if that was poor design?

Options: ReplyQuote


Subject
Written By
Posted
bad design?
August 25, 2011 10:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.