/Medication-Tracker-Web-App

This is a web application that allows the elderly to easily keep track of their doctor's appointments and medication.

Primary LanguageJavaScriptMIT LicenseMIT

Medication Tracker Web App

This is used so users can login and know when they need to take their medication.

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

PHP Config File

Replace the lines below in the config file with your credentials.

$dbname = ''; // FAU username
$dbuser = ''; // FAU username
$dbpass = ''; // FAU LAMP password

SQL Statements

Run the following SQL statements before using the application.

CREATE TABLE Users (email varchar(40) NOT NULL, password varchar(60), firstName varchar(20), lastName varchar(20), phone int(15), isDoc bool, PRIMARY KEY(email));
CREATE TABLE Calendar (id varchar(36) NOT NULL, email varchar(40), start int(15), duration int(2), title varchar(40), content varchar(40), category varchar(20), PRIMARY KEY(id), FOREIGN KEY(email) REFERENCES Users(email));
CREATE TABLE Prescription (prescription varchar(40), instruction varchar(255), dosage varchar(20), patient varchar(40), patientFname varchar(40), patientLname varchar(40), doctor varchar(40), doctorLname varchar(40), FOREIGN KEY (patient) REFERENCES Users(email), FOREIGN KEY (patientFname) REFERENCES Users(firstName), FOREIGN KEY (patientLname) REFERENCES Users(lastName), FOREIGN KEY (doctor) REFERENCES Users(email), FOREIGN KEY (doctorLname) REFERENCES Users(lastName), PRIMARY KEY (prescription, patient, doctor));

Screenshots

Screenshot 1 Screenshot 2 Screenshot 3
Screenshot 4 Screenshot 5 Screenshot 6
Screenshot 7 Screenshot 8 Screenshot 9
Screenshot 10 Screenshot 11

Authors

Special Thanks

Special thanks to ArrobeFr for providing the source code for the calendar.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.