ilr
Table: ilr
The ilr table stores information about ILR (Ice-Lined Refrigerator) units used for vaccine storage.
It tracks device details, status, and associations with centers, vaccinators, and monitoring activities.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| id | bigint(20) | NOT NULL, AUTO_INCREMENT, PRIMARY KEY | Unique identifier for each ILR unit |
| createdDate | datetime | NULL | Timestamp when the record was created |
| lastEditedDate | datetime | NULL | Timestamp when the record was last edited |
| centerId | int(11) | NULL | ID of the vaccination center associated with the ILR (references vaccinationcenter.mappedId) |
| ilrQRCode | varchar(255) | NULL | QR code of the ILR unit |
| manufacturerName | varchar(255) | NULL | Name of the ILR manufacturer |
| monitoringDevice | varchar(255) | NULL | Device used for monitoring the ILR |
| powerSource | varchar(255) | NULL | Power source type of the ILR |
| removalReason | varchar(255) | NULL | Reason for ILR removal or decommissioning |
| serialNumber | varchar(255) | NULL | Serial number of the ILR unit |
| status | varchar(20) | NULL | Current status of the ILR (e.g., Active, Inactive) |
| vaccinatorId | int(11) | NULL | ID of the vaccinator responsible for the ILR (references vaccinator.mappedId) |
| voided | tinyint(1) | NOT NULL | Flag indicating if the record is voided (1 = voided, 0 = active) |
| 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 |
| vaccinationCenterId | int(11) | NULL | ID of the vaccination center using the ILR (references vaccinationcenter.mappedId) |
| monitoring_id | bigint(20) | NULL | ID of the monitoring activity (references ilrmonitoring.id) |
Indexes
- PRIMARY - Primary key on
id - FK197AF461150E5 - Index on
centerId - FK197AF7011764C - Index on
vaccinatorId - FK197AF7277622A - Index on
vaccinationCenterId - FK197AF5AC68504 - Index on
monitoring_id
Foreign Key Relations
-
FK197AF461150E5→vaccinationcenter.mappedId- Associates the ILR with a vaccination center
-
FK197AF7011764C→vaccinator.mappedId- Links the ILR to the responsible vaccinator
-
FK197AF7277622A→vaccinationcenter.mappedId- Another reference to the vaccination center using the ILR
-
FK197AF5AC68504→ilrmonitoring.id- Associates the ILR with a monitoring activity
Usage Notes
- Tracks ILR details for vaccine storage and cold chain management.
voidedfield indicates whether the ILR record is active or decommissioned.- Foreign keys ensure ILR units are linked to valid vaccination centers, vaccinators, and monitoring activities.
- Fields like
ilrQRCode,serialNumber, andmanufacturerNamesupport identification and audit purposes.