childadverseeventvaccinationdetails

Table: childadverseeventvaccinationdetails

The childadverseeventvaccinationdetails table stores detailed information about vaccines associated with a child’s adverse event.
It captures batch numbers, manufacturer details, expiry, and audit information for traceability and reporting.

---

Columns

Column Name	Data Type	Constraints	Description
ChildAdverseEventVaccionationDetailsId	int(11)	NOT NULL, AUTO_INCREMENT	Unique identifier for each vaccination detail record
createdDate	datetime	NULL	Timestamp when the record was created
lastEditedDate	datetime	NULL	Timestamp when the record was last edited
batchNo	varchar(255)	NULL	Vaccine batch number
childAdverseEventId	int(11)	NULL	References the associated adverse event
dateManufacture	datetime	NULL	Vaccine manufacture date
expiryDate	datetime	NULL	Vaccine expiry date
manufacturerName	varchar(255)	NULL	Name of the vaccine manufacturer
serialNo	varchar(255)	NULL	Vaccine serial number
vaccineId	int(11)	NULL	References the vaccine administered
createdByUserId	int(11)	NULL	User who created the record
lastEditedByUserId	int(11)	NULL	User who last edited the record

---

Indexes

1. PRIMARY - Primary key on ChildAdverseEventVaccionationDetailsId
2. childAdverseEventId - Index on childAdverseEventId

---

Foreign Key Relations

• childAdverseEventId → childadverseevent.childAdverseEventId
  • Links the vaccination detail to the specific adverse event

---

Usage Notes

• Tracks vaccine details related to a child’s adverse event, including batch and manufacturer info.
• expiryDate and dateManufacture fields help in quality and safety tracking.
• Audit fields (createdByUserId, lastEditedByUserId, createdDate, lastEditedDate) maintain record history.
• Ensures traceability of vaccines administered to children experiencing adverse events.