DocHere - Doctor Booking System


Project Overview

DocHere is a simple doctor booking application that developed with Flask micro web application framework using MySQL database management system. There are three user entities in this web application. They are,

  • Staff/Admin
  • Doctor
  • User


Staff/Admin accounts are pre-defined and will be created by development team. Cannot create new Staff/Admin accounts using the DocHere application interfaces.
Doctors can create accounts. But they cannot make credentials at once. Their account will be checked by Staff/Admin s and they can approve doctor accounts and after that, credentials will be given to the doctors privately.
Using those credentials, doctors can log into the DocHere application as a doctor and they can create schedules for each date as they want. Schedules have 15 minutes time slots and each of slot has a location. After they submit the schedule, users can show them when they search.
Users can create accounts and make credentials at once. Using those credentials, they can log into the DocHere application and search for a doctor by name or the location. After selecting a doctor, users can select a date for make a booking. According to the selected doctor and date, if there are available time slots for booking, users can book those timeslots.
Then doctors can see those booked timeslots in their account as pending bookings. After the patient/user meet the doctor, doctor can change the pending booking status as done.

  • Flask
  • Python
  • HTML
  • CSS
  • JavaScript
  • AJAX
  • MySQL
  • Bootstrap
  • Mobile-responsive
  • Add Images
  • CRUD

Interfaces

interface1

interface3

interface4

interface5
interface6

interface5

interface4
interface4

interface4

interface4

interface4

interface4

Used Technologies, Tools and Programming Languages

  • Fronted was developed using HTML, CSS and JavaScript.
  • Bootstrap 5.2.3 is used for keep responsiveness.
  • Backend was developed using Flask, the Python framework.
  • MySQL is used for database management.
  • Visual Studio Code is used as the IDE.
  • XAMPP is used for start localhost server. Version: V3.3.0
  • Virtual web server : Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4
  • phpMyAdmin - Version information: 5.2.1

Reflection and Learning

  • All the CRUD functionalities were implemented and practiced very well.
  • Improved the knowledge in Flask web framework and its libraries.
  • Image adding and deleting the image from real storage when the record is delete is successfully done.
  • User authenticating is implemented in this project. User must logged in to the system to do his/her tasks.
  • Database management skills with Flask is gained.
  • Managed the project version controlling with GitHub repository.
  • Improved Time Management, Testing and Quality Assurance skills.


Completed Documentation