Hi, I am using db 18C XE AND APEX 21.1. I am designing a database for private clinics. A private clinic is a place where patients get diagnosed. The clinic has only one doctor and an assistant or two. The assistant records the patients' data and visits(admission) data. The patient gets diagnosed at the first visit and get a prescription with the drugs they should take. Then a follow-up or more visits follows afterward i.e the second visit is after two weeks then a third one after a month and so on. Each follow-up has a new prescription or maybe the same prescription if the doctor thinks there is no need for a new drug. The patient could be diagnosed for a disease then gets cured after a number of visits. Then he could visit the clinic again after a year or two for a different complain. The same process occurs again. I am attaching a photo of the part of the visits, examining and follow-ups. I want to be sure if I designed it correctly.
