Calander database structure?
Posted by: H Yowza
Date: March 15, 2006 04:25AM

I'm trying to design a calander system. Basically a customer calls in to a ISP service center to make an appointment to send out a technician so they can do a cable installation. Each call is a maximum of 1 hour i.e. 9-10am, 10-11am. The call outs are from 9am to 5pm. The technical support representitive queries the database for available times and dates (i.e. he/she searches one week in advance). A scren like this should come up:

http://img114.imageshack.us/img114/9008/untitled7tr1.jpg

As you can see theres a couple of freeslots (john is a technician) the technical support chooses this time for the customer. Now what i don't get is the database design. How am i suppose to store information about a date and wether it has been already taken or if it's free.

Options: ReplyQuote


Subject
Written By
Posted
Calander database structure?
March 15, 2006 04:25AM
March 17, 2006 05:06AM


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.