var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
clinic management database design
I have concern for this 3 tables:
The doctor can have 1 or more appointment. A patient can have 1 or more appointment. So the doctor and patient is associated through the appointment.
The doctor can provide 1 or more treatment. Each patient receives 1 or more treatment. So the doctor and patient is associated through the treatment.
The patient can go for 1 or more visits. A doctor can have 1 or more visits. The patient and doctor is associated through the visit.
Therefore how can visits and appointment be associated with treatment?.
Last edited by solomon13000; 07-27-09 at 11:34.
I carefully relook at my diagram and now I understand
However is it advisable to have a status attribute inside the visit class?
status: Arrived, Visited, Left