Child Vaccination Management System

The Child Vaccination Management System is a web-based healthcare management application developed using Python Flask and SQLite to simplify and organize the process of managing child vaccination appointments. The system provides a centralized platform where parents, hospitals, and administrators can interact with each other and manage vaccination-related activities digitally. The main objective of this project is to provide an efficient and user-friendly platform for parents to manage their children's vaccination information and appointments while allowing hospitals to handle appointment requests and administrators to manage the complete system. The system consists of three major modules: Parent, Hospital, and Admin. Parent Module: Parents can create an account and securely log in to the system. After logging in, parents can add and manage their children's information, select a hospital, choose an appointment date, and book vaccination appointments. Parents can view their appointment history and track whether an appointment is pending, approved, or rejected. The system also provides email notifications to keep parents informed about appointment status updates. Hospital Module: Hospitals can register with the system and access the hospital dashboard after receiving approval from the administrator. Hospital users can view vaccination appointment requests submitted by parents and review the associated parent and child information. Hospitals can approve or reject appointment requests based on availability and update the appointment status. When the appointment status is changed, an automated email notification can be sent to the parent. Admin Module: The administrator has centralized control over the entire application. Admin users can manage registered hospitals, approve or reject hospital registrations, view child and parent information, monitor vaccination appointments, and manage system data. The administrator can also export appointment information into CSV format for reporting and record-keeping purposes. Appointment Management: The system provides a structured appointment booking workflow. Parents can select an available hospital and preferred appointment date while submitting a vaccination request. The request is then made available to the selected hospital. The hospital can review the request and approve or reject it. The updated status is reflected in the parent dashboard, providing a clear view of the appointment progress. Email Notification: The application includes an email notification system using Flask-Mail and Gmail SMTP. Parents can receive automated email notifications when their vaccination appointment is approved or rejected by the hospital. Email configuration is managed through environment variables using a .env file to keep sensitive configuration information separate from the application source code. Child Information Management: Parents can maintain important information about their children within the system. This allows child-related details to be associated with vaccination appointments and helps organize appointment records in a structured manner. Hospital Management: The administrator can monitor hospitals registered on the platform and control their access through the hospital approval process. This provides an additional administrative layer before hospitals can access the appointment management functionality. Dashboard Management: Separate dashboards are provided for Parents, Hospitals, and Administrators. Each dashboard displays the information and actions relevant to the respective user role, making the application easier to navigate and manage. Database: The project uses SQLite as its database, making it lightweight and easy to configure for academic and demonstration purposes. Flask-SQLAlchemy is used for database interaction and ORM-based data management. The system can maintain records related to users, hospitals, children, appointments, and appointment statuses without requiring a separate MySQL server. User Interface: The application provides a modern and responsive user interface with dedicated dashboards, navigation components, appointment status displays, forms, and management screens. Light and Dark Mode functionality is also included to improve the overall user experience. Security and Authentication: The system uses Flask-Login for user authentication and session management. Different user roles are provided with access to their respective modules, helping separate Parent, Hospital, and Admin functionality. CSV Export: Administrators can export appointment-related information as CSV files. This feature can be useful for maintaining reports, analyzing appointment records, and keeping offline copies of system data. Technology Stack: The backend of the application is developed using Python and Flask. Flask-Login is used for authentication, Flask-Mail is used for email notifications, and Flask-SQLAlchemy is used for database operations. SQLite is used as the database, while HTML, CSS, JavaScript, and Bootstrap are used to build the frontend interface. Overall, the Child Vaccination Management System demonstrates how a healthcare appointment workflow can be digitized using a Python-based web application. It combines parent management, child information management, hospital management, vaccination appointment booking, administrative control, email notifications, database management, and reporting features into a single integrated platform.