Integridad Referencial

ALTER TABLE `corrida`
ADD CONSTRAINT `idFeria` FOREIGN KEY (`idFeria`) REFERENCES `feria` (`idFeria`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `idPlaza` FOREIGN KEY (`idPlaza`) REFERENCES `plaza` (`idPlaza`) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE `corrida_torero`
ADD CONSTRAINT `idCorrida` FOREIGN KEY (`idCorrida`) REFERENCES `corrida` (`idCorrida`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `idPremio` FOREIGN KEY (`idPremio`) REFERENCES `premio` (`idPremio`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `idTorero` FOREIGN KEY (`idTorero`) REFERENCES `torero` (`idTorero`) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE `corrida_toro`
ADD CONSTRAINT `idCorridas` FOREIGN KEY (`idCorridas`) REFERENCES `corrida` (`idCorrida`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `idToro` FOREIGN KEY (`idToro`) REFERENCES `toro` (`idToro`) ON DELETE SET NULL ON UPDATE CASCADE;


ALTER TABLE `torero`
ADD CONSTRAINT `idApoderado` FOREIGN KEY (`idApoderado`) REFERENCES `apoderado` (`idApoderado`) ON DELETE SET NULL ON UPDATE CASCADE;


ALTER TABLE `toro`
ADD CONSTRAINT `idGanaderia` FOREIGN KEY (`idGanaderia`) REFERENCES `ganaderia` (`idGanaderia`) ON DELETE CASCADE ON UPDATE CASCADE;