You do run into a rather unique situation that I'm not sure how your business model will address;
Client is seen.
Diagnosis is made.
Script of meds is written.
In my view, the important item would be the appointment in this case. One or more diagnosis will be made. Zero or more medications will be prescribed. Each prescription will have a quantity and expiration date. As such, a client can receive the same medication multiple times even if it is not for the same diagnosis.
This would imply a link between visit and medication that has an expiration date in it. Likewise you would go through visits to see what medications a patient is receiving. This aids tremendously when you are reporting on these things as the date of their visit becomes the "Starting" date for a prescription while each has its own ending date. This also avoids confusion when more than one diagnosis is given that would require the same medication.
Client is seen.
Diagnosis is made.
Script of meds is written.
In my view, the important item would be the appointment in this case. One or more diagnosis will be made. Zero or more medications will be prescribed. Each prescription will have a quantity and expiration date. As such, a client can receive the same medication multiple times even if it is not for the same diagnosis.
This would imply a link between visit and medication that has an expiration date in it. Likewise you would go through visits to see what medications a patient is receiving. This aids tremendously when you are reporting on these things as the date of their visit becomes the "Starting" date for a prescription while each has its own ending date. This also avoids confusion when more than one diagnosis is given that would require the same medication.
