Yu7Z5Q2u

1-- -----------------------------------------------------
2    -- Table `mydb`.`Walk-In-Sales`
3    -- -----------------------------------------------------
4    CREATE TABLE IF NOT EXISTS `mydb`.`Walk-In-Sales` (
5      `WalkIns_ID` INT NOT NULL AUTO_INCREMENT,
6      `Customer_FK_ID` INT NOT NULL,
7      `WalkInSalesD_FK_ID` INT NOT NULL,
8      `WalkInSales_Date` DATE NOT NULL,
9      PRIMARY KEY (`WalkIns_ID`),
10      INDEX `WalkInsD_FKID_idx` (`WalkInSalesD_FK_ID` ASC),
11      INDEX `FKCUST_idx` (`Customer_FK_ID` ASC),
12      CONSTRAINT `WalkInsD_FKID`
13        FOREIGN KEY (`WalkInSalesD_FK_ID`)
14        REFERENCES `mydb`.`Walk In Sales Details` (`WalkInSalesD_ID`)
15        ON DELETE NO ACTION
16        ON UPDATE NO ACTION,
17      CONSTRAINT `FKCUST`
18        FOREIGN KEY (`Customer_FK_ID`)
19        REFERENCES `mydb`.`Customer` (`Cust_ID`)
20        ON DELETE NO ACTION
21        ON UPDATE NO ACTION)
22    ENGINE = InnoDB