hk_covid19_portal
ABOUT THE PROJECT
hk_covid19_portal is a prototype website designed to assist Hong Kong health officials to collect self-reported data from residents before entering a quarantine camp. This data-driven website will require residents to log in and fill out personal data related to COVID-19 as well as their contact details. The data will be stored and reviewed by Hong Kong health officials, who will then contact the resident and arrange transport and accommodation in an efficient manner.
This is a final project submission created for INFO-638 Web Development class at Pratt.
DATE
March 18, 2021
DATABASE DESIGN TOOLS
MySQL
LucidChart
XAMPP
PhpMyAdmin
Brackets
GitHub
Bulma
PROGRAMMING LANGUAGES
PHP
HTML
CSS
BACKGROUND
This project is inspired by my own experience of quarantining at a quarantine camp after I had visited a hotspot with an outburst of COVID-19 cases in Hong Kong. Currently, the standard way of sending residents to a quarantine camp is by having health officials track down individuals who had visited a hotspot through a check-in app and calling them one by one. Another way is reporting the hotspots on the news and encouraging residents who had visited these locations within the past 14 days to call the general hotline themselves.
Even though the Hong Kong government is persistently working around the clock, the hotline is always busy, with only a few operators available to assist the outpour of callers. Each operator will have to manually write down the resident’s personal data, which will then be sent over to the Hong Kong health department and reviewed by health officials. The process can take up to 2-3 days for health officials to track, call, review residents’ personal data, and arrange transport to the quarantine camps. This process can become pretty chaotic when there’s a sudden outburst of cases, where we had over 700 residents sent to quarantine camps in a week.
View from my quarantine room at Penny’s Bay Camp
Therefore, the goal of my project is to:
Create a simple and efficient website that can speed up the process of contact tracing and assist health officials to quickly review and connect with Hong Kong residents.
TASKS
The application must support users to create and access their data. Some possible tasks include:
Require session login/user authentication with PHP, and use if statements to check for any error messages
Allow residents to sign-up
Allow residents to create a table to add personal data and contact details
Allow residents and health officers to access and read records in a table format
Allow residents to select quarantine camps, see the current count of occupancy/vacancy, and request an updated list
DATA REQUIREMENTS
The database will store personal self-reported information including the resident’s English name, Chinese name, Hong Kong ID number/passport number, date of birth, gender, location of (possible) exposure, date of (possible) exposure, time of (possible) exposure, symptoms (y/n), if vaccinated (y/n), if completed a government COVID-19 PCR test in the past three days (y/n). The health officer can review all of the inputted data and determine if the resident will need to quarantine.
Other data will include the resident’s contact details including district, address, phone number, and the number of households which will all be crucial for health officers to determine if they need to arrange transport and accommodation.
DATABASE ENTITY RELATIONSHIP DIAGRAM (ERD)
hk_covid19_portal database ERD design
The database ERD design I created has a total of 6 tables. There are 2 user tables that consist of patient and admin logins. The other tables house patient’s self-reported data such as their personal info, medical history, address (further broken down by district), and possible exposure site.
The biggest challenge I found was figuring out how I wanted to break down the address and districts since Hong Kong is made up of 3 islands with numerous districts. So I decided to set up a 'type input’ for users to select districts from a dropdown instead of writing in with free text to avoid any misspells.
PORTAL SITEMAP
hk_covid19_portal sitemap design
Here is the simplified sitemap design with the patient login set as my index page. The website consists of two portals. The main portal is the patient portal, for the patient to fill out and submit their patient form. After submitting, the website will lead them to a confirmation page with a list of quarantine camps available in Hong Kong. The other portal is the admin portal that is password protected and only accessible by health officials. Through this portal, officials can review individual patient details from the dashboard.
I have also created a separate page for new users to sign up. The user will be added to the database and can log in with their credentials via the patient portal on the home page.