ilrmonitoring

Table: ilrmonitoring

The ilrmonitoring table stores records of ILR (Ice-Lined Refrigerator) monitoring activities.
It tracks monitoring sessions, associated vaccinators, and location/accuracy details for cold chain verification.

---

Columns

Column Name	Data Type	Constraints	Description
id	bigint(20)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique identifier for each ILR monitoring record
anyFtWithNoQr	tinyint(1)	NULL	Flag indicating if any FT (Fridge Tag) in the session lacks a QR code (1 = yes, 0 = no)
anyIlrWithNoQr	tinyint(1)	NULL	Flag indicating if any ILR in the session lacks a QR code (1 = yes, 0 = no)
centerId	int(11)	NULL	ID of the center being monitored
endTime	datetime	NULL	End timestamp of the monitoring session
startTime	datetime	NULL	Start timestamp of the monitoring session
vaccinatorId	int(11)	NULL	ID of the vaccinator performing the monitoring (references vaccinator.mappedId)
latitude	varchar(255)	NULL	Latitude recorded during the monitoring session
longitude	varchar(255)	NULL	Longitude recorded during the monitoring session
trackingAccuracy	varchar(255)	NULL	GPS accuracy or monitoring precision information

---

Indexes

1. PRIMARY - Primary key on id
2. FKCEEBAD377011764C - Index on vaccinatorId

---

Foreign Key Relations

1. FKCEEBAD377011764C → vaccinator.mappedId

   • Links the monitoring session to the vaccinator who performed it

---

Usage Notes

• Captures each ILR monitoring session with timestamps, location, and responsible vaccinator.
• Flags anyFtWithNoQr and anyIlrWithNoQr help identify missing QR codes for devices.
• latitude, longitude, and trackingAccuracy support location verification for cold chain compliance.
• Serves as a reference for linking ILRs and FTs via ilr_ft_mapping.