hpv_child

Table: hpv_child

The hpv_child table stores personal and demographic information of children enrolled in the HPV program.
It tracks identifiers, family details, and location information for vaccination and reporting purposes.

---

Columns

Column Name	Data Type	Constraints	Description
mappedId	int(11)	NOT NULL, PRIMARY KEY	Unique internal identifier for each child
identifier	varchar(45)	NOT NULL, UNIQUE	Program-specific unique identifier for the child
created_at	datetime	DEFAULT CURRENT_TIMESTAMP	Timestamp when the record was created
modified_at	datetime	DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	Timestamp when the record was last modified
name	varchar(40)	NULL	Name of the child
age	tinyint(4)	NULL	Age of the child
father_name	varchar(40)	NULL	Name of the child’s father
father_cnic	varchar(16)	NULL	CNIC (identity number) of the father
father_phone	varchar(14)	NULL	Phone number of the father
ucId	int(11)	NULL	Union council ID or local administrative unit
address	varchar(255)	NULL	Residential address of the child
townId	int(11)	NULL	Town ID for location reference
districtId	int(11)	NULL	District ID for location reference

---

Indexes

1. PRIMARY - Primary key on mappedId
2. UNIQUE - mappedId_UNIQUE on mappedId
3. UNIQUE - identifier_UNIQUE on identifier
4. INDEX - idx_child_age on age

---

Foreign Key Relations

• None defined

---

Usage Notes

• Stores demographic and identification data for children in the HPV program.
• identifier ensures program-level uniqueness, while mappedId is used internally.
• Age and location fields (ucId, townId, districtId) support reporting and targeting.
• Father’s contact information is used for communication and consent purposes.