Appointment booking database help please...?Im making an Optician appointment booking system (where customers can book an appointment.)
I have these tables:
Customer table (customer ID,title,gender,Date of birth,surname,forename, address,tel no and notes)
Optometrist table (optometrist ID, title,gender,date of birth, surname,forename and notes)
Appointment type table (Appointment type, description of appointment)
Appointment table (Appointment ID, customer ID, optometrist ID, date of appointment, start time, duration of appointment, appointment type)
Appointment type means there are different types of appointments e.g. lens check, eye check up, eye tests, repairing glasses.
Are these tables okay? I need to make sure that the optometrist cant book an appointment with 2 or more people at the same time. Also all the optometrists are qualified to carry out the appointment types and any optometrist can view any patient.
Each of the appointments have a different duration: eye check up/eye tests last 10 minutes and lens check/repairing glasses last 30 minutes :/
And how do I make sure that the optometrist cant book an appointment with 2 or more people at the same time on the same date?
0 коммент.:
Post a Comment