jTkHhZPL

1CREATE TABLE IF NOT EXISTS `mydb`.`Order` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `orderID` INT NOT NULL,
4  `createDate` DATE NOT NULL,
5  `createBY` VARCHAR(45) NOT NULL,
6  `isPromotion` TINYINT(1) NOT NULL,
7  `MeberShipDiscount` TINYINT(1) NOT NULL,
8  `transactionID` INT NOT NULL,
9  `userID` INT NULL,
10  PRIMARY KEY (`orderID`),
11  UNIQUE INDEX `orderID_UNIQUE` (`orderID` ASC),
12  UNIQUE INDEX `transactionID_UNIQUE` (`transactionID` ASC),
13  INDEX `userID_idx` (`userID` ASC),
14  CONSTRAINT `userID`
15    FOREIGN KEY (`userID`)
16    REFERENCES `mydb`.`User` (`user_id`)
17    ON DELETE NO ACTION
18    ON UPDATE NO ACTION,
19  CONSTRAINT `transactionID`
20    FOREIGN KEY (`transactionID`)
21    REFERENCES `mydb`.`transaction` (`id_transaction`)
22    ON DELETE NO ACTION
23    ON UPDATE NO ACTION)
24ENGINE = InnoDB