Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-03 : 08:03:50
|
| Sammy writes "Hi,I am having a hard time to come up with a decent db design to do this job.I work in a landscaping company. We have about 40 employees who we dispach to perform the jobs when clients call and ask for the service.what I am try to do is to create an app with sql db backend to handle the booking task for these guys & gals.the work is done in 30 minutes time slots and this is what I am trying to figure out.Lets say a client calls and wants the service done on May 1 2006 at 8:30 PM, I want our dispach to do a search based on that Date and Time and find the available techs.so far I have the following tables.Employees TableE_IDFnameLnameLocationPhoneSchedule tableS_IDStartTimeEndTimeCalls tableC_IDEmpIDClientIDCallSkuDateTimeStatusSku tableSku_IDS_descriptionLength --->hours to perform taskthats all I have so far the and what I am hoping for help is how to create a weekly schedule for these techs and how to be able to perform the search on who is available based on a specific Date and Time.If you guys need any other information I will be more than happy to provide itThanksSammy" |
|
|
|
|
|
Schedule DB design