ALTER TABLE `pdx_mz`.`prod_company` 
DROP FOREIGN KEY `FK_ad7vmosx1exb8u9gbvt9gfk49`;
ALTER TABLE `pdx_mz`.`prod_company` 
ADD CONSTRAINT `FK_ad7vmosx1exb8u9gbvt9gfk49`
FOREIGN KEY (`prod_id`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodinn` 
DROP FOREIGN KEY `FK_jha7nj3djvqe39mw17cf7cafj`;
ALTER TABLE `pdx_mz`.`prodinn` 
ADD CONSTRAINT `FK_jha7nj3djvqe39mw17cf7cafj`
FOREIGN KEY (`prod_id`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prod_atc` 
DROP FOREIGN KEY `FK_qr3emhpe8fjp8uvy5c3uw2udk`;
ALTER TABLE `pdx_mz`.`prod_atc` 
ADD CONSTRAINT `FK_qr3emhpe8fjp8uvy5c3uw2udk`
FOREIGN KEY (`prod_id`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`pricing` 
DROP FOREIGN KEY `FK_r21sluba088qooddiruykukwm`;
ALTER TABLE `pdx_mz`.`pricing` 
ADD CONSTRAINT `FK_r21sluba088qooddiruykukwm`
FOREIGN KEY (`PROD_ID`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`revdeficiency` 
DROP FOREIGN KEY `FK_hb2skqfqj7e6ccg9cs724231a`;
ALTER TABLE `pdx_mz`.`revdeficiency` 
ADD CONSTRAINT `FK_hb2skqfqj7e6ccg9cs724231a`
FOREIGN KEY (`reviewinfo_ID`)
REFERENCES `pdx_mz`.`review_info` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodapp_letter` 
DROP FOREIGN KEY `FK_mj2n9cnybueb8b5yts69l3xg0`;
ALTER TABLE `pdx_mz`.`prodapp_letter` 
ADD CONSTRAINT `FK_mj2n9cnybueb8b5yts69l3xg0`
FOREIGN KEY (`reviewInfo_id`)
REFERENCES `pdx_mz`.`review_info` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`revdeficiency` 
DROP FOREIGN KEY `FK_t0flfuchl0dbftov1thdo5d6h`;
ALTER TABLE `pdx_mz`.`revdeficiency` 
ADD CONSTRAINT `FK_t0flfuchl0dbftov1thdo5d6h`
FOREIGN KEY (`ackComment_id`)
REFERENCES `pdx_mz`.`reviewcomment` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`revdeficiency` 
DROP FOREIGN KEY `FK_73h0xoos91r4hatnfk5rpxpuw`;
ALTER TABLE `pdx_mz`.`revdeficiency` 
ADD CONSTRAINT `FK_73h0xoos91r4hatnfk5rpxpuw`
FOREIGN KEY (`sentComment_id`)
REFERENCES `pdx_mz`.`reviewcomment` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodapplications` 
DROP FOREIGN KEY `FK_r7lut1w8do6qai0bxw9o697kp`;
ALTER TABLE `pdx_mz`.`prodapplications` 
ADD CONSTRAINT `FK_r7lut1w8do6qai0bxw9o697kp`
FOREIGN KEY (`PROD_ID`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`tblusecategories` 
DROP FOREIGN KEY `FK_er8pia189hp3vemtmlo8cw2gv`;
ALTER TABLE `pdx_mz`.`tblusecategories` 
ADD CONSTRAINT `FK_er8pia189hp3vemtmlo8cw2gv`
FOREIGN KEY (`prodID`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodexcipient` 
DROP FOREIGN KEY `FK_badaadg88hjebng2ilqu8b5gu`;
ALTER TABLE `pdx_mz`.`prodexcipient` 
ADD CONSTRAINT `FK_badaadg88hjebng2ilqu8b5gu`
FOREIGN KEY (`prod_id`)
REFERENCES `pdx_mz`.`product` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`product` 
DROP FOREIGN KEY `FK_jhjd12ybnf2033fdlnox4qcqi`;
ALTER TABLE `pdx_mz`.`product` 
ADD CONSTRAINT `FK_jhjd12ybnf2033fdlnox4qcqi`
FOREIGN KEY (`pricing_id`)
REFERENCES `pdx_mz`.`pricing` (`id`)
ON DELETE SET NULL;

ALTER TABLE `pdx_mz`.`review_detail` 
DROP FOREIGN KEY `FK_am5ofd7xeclriws1i6yud82qo`;
ALTER TABLE `pdx_mz`.`review_detail` 
ADD CONSTRAINT `FK_am5ofd7xeclriws1i6yud82qo`
FOREIGN KEY (`review_info_id`)
REFERENCES `pdx_mz`.`review_info` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`reviewcomment` 
DROP FOREIGN KEY `FK_rn3k34tctgwfucouc7lw23jge`;
ALTER TABLE `pdx_mz`.`reviewcomment` 
ADD CONSTRAINT `FK_rn3k34tctgwfucouc7lw23jge`
FOREIGN KEY (`reviewinfo_ID`)
REFERENCES `pdx_mz`.`review_info` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`tblsampletypes` 
DROP FOREIGN KEY `FK_4d9xmjfdyf0ipos7vgd5maky`;
ALTER TABLE `pdx_mz`.`tblsampletypes` 
ADD CONSTRAINT `FK_4d9xmjfdyf0ipos7vgd5maky`
FOREIGN KEY (`sampleTestID`)
REFERENCES `pdx_mz`.`sample_test` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`samplecomment` 
DROP FOREIGN KEY `FK_99omi6cppjy7gwpk34rir57pu`;
ALTER TABLE `pdx_mz`.`samplecomment` 
ADD CONSTRAINT `FK_99omi6cppjy7gwpk34rir57pu`
FOREIGN KEY (`sampletest_ID`)
REFERENCES `pdx_mz`.`sample_test` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`drug_price` 
DROP FOREIGN KEY `FK_5q1l08ucxpm8dcm9ra86d7gua`;
ALTER TABLE `pdx_mz`.`drug_price` 
ADD CONSTRAINT `FK_5q1l08ucxpm8dcm9ra86d7gua`
FOREIGN KEY (`pricing_id`)
REFERENCES `pdx_mz`.`pricing` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodappchecklist` 
DROP FOREIGN KEY `FK_6vbem94vb0p87sh8vxjg5utcu`;
ALTER TABLE `pdx_mz`.`prodappchecklist` 
ADD CONSTRAINT `FK_6vbem94vb0p87sh8vxjg5utcu`
FOREIGN KEY (`prod_app_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`review_info` 
DROP FOREIGN KEY `FK_7ijtl0s11i5p74slyibhitmb4`;
ALTER TABLE `pdx_mz`.`review_info` 
ADD CONSTRAINT `FK_7ijtl0s11i5p74slyibhitmb4`
FOREIGN KEY (`prod_app_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`prodapp_letter` 
DROP FOREIGN KEY `FK_cikeg8vict937qobqwwg0h4eg`;
ALTER TABLE `pdx_mz`.`prodapp_letter` 
ADD CONSTRAINT `FK_cikeg8vict937qobqwwg0h4eg`
FOREIGN KEY (`prodApplications_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`attachment` 
DROP FOREIGN KEY `FK_nql5sake9vw21xy4wk808714i`;
ALTER TABLE `pdx_mz`.`attachment` 
ADD CONSTRAINT `FK_nql5sake9vw21xy4wk808714i`
FOREIGN KEY (`prodApplications_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`timeline` 
DROP FOREIGN KEY `FK_t2c39mhswj72cf2uvdgerc9fs`;
ALTER TABLE `pdx_mz`.`timeline` 
ADD CONSTRAINT `FK_t2c39mhswj72cf2uvdgerc9fs`
FOREIGN KEY (`PROD_APP_ID`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`foreign_appl_status` 
DROP FOREIGN KEY `FK_6hvcbw9utev7uiruy592lt5l6`;
ALTER TABLE `pdx_mz`.`foreign_appl_status` 
ADD CONSTRAINT `FK_6hvcbw9utev7uiruy592lt5l6`
FOREIGN KEY (`PROD_APP_ID`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`sample_test` 
DROP FOREIGN KEY `FK_bxbw6pqwth95naaht8mib323f`;
ALTER TABLE `pdx_mz`.`sample_test` 
ADD CONSTRAINT `FK_bxbw6pqwth95naaht8mib323f`
FOREIGN KEY (`prodApplications_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`comment` 
DROP FOREIGN KEY `FK_ord3tvf4dkynnvkbevpj0v029`;
ALTER TABLE `pdx_mz`.`comment` 
ADD CONSTRAINT `FK_ord3tvf4dkynnvkbevpj0v029`
FOREIGN KEY (`PROD_ID`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

ALTER TABLE `pdx_mz`.`susp_detail` 
DROP FOREIGN KEY `FK_osh6bfwlln8pyv2ew86ysfwkn`;
ALTER TABLE `pdx_mz`.`susp_detail` 
ADD CONSTRAINT `FK_osh6bfwlln8pyv2ew86ysfwkn`
FOREIGN KEY (`prodApplications_id`)
REFERENCES `pdx_mz`.`prodapplications` (`id`)
ON DELETE CASCADE;

