ilrremovallogs

Table: ilrremovallogs

The ilrremovallogs table records removal or status change events for ILR (Ice-Lined Refrigerator) units.
It is used to track ILR decommissioning, status updates, and associated user actions for audit purposes.

---

Columns

Column Name	Data Type	Constraints	Description
id	bigint(20)	NOT NULL, AUTO_INCREMENT, PRIMARY KEY	Unique identifier for each removal log record
createdDate	datetime	NULL	Timestamp when the log was created
lastEditedDate	datetime	NULL	Timestamp when the log was last edited
status	varchar(255)	NULL	Status description for the ILR removal or event
createdByUserId	int(11)	NULL	ID of the user who created the log
lastEditedByUserId	int(11)	NULL	ID of the user who last edited the log
ilr_id	bigint(20)	NULL	ID of the ILR unit associated with the log (references ilr.id)

---

Indexes

1. PRIMARY - Primary key on id
2. FKFC16388CF2F45055 - Index on ilr_id

---

Foreign Key Relations

1. FKFC16388CF2F45055 → ilr.id
   • Links the removal log to the specific ILR unit

---

Usage Notes

• Tracks the lifecycle and status changes of ILR units, including removals and updates.
• createdByUserId and lastEditedByUserId provide an audit trail of actions performed on ILR units.
• Useful for cold chain monitoring and ensuring accountability when ILRs are decommissioned or replaced.
• Indexed on ilr_id for efficient retrieval of all removal events for a given ILR.