aBXcsNbW

1String creating table coupons
2======================================
3CREATE TABLE IF NOT EXISTS `database`.`coupons` ( `ID` INT NOT NULL AUTO_INCREMENT , `COMPANY_ID` INT NOT NULL , `CATEGORY_ID` INT NOT NULL , `TITLE` VARCHAR(30) NOT NULL , `DESCRIPTION` VARCHAR(50) NOT NULL , `STARTDATE` DATE NOT NULL , `END_DATE` DATE NOT NULL , `AMOUNT` INT NOT NULL , `PRICE` DOUBLE NOT NULL , `IMAGE` VARCHAR(50) NOT NULL , PRIMARY KEY (`ID`) , FOREIGN KEY (`COMPANY_ID`) REFERENCES companies(ID) , FOREIGN KEY (`CATEGORY_ID`) REFERENCES categories(ID) ON DELETE CASCADE)";
4======================================
5String creating customer vs coupons table
6======================================
7CREATE TABLE IF NOT EXISTS `database`.`customers_vs_coupons` (CUSTOMER_ID INT NOT NULL,COUPON_ID INT NOT NULL,PRIMARY KEY (CUSTOMER_ID,COUPON_ID), FOREIGN KEY (CUSTOMER_ID) REFERENCES customers(ID),FOREIGN KEY (COUPON_ID) REFERENCES coupons(ID) ON DELETE CASCADE)