childadverseevent

Table: childadverseevent

The childadverseevent table records adverse events experienced by children following vaccination.
It captures medical, hospitalization, and outcome details, along with audit information for tracking.

---

Columns

Column Name	Data Type	Constraints	Description
childAdverseEventId	int(11)	NOT NULL, AUTO_INCREMENT	Unique identifier for each adverse event record
createdDate	datetime	NULL	Timestamp when the record was created
lastEditedDate	datetime	NULL	Timestamp when the record was last edited
childId	int(11)	NULL	References the child who experienced the adverse event
hospitalName	varchar(255)	NULL	Name of the hospital where child was treated
immunizationDate	datetime	NULL	Date when vaccination was administered
isHospitalized	tinyint(1)	NULL	Flag indicating if the child was hospitalized (1 = yes, 0 = no)
issueType	varchar(255)	NULL	Type of adverse event or medical issue
vaccinationCenterId	int(11)	NULL	Identifier of the vaccination center
vaccinatorId	int(11)	NULL	Vaccinator responsible for the vaccination
visitDate	datetime	NULL	Date of hospital or clinic visit related to the adverse event
createdByUserId	int(11)	NULL	User who created the record
lastEditedByUserId	int(11)	NULL	User who last edited the record
deathAutopsy	varchar(255)	NULL	Details of autopsy in case of child death
deathDate	datetime	NULL	Date of death, if applicable
hospitalAddress	varchar(255)	NULL	Address of the hospital
onSetSymptomDate	datetime	NULL	Date when symptoms began
outcome	varchar(255)	NULL	Outcome of the adverse event (recovered, deceased, ongoing, etc.)
symptoms	varchar(255)	NULL	Symptoms observed in the child

---

Indexes

1. PRIMARY - Primary key on childAdverseEventId
2. childadverseevent_childId_child_mappedId_FK - Index on childId
3. childadverseevent_vaccinatorId_vaccinator_mappedId_FK - Index on vaccinatorId
4. inheritor_createdByUserId_user_mappedId_FK - Index on createdByUserId
5. inheritor_lastEditedByUserId_user_mappedId_FK - Index on lastEditedByUserId

---

Foreign Key Relations

1. childadverseevent_childId_child_mappedId_FK

   • childId → child.mappedId
   • Links the adverse event to the child

2. childadverseevent_vaccinatorId_vaccinator_mappedId_FK

   • vaccinatorId → vaccinator.mappedId
   • Links to the vaccinator responsible

3. inheritor_createdByUserId_user_mappedId_FK

   • createdByUserId → user.mappedId
   • Tracks who created the record

4. inheritor_lastEditedByUserId_user_mappedId_FK

   • lastEditedByUserId → user.mappedId
   • Tracks who last edited the record

---

Usage Notes

• Tracks adverse events post-vaccination for monitoring and reporting.
• isHospitalized, hospitalName, and hospitalAddress capture hospitalization details.
• deathAutopsy and deathDate document mortality cases if any occur.
• Audit fields (createdByUserId, lastEditedByUserId, createdDate, lastEditedDate) maintain history.
• Foreign keys ensure referential integrity with child, vaccinator, and user tables.