CREATE TABLE `DuplicateRejection` (
  `id` VARCHAR(191) NOT NULL,
  `fileName` VARCHAR(191) NOT NULL,
  `extractedData` JSON NULL,
  `contentHash` CHAR(64) NOT NULL,
  `invoiceFingerprint` VARCHAR(191) NULL,
  `source` ENUM('UPLOAD', 'SHAREPOINT') NOT NULL,
  `ownerId` VARCHAR(191) NOT NULL,
  `duplicateDocumentId` VARCHAR(191) NULL,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),

  PRIMARY KEY (`id`),
  INDEX `DuplicateRejection_ownerId_createdAt_idx` (`ownerId`, `createdAt`),
  INDEX `DuplicateRejection_duplicateDocumentId_idx` (`duplicateDocumentId`),
  CONSTRAINT `DuplicateRejection_ownerId_fkey` FOREIGN KEY (`ownerId`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `DuplicateRejection_duplicateDocumentId_fkey` FOREIGN KEY (`duplicateDocumentId`) REFERENCES `Document`(`id`) ON DELETE SET NULL ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
