predictiveanalysisvisit
Table: predictiveanalysisvisit
The predictiveanalysisvisit table stores predicted risk and probability assessments for child visits.
It tracks which children are at higher risk and links the data to vaccination centers and vaccinators.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| predictiveAnalysisVisitNum | int(11) | NOT NULL, PRIMARY KEY, AUTO_INCREMENT | Unique identifier for each predictive analysis visit |
| childId | int(11) | NULL | Reference to the child (links to child.mappedId) |
| createdDate | datetime | NULL | Timestamp when the record was created |
| lastEditedDate | datetime | NULL | Timestamp when the record was last edited |
| probability | double | NULL | Predicted probability of a specific outcome for the child |
| riskLevel | varchar(20) | NULL | Risk classification (e.g., Low, Medium, High) |
| vaccinationCenterId | int(11) | NULL | Reference to vaccination center (links to vaccinationcenter.mappedId) |
| vaccinatorId | int(11) | NULL | Reference to the vaccinator (links to vaccinator.mappedId) |
| visitDate | datetime | NULL | Date of the predicted visit |
| createdByUserId | int(11) | NULL | ID of the user who created the record |
| lastEditedByUserId | int(11) | NULL | ID of the user who last edited the record |
Indexes
- PRIMARY - Primary key on
predictiveAnalysisVisitNum - pa_vaccinationCenterId_vaccinationcenter_mappedId_FK - Index on
vaccinationCenterId - pa_childId_child_mappedId_FK - Index on
childId - pa_vaccinatorId_vaccinator_mappedId_FK - Index on
vaccinatorId
Foreign Key Relations
-
pa_childId_child_mappedId_FK→child.mappedId- Links the predictive visit to a specific child
-
pa_vaccinationCenterId_vaccinationcenter_mappedId_FK→vaccinationcenter.mappedId- Links the visit to the vaccination center
-
pa_vaccinatorId_vaccinator_mappedId_FK→vaccinator.mappedId- Links the visit to the vaccinator responsible
Usage Notes
- Used for predictive risk analysis on child health visits.
- Supports tracking and prioritization of high-risk children.
- Indexes on child, vaccinator, and vaccination center improve query performance for reporting and analytics.