DROP TABLE IF EXISTS `fer_inventura`;
CREATE TABLE `fer_inventura` (
  `date_scanned` date NOT NULL,
  `barcode` varchar(20) NOT NULL,
  `source_id` varchar(20) NOT NULL,
  `timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `fer_inventura_unique` (`barcode`,`date_scanned`,`source_id`)
);
