🏥 PHCRA - Patient Healthcare Records Administration System

A web-based Patient Healthcare Records Administration (PHCRA) system for managing medical records, prescriptions, patient data, and healthcare documentation.

🎯 Project Overview

PHCRA is a healthcare management system designed to digitize and manage patient medical records, prescriptions, diagnostic reports, and patient information. The system provides a user-friendly interface for healthcare providers to maintain comprehensive patient records.

✨ Features

📋 Medical Records Management

• Patient Records: Store and manage patient information
• Prescription Management: Digital prescription pads and prescription tracking
• Medical Documents: Upload and manage medical documents (CT Scans, Angiograms, Discharge summaries)
• Diagnostic Reports: Organize and access diagnostic test results

🔐 Patient Identification

• Aadhar Integration: Patient identification using Aadhar numbers
• Patient Database: Structured patient data management
• Data Validation: Valid Aadhar number verification

📊 Data Management

• Database Support: Microsoft Access database (Table1.accdb) for data storage
• CSV Export/Import: Data portability with CSV format support
• HTML Reports: Generate HTML-based reports and tables
• Data Tables: Multiple data views (Table1, Table2, Table21)

🎨 User Interface

• Multi-page Interface: Multiple HTML pages (index.html, index2.html, index3.html, index4.html)
• Responsive Design: CSS styling for modern web interface
• Medical Icons: SVG icons for clinic and hospital representation
• Professional Layout: Clean and organized medical records interface

📁 Project Structure

PHCRA/
├── index.html, index2.html, index3.html, index4.html    # Main application pages
├── style1.css                                           # Stylesheet
├── Table1.accdb                                         # Microsoft Access database
├── Table1.csv, Table2.csv                               # CSV data files
├── Table1.html, Table2.html, Table21.html               # HTML data tables
├── Medical Documents/
│   ├── Angi.pdf, CT Scan.pdf, CT Scan1.pdf            # Diagnostic reports
│   ├── Discharge1.pdf, discharge.pdf                  # Discharge summaries
│   ├── Pres1.pdf, pres.pdf                            # Prescriptions
│   └── Doctor prescription pad.docx                    # Prescription templates
├── Assets/
│   ├── clinic-medical-solid.svg                        # Medical clinic icon
│   ├── hospital-user-solid.svg                        # Hospital icon
│   └── pic1.png                                       # Images
├── valid Aadhar Numbers.txt                            # Aadhar validation data
└── coding part.docx                                    # Documentation

🛠️ Technology Stack

• Frontend: HTML5, CSS3
• Database: Microsoft Access (.accdb)
• Data Format: CSV, HTML
• Icons: SVG
• Documentation: PDF, DOCX

🚀 Getting Started

Prerequisites

• Web browser (Chrome, Firefox, Edge, Safari)
• Microsoft Access (for database operations)
• Text editor (for code modifications)

Installation

1. Clone the repository

   git clone https://github.com/manasa123104/PHCRA.git
   cd PHCRA

2. Open the application

   • Open index.html in your web browser
   • Navigate through different pages (index2.html, index3.html, index4.html)

3. Database Setup

   • Open Table1.accdb with Microsoft Access
   • Import CSV files if needed (Table1.csv, Table2.csv)

Usage

1. Access the System

   • Open index.html in a web browser
   • Navigate through different sections using the multi-page interface

2. Manage Patient Records

   • View patient data in HTML tables
   • Access medical documents (PDFs)
   • Review prescriptions and diagnostic reports

3. Data Management

   • Use the Access database for structured data storage
   • Export/import data using CSV files
   • Generate HTML reports from data tables

📊 Data Files

Database

• Table1.accdb: Main patient database in Microsoft Access format

CSV Files

• Table1.csv: Patient data in CSV format
• Table2.csv: Additional patient/medical data

HTML Tables

• Table1.html: Patient data table view
• Table2.html: Secondary data table view
• Table21.html: Extended data table view

Medical Documents

• CT Scans: CT Scan.pdf, CT Scan1.pdf
• Angiograms: Angi.pdf
• Discharge Summaries: Discharge1.pdf, discharge.pdf
• Prescriptions: Pres1.pdf, pres.pdf, Doctor prescription pad.docx

🔒 Security & Privacy

• Patient Data Protection: Healthcare data management system
• Aadhar Validation: Valid Aadhar number verification system
• Document Security: Secure storage of medical documents

📝 Documentation

• Coding Documentation: See coding part.docx for implementation details
• Medical Documents: Sample medical records and prescriptions included

🎨 UI Components

• Medical Icons: SVG icons for healthcare representation
• Responsive Layout: CSS-based styling for modern interface
• Multi-page Navigation: Multiple HTML pages for different sections

📋 Use Cases

1. Patient Registration: Register new patients with Aadhar verification
2. Medical Records: Store and retrieve patient medical history
3. Prescription Management: Create and manage digital prescriptions
4. Diagnostic Reports: Upload and view diagnostic test results
5. Discharge Management: Generate and store discharge summaries
6. Data Reporting: Generate HTML-based reports from patient data

🔄 Data Flow

Patient Registration → Aadhar Validation → Database Storage
         ↓
Medical Records Entry → Document Upload → Record Management
         ↓
Prescription Creation → Document Generation → Patient Delivery
         ↓
Report Generation → HTML Tables → Data Export

📈 Future Enhancements

• User authentication system
• Advanced search and filtering
• Mobile-responsive design
• API integration for external systems
• Cloud database migration
• Enhanced security features
• Real-time data synchronization
• Patient portal access

👥 Contributing

This is a healthcare management system project. Contributions are welcome for:

• UI/UX improvements
• Database optimization
• Security enhancements
• Feature additions
• Documentation updates

📄 License

This project is for educational and healthcare management purposes.

🔗 Repository

• GitHub: https://github.com/manasa123104/PHCRA

📧 Contact

For questions or contributions, please open an issue in the repository.

---

Note: This is a healthcare records management system. Ensure compliance with healthcare data privacy regulations (HIPAA, GDPR, etc.) when handling patient information.

⚠️ Important: This system handles sensitive medical data. Implement proper security measures and comply with healthcare data protection regulations in your jurisdiction.

---

Built with ❤️ for Healthcare Management