I am making a database system where there are patients, doctors, categories and medical records.
- doctor and patient has a relationship called
treatments( many-to-many )
- patient and a relationship with medical record called
patient-records( one-to-many )
- medical record and categories has relationship called
How do I include the details and information of the medical record in the
treatment relationship? Should I make a joined query and get the details of record from the patient?
My goal is to create a full record for the patient where all their history, diagnoses, and treatments are available as a sheet or web page.