hpv_schools

Table: hpv_schools

The hpv_schools table stores information about schools participating in HPV vaccination campaigns.
It provides a reference for mapping vaccinators and tracking campaign activities at each school.

---

Columns

Column Name	Data Type	Constraints	Description
school_id	int(11)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique identifier for each school
name	varchar(255)	NOT NULL	Name of the school
description	varchar(255)	NULL	Additional details or description of the school

---

Indexes

1. PRIMARY - Primary key on school_id

---

Foreign Key Relations

• None directly in this table, but school_id is referenced by hpv_school_map.school_id.

---

Usage Notes

• Serves as the master list of schools involved in HPV campaigns.
• Supports mapping vaccinators to schools and generating campaign reports.
• description can store notes such as school type, location details, or special considerations.