Building a Pharmaceutical Management System
The Client
Oasis Free Clinics is a non-profit, no-cost primary care medical practice and dental clinic, providing exceptional, patient-centered care to uninsured members of the Brunswick, ME community.
The Challenges
Developing an Inventory Sytem that stores a pharmaceutical and its generic names, brand names, strength, common uses, available units, and location in the clinic.
Including a search feature which would allow any user to look up a pharmaceutical based on generic name, brand name, or a common use.
Allowing the user to manage an individual pharmaceuitcal in order to adjust its available units.
The Solutions
Using a React front-end and a Spring backend to create a dynamic website. The website content will be generated using a REST API that also allows for all CRUD operations.
For requested search features, a many-to-many data model was used. Fundamentally, a pharmaceutical can have many common uses and a common use can be treated by many pharmaceuticals.
A separate page was created in order to make changes to the pharmaceutical. Here the user can modify any of its features, including the stock quantity.
