Vaccination Tracker

Problem:

Suppose your local govt. wants to track and maintain how many people in your area got vaccinated (btw "COVID vaccination") and how many left. They also wants to get the status of family and area wise report. Now your area head (could be a BDO) calls you as you are a well known software engineer in the area for solution.

Solution:

Well, the obvious solution as a good software engineer you would give is to build a software (vaccination-tracker) to do all the above tasks.

What it does till now?

1) After first round of survey we can upload an excel file with all the required data and the application stores and maintain them all in mutiple MySQL tables.

2) You can call one API to retrive a person details by using any of the identity number (i.e aadhar id, voter id or pan id)

3) Once anyone gets vaccinated one API can update his/her vaccination count

4) One cool thing it does, once you update any person's vaccination details the family and area wise details also gets updated asynchronously. Thanks to spring @Async.

5) We can retrive an area's or family's vaccination details too.

6) Upload and update records can only be done by an administrative user. Fetching a person, family or area details can be be done by both administrative and general users

7) The individual services also can be containerized using docker.

8) Download the survey template.

Architecture:

DB Details:

DB Script (wiki)