S
sammy
Hey Guys,
I am trying to create a schedule database for employee that do their jobs
based on a 30 minutes blocks. example
employeeA starts shift at 9:00 AM and Ends at 5:30 PM this employee would
have 2 service calls to do at client's location service1 from 10:00 AM to
12:00 PM and service2 from 1:30 to 3:30 PM.
I have employee table with all employee info like ID, Name, address
ServiceCalls table with callID employeeID ClientID TaskID and tasksLength
ClientsTable with all client's data
EmployeeSchedule table with employeeID, ShiftStartTime, ShiftEndTime
DaysTable with all DayID, OnDutyOrOff,
What i am trying to do is build a query to pull up the first available
employee to perform a specific task. my question is does the database design
make any sense to anyone, if not whats the best way to to achieve this goal?
Thanks for any input
Sammy
I am trying to create a schedule database for employee that do their jobs
based on a 30 minutes blocks. example
employeeA starts shift at 9:00 AM and Ends at 5:30 PM this employee would
have 2 service calls to do at client's location service1 from 10:00 AM to
12:00 PM and service2 from 1:30 to 3:30 PM.
I have employee table with all employee info like ID, Name, address
ServiceCalls table with callID employeeID ClientID TaskID and tasksLength
ClientsTable with all client's data
EmployeeSchedule table with employeeID, ShiftStartTime, ShiftEndTime
DaysTable with all DayID, OnDutyOrOff,
What i am trying to do is build a query to pull up the first available
employee to perform a specific task. my question is does the database design
make any sense to anyone, if not whats the best way to to achieve this goal?
Thanks for any input
Sammy