I want idea about creating of system
Posted: Tue Sep 13, 2011 5:48 am
hi
what table i should create in MySQL for this system:
patient select one doctor from doctor list and see all vacant visit time and then patient select one time to get appointment to visit doctor.
how i should consider time and day of appointment . should i create table for appointment ? how i recognize vacant time of doctor?
i haven't any idea . help me
what i should consider to create system that let patient to see vacant time of doctor and let he to select time for visit of doctor
how i should consider vacant time of any doctor?
assume that doctors in any 30 minute visit one patient
thank alot
what table i should create in MySQL for this system:
patient select one doctor from doctor list and see all vacant visit time and then patient select one time to get appointment to visit doctor.
how i should consider time and day of appointment . should i create table for appointment ? how i recognize vacant time of doctor?
i haven't any idea . help me
what i should consider to create system that let patient to see vacant time of doctor and let he to select time for visit of doctor
how i should consider vacant time of any doctor?
assume that doctors in any 30 minute visit one patient
thank alot