Home

Welcome to the vaccination-tracker wiki!

DATABASE SCRIPT

-------------------------------------- vaccination-tracker-db-------------------------------------------

drop table person; drop table family; drop table area;

Create table person (id int PRIMARY KEY, name varchar(50), adhar_id varchar(12), voter_id varchar(10), pan_id varchar(10), age int, vaccine_count int, family_id varchar(10), pin_code int);

create table family (family_id varchar(10) primary key, member_count int, pin_code int, vaccinated_count int, family_zone_flag varchar(10));

create table area (pin_code int primary key, area_name varchar(50), district varchar(50), state varchar(50), citizen_count int, vaccinated_count int, persentage int, family_count int, area_zone_flag varchar(10));

ALTER TABLE person ADD FOREIGN KEY(family_id) REFERENCES family(family_id) ON DELETE SET NULL;

ALTER TABLE person ADD FOREIGN KEY(pin_code) REFERENCES area(pin_code) ON DELETE SET NULL;

ALTER TABLE family ADD FOREIGN KEY(pin_code) REFERENCES area(pin_code) ON DELETE SET NULL;

ALTER TABLE Person ADD CONSTRAINT UC_Person UNIQUE (adhar_id, pan_id, voter_id);

Alter table persons rename to person ALTER TABLE person ADD FOREIGN KEY (pin_code) REFERENCES area(pin_code); alter table person add foreign key (family_id) references family(family_id) alter table family add foreign key (pin_code) references area(pin_code)

----------------------------------------------Govt-Id-approver-Db----------------------------------------------------

create table id_details ( id int NOT NULL AUTO_INCREMENT, name varchar(20), dob date, adahar_id varchar(20) unique, voter_id varchar(20) unique, pan_id varchar(20) unique, PRIMARY KEY (id) )

------------------------------User table for Authentication inside vaccination-tracker-db-----------------------------------

Create table users (id int PRIMARY KEY auto_increment, username varchar(50) unique, pass_word varchar(50), role varchar(20), is_active boolean);