Issues

• admin: for patient's schedule show if the appointment is completed and by who!

  candry1/480-hospital-database#63 · Filter by author candry1 opened on Nov 28, 2023

• admin: when we view patient vaccine scheules, show vaccine_company

  candry1/480-hospital-database#62 · Filter by author candry1 opened on Nov 28, 2023

• admin: remove the ability to update phone# and address of nurse

  candry1/480-hospital-database#61 · Filter by author candry1 opened on Nov 28, 2023

• ADMIN: **BUG - updating vaccine count isn't working for num_available and total_count isn't working

  candry1/480-hospital-database#60 · Filter by author candry1 opened on Nov 28, 2023

• Patient: create a DB where patients can schedule their vaccines and we keep a log of who completed them and if they're completed

  candry1/480-hospital-database#59 · Filter by author candry1 opened on Nov 27, 2023

• Patient: log schedules in a separate table w/ ssn, date, time, and "y/n" for if completed or not

  candry1/480-hospital-database#58 · Filter by author candry1 opened on Nov 27, 2023

• Admin: view FULL vaccine scheduling table

  candry1/480-hospital-database#57 · Filter by author candry1 opened on Nov 27, 2023

• Nurse: when you schedule a vaccine, update count of available and on-hold

  candry1/480-hospital-database#56 · Filter by author candry1 opened on Nov 27, 2023

• Misc: when you DO a vaccine, update count of available and on-hold

  candry1/480-hospital-database#55 · Filter by author candry1 opened on Nov 27, 2023

• Misc: when you schedule a vaccine, update count of available and on-hold

  candry1/480-hospital-database#54 · Filter by author candry1 opened on Nov 27, 2023

• TEST: 12 nurses per slot

  candry1/480-hospital-database#53 · Filter by author candry1 opened on Nov 27, 2023

• Patients: 1 nurse scheduled for every 10 patients, or else the patients can NOT sign up for that slot

  candry1/480-hospital-database#52 · Filter by author candry1 opened on Nov 27, 2023

• Patient: Make sure whatever options we give the patients to sign up for has at least 1 nurse

  candry1/480-hospital-database#51 · Filter by author candry1 opened on Nov 27, 2023

• Misc: 100 patients max per timeslot

  candry1/480-hospital-database#50 · Filter by author candry1 opened on Nov 27, 2023

• Patient: don't schedule a vaccine if it's not available

  candry1/480-hospital-database#49 · Filter by author candry1 opened on Nov 27, 2023

• Patient: push their sign-up info to the patient database

  candry1/480-hospital-database#48 · Filter by author candry1 opened on Nov 27, 2023

• Patients: see their schedule

  candry1/480-hospital-database#47 · Filter by author candry1 opened on Nov 27, 2023

• Misc: log-out ability

  candry1/480-hospital-database#46 · Filter by author candry1 opened on Nov 25, 2023

• Nurse: don't allow them to schedule for the same time slot twice

  candry1/480-hospital-database#45 · Filter by author candry1 opened on Nov 25, 2023

• Misc: when a nurse or patient logs in, take them to their specific page!!

  candry1/480-hospital-database#44 · Filter by author candry1 opened on Nov 24, 2023

• Nurse: update phone number

  candry1/480-hospital-database#43 · Filter by author candry1 opened on Nov 24, 2023

• Admin: add nurse info to nurse table AND login table whenever a nurse is registered

  candry1/480-hospital-database#42 · Filter by author candry1 opened on Nov 24, 2023

• Admin: update nurse user and password

  candry1/480-hospital-database#41 · Filter by author candry1 opened on Nov 24, 2023

• Misc: Add username and password info for already existing nurses and patients

  candry1/480-hospital-database#40 · Filter by author candry1 opened on Nov 24, 2023

• Patient: add their info, when they don't have any in the Patient table!!

  candry1/480-hospital-database#39 · Filter by author candry1 opened on Nov 24, 2023