# Pill Bug [Progess so far](https://github.com/CECS343Project/Farm/milestones) | [Issues to be claimed](https://github.com/CECS343Project/Farm/issues?q=is%3Aopen+is%3Aissue+label%3A%22help+wanted%22+no%3Aassignee) | [Contribution Graph](https://github.com/CECS343Project/Farm/network) ## Problem There is a significant time difference between a doctor giving a prescription to patient, and pharmacy recieving it. There is also no record to query or categorization of patient prescriptions.

Solution

Java application installed on both doctor and pharmacy side. Software will be graphical asking questions regarding patient and prescription information. Software will reconcile with external mysql database using a secured internet connection and virtual hosts.

Technology

JavaSDK, Apache Tomcat, HTML, CSS, MySQL, linux server, Apache HTTP, PHP, internet explorer, Firefox, google chrome GUI and MySQL

MySQL fields:

• primary key
• doctor name
• doctor address
• patient name
• patient address
• prescription text
• prescription category
• pharmacy name
• pharmacy address