search

CS-505 / cs505-web-api

COVID-19 Tracking API
1 stars 0 forks source link

Design the database for the patient and zipcode data. #4

Open shirazamin opened 4 years ago

shirazamin commented 4 years ago

Two tables:

  1. Patient table: mrn, location_id, patient_status_code
  2. zip_alert: zip_code, is_alert, last_count

Populate the zip_alert with all the zip codes. is_alert - false, last_count = 0