dhis2_vaccine_mapping
Table: dhis2_vaccine_mapping
The dhis2_vaccine_mapping table maps internal vaccine IDs to DHIS2 system vaccine IDs.
It is used to ensure accurate reporting and synchronization of vaccine data with the DHIS2 platform.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| id | int(2) | NOT NULL, AUTO_INCREMENT | Unique identifier for each vaccine mapping record |
| vaccine_id | int(2) | NULL | Internal ID of the vaccine |
| DHIS2_vaccine_id | varchar(25) | NULL | Corresponding DHIS2 system vaccine ID |
Indexes
- PRIMARY - Primary key on
id
Foreign Key Relations
- None
Usage Notes
- Maps internal vaccine identifiers to DHIS2 vaccine IDs for integration and reporting.
- Ensures consistency when transmitting vaccine data to DHIS2.
- Each mapping should be unique to prevent conflicts or duplicates in reporting.