Skip to main content

hpv_school_map

Table: hpv_school_map​

The hpv_school_map table maps vaccinators to schools for HPV vaccination campaigns.
It is used to assign responsibility and track which vaccinator is responsible for each school.

Columns​

Column NameData TypeConstraintsDescription
idint(11)NOT NULL, AUTO_INCREMENT, PRIMARY KEYUnique identifier for each mapping record
vaccinator_idint(11)NOT NULLID of the vaccinator (references user.mappedId)
school_idint(11)NOT NULLID of the school (references hpv_schools.school_id)

Indexes​

  1. PRIMARY - Primary key on id
  2. vaccinator_fk_idx - Index on vaccinator_id
  3. school_fk_idx - Index on school_id

Foreign Key Relations​

  1. vaccinator_fk

    • vaccinator_id → user.mappedId
    • Ensures the vaccinator exists in the system

  2. school_fk

    • school_id → hpv_schools.school_id
    • Ensures the school exists in the HPV schools table

Usage Notes​

  • Used to assign vaccinators to specific schools during HPV campaigns.
  • Supports planning, reporting, and accountability of vaccination activities.
  • Foreign keys enforce that only valid vaccinators and schools can be assigned.