scheduling table design
От | Barnes |
---|---|
Тема | scheduling table design |
Дата | |
Msg-id | 001801bf7e1d$ca3c15f0$0a64a8c0@fries обсуждение исходный текст |
Ответ на | Re: [GENERAL] temporary tables ("omid omoomi" <oomoomi@hotmail.com>) |
Список | pgsql-general |
I'm trying to build what amounts to an appointment book for a doctor's office. The office has multiple doctors, and my application is going to handle patient appointment scheduling for all the doctors(among many other things). Anyway, I am looking for advice on database table design. I'll be tracking the date and time of the appointment, the doctor, reason for the appointment, insurance company authorization and the patient's name. I'll also need to be able to view open appointment blocks, and I would like as much flexibility as possible in setting the times of appointments. If anyone has any suggestions or advice regarding table design, I would really appreciate it. I'm not sure at all where to start. With things like open appointments, this seems much more complex than the typical name, address, phone number databases I've done in the past. Thank you for any help. David Barnes
В списке pgsql-general по дате отправления: