Here is the main repository for the medcurity project. To read more about the company, here's the link: https://medcurity.com/

This repository contains the necessary files and documentation for the Medcurity Project. The contents of this project aim to meet the goals and requirements set by Medcurity. The Requirements for this project are as follows:

• PRIMARY PROJECT PORTION: OCR PORTAL WEBSITE
  • Access the Office of Civil Rights (OCR) portal website and breach database, assimilate breach information into a variety of dynamic graphs. Incorporate information into a unique and aesthetically sharp website that will be used internally at Medcurity and by Medcurity partners.
  • Provide the ability to use search criteria that will result in interactive results.
• SECONDARY PROJECT PORTION: NEWS SITE DISPLAY
  • Supplement the website by scraping Internet news websites to identify and present current stories about health care related breaches.
  • Present a rolling list of news stories related to health care breaches.
  • Allow users to drill into the stories.
• THIRD PROJECT PORTION: HIPAA RISK CALCULATOR
  • Use Medcurity proprietary risk algorithms to create a graphical risk calculator that will help our clients assess their HIPAA security risks at a high level.
  • Incorporate the risk calculator into the primary project website.

• Our Database is hosted on Supabase. Supabase is a free open-source Postgres database. It holds all of the data for the breach portal and all of the data for the news pages. Josh, has an owner account and will be able to take it over effective immediately.
  • Link to Supabase
  • Link to Supabase Docs

• Python WebScrapers
  • Link to WebScrapper Setup
  • Link to OCR Webscraper Docs

• AWS Lambda: Serverless computing service used to run the Python web scraping scripts.

  • Official documentation: https://docs.aws.amazon.com/lambda/index.html

• Amazon Event Bridge: Event-driven service used to schedule and trigger the Lambda functions for daily execution.

  • Official documentation: https://docs.aws.amazon.com/eventbridge/index.html

• AWS Cloud9: Integrated development environment (IDE) used to install dependencies and libraries required by the Python code.

  • To install python dependencies in Cloud9: https://repost.aws/knowledge-center/lambda-import-module-error-python

• Link to Linux ENV Setup

• ReactJS
• Boostrap
• Stylized Components
  • Link to Docs

Throughout the deveolpment of this project, there was some aspects of the project that was started, and then scrapped for a better solution. All of those solutions are still contained in this repo. You can find all old and usused code here: Link to Unused

• Develop Backend Rest API
• Completed and Live Database
• AWS Glue with Daily Trigger

Deliverable: Basic Rest API Calls

• Continued Work on Rest API
• AWS Glue with Daily Trigger
• Front end Development

Deliverable: More front end development/ additional features

• Front End Development Completed
• Dynamic Graphs Functional
• Interactive news stories collection

• Add finishing touches to graphs and news page
• Clean up some bugs
• Write documentation
• Deliver

All images, sketches and outlines can be found here: Link to Mockups

Before our transition to Supabase, we had a MySQL database that was orginally created. A link to it is here: Link to Schema

Our current DB Schema: Link to Schema