DOSE DECODER

Dose Decoder is a web-based system that uses machine learning to accurately interpret medication names, images, and prescription details, providing clear dosage and usage information.Designed to improve safety and efficiency, it assists healthcare providers and patients in minimizing prescription errors through quick, reliable medication insights. 5.1.1.Users Table This table stores information about users who access the system, such as patients or healthcare providers.Key Attributes: Includes fields like `user_id`, `username`, `email`, and `password`.Each user has a unique identifier to differentiate individual users. Medicines TableThis table stores essential details about each medicine, allowing the system to recognize, categorize, and provide information about different drugs.Key Attributes: Fields include `medicine_id`, `name`, `description`, `dosage_form` (e.g., tablet, syrup), `strength` (e.g., 500mg), and `manufacturer`.These attributes help uniquely identify each medicine and provide its specifics for output. 5.1.3Images Table Since image recognition plays a role in the project, the images table stores all uploaded images of medicines and prescriptions.This helps link each medicine to an image and enables the machine learning model to process visual data.Key Attributes: Contains `image_id`, `image_path`, and `uploaded_at`.Each image is given a unique identifier and a reference path for retrieval when needed. 5.1.4Prescriptions Table This table is essential for storing the content of a user's prescription, which might be entered as text or extracted from an uploaded image.This links to medicines and dosage details.Key Attributes:Contains fields like `prescription_id`, `user_id` (reference to who owns the prescription), and `prescription_text`.The text field captures the prescription's contents for later processing and reference. Medicine Prescriptions Table (Join Table)Prescriptions often list multiple medicines with specific dosages, frequencies, and durations.This table links the `Prescriptions` and `Medicines` tables to specify these details.Key Attributes: Includes `prescription_id`, `medicine_id`, `dosage`, `frequency`, and `duration`.This structure provides the flexibility to store various medicine details related to each prescription and allows customization of the dosage and timing for each entry. Medicine Images Table (Join Table)Medicines may have multiple images associated with them, especially when considering different brands or packaging.This table serves to link `Medicines` and `Images` tables.Key Attributes: Contains `medicine_id`, `image_id`, and `is_primary`.The `is_primary` flag helps indicate the main image for a medicine when multiple images are present.