dhis2_center_mapping
Table: dhis2_center_mapping
The dhis2_center_mapping table maps internal center IDs to external DHIS2 system IDs.
It is used for synchronizing vaccination center data between the local system and DHIS2.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| id | int(11) | NOT NULL, AUTO_INCREMENT | Unique identifier for each mapping record |
| center_mappedId | int(11) | NULL | Internal mapped ID of the center |
| DHIS2_center_id | varchar(25) | NULL | Corresponding DHIS2 system center ID |
Indexes
- PRIMARY - Primary key on
id
Foreign Key Relations
- None
Usage Notes
- Maps internal vaccination center IDs to DHIS2 IDs for integration and data exchange.
- Ensures consistency when sending or receiving data from the DHIS2 system.
- Each mapping is unique to a center; duplicates should be avoided.