CREATE TABLE `inventoryEvidenceFiles` (
	`id` int AUTO_INCREMENT NOT NULL,
	`transactionId` int NOT NULL,
	`storageKey` varchar(512) NOT NULL,
	`url` varchar(1024) NOT NULL,
	`fileName` varchar(255) NOT NULL,
	`contentType` varchar(100) NOT NULL,
	`sizeBytes` int NOT NULL,
	`createdBy` int NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	CONSTRAINT `inventoryEvidenceFiles_id` PRIMARY KEY(`id`)
);