fridgetaginfo

Table: fridgetaginfo

The fridgetaginfo table stores basic identification and audit information for fridge tags.
It is used to track fridge serial numbers, QR codes, and creation/edit history.

---

Columns

Column Name	Data Type	Constraints	Description
id	bigint(20)	NOT NULL, AUTO_INCREMENT	Unique identifier for each fridge tag info record
createdDate	datetime	NULL	Timestamp when the record was created
lastEditedDate	datetime	NULL	Timestamp when the record was last modified
ftQRCode	varchar(255)	NULL	QR code associated with the fridge tag
ftSerialNumber	varchar(255)	NULL	Serial number of the fridge tag
voided	tinyint(1)	NULL	Soft deletion flag (1 = voided, 0 = active)
createdByUserId	int(11)	NULL	User who created the record
lastEditedByUserId	int(11)	NULL	User who last edited the record

---

Indexes

1. PRIMARY - Primary key on id

---

Foreign Key Relations

• None explicitly defined, but createdByUserId and lastEditedByUserId typically reference user.mappedId.

---

Usage Notes

• Stores identification data for fridge tags, such as serial numbers and QR codes.
• voided allows soft deletion without removing historical records.
• Audit fields (createdByUserId, lastEditedByUserId, createdDate, lastEditedDate) help track changes.
• Serves as a reference for linking fridge tags with monitoring records in fridgetag and other cold chain tables.