A list of all hospitals - Each hospital has 3+14+3 = 20 attributes
They are :
Name
Location
Speciality
N95 Masks (Availability)
3 Layer Mask (Availability)
PPE Kit (Daily availability / Total)
Includes gown, gloves, head gear
Sanitizer (Availability)
Bleaching Powder (Availability in Weight Units)
Sodium Hypochlorite (Availability in Volume Units)
Chemical Gloves (Availability)
Infrared Thermometer (Availability)
Handwash (Availability in Volume Units)
Viral Transport Medium (Availability)
Swap Sticks (Availability)
3 Layer packing Mask (Availability)
Ice Gel Pack (Availability)
Rubbing Alcohol (Availability in Volume Units)
Covid ward beds
ICU beds
Ventilators
Location will be as (latitude, longitude)
The last 17 items will be numerical
A list of all personnel associated with a hospital
Personnel will have two roles : admin and staff
Admin can change inventory and interact with admission page
Staff can interact only with admission page
For the MVP, do not consider whether personnel can be attached to more than one hospital.
Admissions for a hospital
Each admission will have attributes as follows:
Name
Contact
Date/Time
Registered users database
This will be a list of all users that have booked appointments through the site. They will be able to see details/modify their appointment by logging in through otp on heir email/phone
Functionality (Numbered as the db to which it relates)
Hospital list
Users should only be able to see the last 3 items; and only available/ not available, not the quantity
Hospital admin should be able to modify last 17 attributes
Govt users should be able to view all attributes
Govt users should be able to filter hospital list by location, specialty
Govt users should be able to see aggregate value of each attribute in filtered list
Hospital admission
Hospital admin/staff should be able to add/remove/block slots
Hospital admin should be able to modify list of hospital staff
Site visitor's appointment should be confirmed by sending otp on phone
Users database
Hospital admin should be able to authenticate appointment by entering appointment id
This is a reference doc
DBs
A list of all hospitals - Each hospital has 3+14+3 = 20 attributes They are :
Name Location Speciality
N95 Masks (Availability) 3 Layer Mask (Availability) PPE Kit (Daily availability / Total) Includes gown, gloves, head gear Sanitizer (Availability) Bleaching Powder (Availability in Weight Units) Sodium Hypochlorite (Availability in Volume Units) Chemical Gloves (Availability) Infrared Thermometer (Availability) Handwash (Availability in Volume Units) Viral Transport Medium (Availability) Swap Sticks (Availability) 3 Layer packing Mask (Availability) Ice Gel Pack (Availability) Rubbing Alcohol (Availability in Volume Units)
Covid ward beds ICU beds Ventilators
Location will be as (latitude, longitude)
The last 17 items will be numerical
A list of all personnel associated with a hospital Personnel will have two roles : admin and staff Admin can change inventory and interact with admission page Staff can interact only with admission page For the MVP, do not consider whether personnel can be attached to more than one hospital.
Admissions for a hospital Each admission will have attributes as follows: Name Contact Date/Time
Registered users database This will be a list of all users that have booked appointments through the site. They will be able to see details/modify their appointment by logging in through otp on heir email/phone
Functionality (Numbered as the db to which it relates)