Medical database structural build problems
I have been using a database I designed (with tremendous help from this forum). It has primarly been an invoice databae.
Now I want to add my medical record keeping and need some help pulling it off. I have the following tables that I need to relate.
CASES (each patient may come for multple cases or for mutliple reasons over time)
TREATMENTS (each patent will receive multiple treatments but each treatment will be realated to only one case)
INVOICES (Currently I am planning to keep the treatments and the cases seperate from the invoices but it could be helpful to link them)
I am attaching a screenshot of the current setup.