womenvaccination

Table Name: womenvaccination

The womenvaccination table stores information about vaccinations administered to women, including details about timing, status, and the administering personnel.

---

Columns

Column Name	Data Type	Constraints	Description
vaccinationRecordNum	int(11)	Primary Key, Not Null	Unique identifier for each vaccination record.
createdDate	datetime	Nullable	The date and time when the record was created.
description	varchar(255)	Nullable	A description of the vaccination event.
epiNumber	varchar(255)	Nullable	Expanded Program on Immunization (EPI) number for tracking purposes.
height	float	Nullable	Height of the woman at the time of vaccination (if recorded).
isFirstVaccination	tinyint(1)	Nullable	Indicates if this is the first vaccination for the woman (1 for true, 0 for false).
isVaccinationCenterChanged	tinyint(1)	Nullable	Indicates if the vaccination center was changed (1 for true, 0 for false).
lastEditedDate	datetime	Nullable	The date and time when the record was last edited.
mappedId	int(11)	Nullable	Mapping identifier for internal tracking.
reasonNotTimelyVaccination	varchar(255)	Nullable	Reason for the vaccination not being timely, if applicable.
timelinessFactor	smallint(6)	Nullable	Factor influencing the timeliness of vaccination.
timelinessStatus	int(11)	Nullable	Status indicating the timeliness of the vaccination.
vaccinationCenterId	int(11)	Nullable, Foreign Key	Identifier of the vaccination center where the event occurred.
vaccinationDate	datetime	Nullable	The actual date when the vaccination was administered.
vaccinationDuedate	datetime	Nullable	The due date for the vaccination.
vaccinationStatus	varchar(20)	Nullable	Status of the vaccination (e.g., COMPLETED, PENDING).
vaccinatorId	int(11)	Nullable, Foreign Key	Identifier of the vaccinator who administered the vaccine.
vaccineId	smallint(6)	Nullable, Foreign Key	Identifier of the vaccine administered.
weight	float	Nullable	Weight of the woman at the time of vaccination (if recorded).
createdByUserId	int(11)	Nullable, Foreign Key	Identifier of the user who created the record.
lastEditedByUserId	int(11)	Nullable, Foreign Key	Identifier of the user who last edited the record.
womenId	int(11)	Nullable, Foreign Key	Identifier linking the woman to her vaccination record.
womenStatus	varchar(45)	Nullable	Status of the woman in the program (e.g., ACTIVE, INACTIVE).
vaccinationEventType	varchar(255)	Nullable	Type of vaccination event (e.g., ROUTINE, FOLLOW-UP).
isImmunizedByLHW	tinyint(1)	Nullable	Indicates if the woman was immunized by a Lady Health Worker (LHW).

---

Indexes

1. Primary Key:
   • vaccinationRecordNum: Ensures uniqueness for each vaccination record.
2. Foreign Key Indexes:
   • vaccinationId_vaccinatorId_vaccinator_mappedId_FK: Links vaccinatorId to the vaccinator table.
   • vaccinationWomen_womenId_women_mappedId_FK: Links womenId to the idmapper table.
   • vaccinationEdit_lastEditedByUserId_user_mappedId_FK: Links lastEditedByUserId to the user table.
   • vaccinationId_vaccineId_vaccine_vaccineId_FK: Links vaccineId to the vaccine table.
   • vaccinationUser_createdByUserId_user_mappedId_FK: Links createdByUserId to the user table.
3. Additional Indexes:
   • idx_vaccinationDate_womenvaccination: Optimizes queries on vaccinationDate.
   • idx_vaccinationStatus_womenvaccination: Optimizes queries on vaccinationStatus.

---

Foreign Key Relationships

1. vaccinator table:
   • vaccinatorId: Identifies the vaccinator who administered the vaccine.
2. idmapper table:
   • womenId: Links the woman to her vaccination record.
3. user table:
   • createdByUserId: Identifies the user who created the record.
   • lastEditedByUserId: Identifies the user who last edited the record.
4. vaccine table:
   • vaccineId: Identifies the vaccine administered.

---

Usage Notes

• Purpose:
  • The womenvaccination table is essential for managing and tracking vaccination records of women in health programs.
• Query Optimization:
  • Indexed columns like vaccinationDate and vaccinationStatus ensure efficient querying for reporting and data analysis.