Emergency Waitlist

Overview

The Hospital Triage application helps staff and patients better understand wait times while in the emergency room. The application will be administered by the triage staff based on two dimensions: severity of injuries and the length of time already in the queue. Administrators will see the full list of patients, and users can sign-in with their name.

Resources

• Database Design
• Database Schema
• Sample Data (SQL)

Setup

This application requires PHP 8.1+ and PostgreSQL 14+. The following installations may help.

sudo apt install php
sudo apt install php-pgsql
sudo apt install postgresql
sudo apt install postgresql-client

PostgreSQL 14+

To set up the database locally, first log in as postgres, i.e. sudo -u postgres -i, if not already.

We now create the database emergency_waitlist needed for the application, if not already.

psql -c "create database emergency_waitlist"

Load the schema required for the application by running these commands from the root of the project.

psql -d emergency_waitlist -f ./db/schema.sql
psql -d emergency_waitlist -f ./db/seed.sql

We can test the database by querying it.

psql -c "select * from patients"

The output should be similar to the following.

 patient_id | patient_name | staff_id | severity | date_triage 
------------+--------------+----------+----------+-------------
          1 | james        |          |          |
          2 | tour         |        3 |       10 | 2021-06-15
          3 | hadi         |        1 |        0 | 2023-01-27
          4 | fadi         |        2 |        4 | 2022-09-07
(4 rows)

PHP 8.1+

To start the PHP server locally, run the following commands from the root of the project.

(cd public && php -S localhost:4000)

Note: It might be better to do that while still logged in as postgres or there is a risk of authentication failure in the database connection. You may change the setup of the database connection from the pg_connect() method in app/models/ConnectionDB.php as desired.

The server is hosted in http://localhost:4000/.

How to Use

This website requires logging in to use it.

Patient

To log in as a patient, choose the option to sign in as a Patient and enter the name (which must exist in the database).

After logging in, the patient can see the rest of the information about the triage. The patient can log out at anytime.

Admin

To log in as an admin, choose the option to sign in as an Admin and enter the correct username and password.

The correct username is admin and the correct password is password. After logging in, the admin can click the "Get Patients" button to fetch or refresh the list of all patients in the database. The admin can log out at anytime.