ALTER TABLE `utilizadores` MODIFY COLUMN `organizationId` VARCHAR(191) NOT NULL;
ALTER TABLE `equipamentos` MODIFY COLUMN `organizationId` VARCHAR(191) NOT NULL;
ALTER TABLE `documentos` MODIFY COLUMN `organizationId` VARCHAR(191) NOT NULL;
ALTER TABLE `eventos` MODIFY COLUMN `organizationId` VARCHAR(191) NOT NULL;

CREATE UNIQUE INDEX `equipamentos_organizationId_matricula_key` 
ON `equipamentos`(`organizationId`, `matricula`);

ALTER TABLE `utilizadores` 
ADD CONSTRAINT `utilizadores_organizationId_fkey` 
FOREIGN KEY (`organizationId`) REFERENCES `organizations`(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `equipamentos` 
ADD CONSTRAINT `equipamentos_organizationId_fkey` 
FOREIGN KEY (`organizationId`) REFERENCES `organizations`(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `documentos` 
ADD CONSTRAINT `documentos_organizationId_fkey` 
FOREIGN KEY (`organizationId`) REFERENCES `organizations`(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `eventos` 
ADD CONSTRAINT `eventos_organizationId_fkey` 
FOREIGN KEY (`organizationId`) REFERENCES `organizations`(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `auditoria` 
ADD CONSTRAINT `auditoria_organizationId_fkey` 
FOREIGN KEY (`organizationId`) REFERENCES `organizations`(`id`) 
ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE `user_modules` 
ADD CONSTRAINT `user_modules_userId_fkey` 
FOREIGN KEY (`userId`) REFERENCES `utilizadores`(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE;