I want to design a database to allow me to monitor my patients while on long term antibiotic treatments. Each will be on different regimes that might require weekly or monthly blood test monitoring. I would like to be able to enter the regime and the monitoring required into a table, and then use the database to remind me when a blood test is due. So each week I could run a query and it would tell me who was due a blood test. This would continue until the regime finished then the patient would be archived.
At the same time, I would like to be able to add the blood test abnormalities. these would be categorised as mild, mod, severe for the fields kidney, liver, skin, etc.
each patient may need repeated regimes at different times
in addition, the regime may change part way through and the monitoring required also need to change.
is this too complicated?