e0CfidyE

1-- -----------------------------------------------------
2-- Table `wideworldimporters`.`review`
3-- -----------------------------------------------------
4DROP TABLE IF EXISTS `wideworldimporters`.`review`;
5CREATE TABLE IF NOT EXISTS `wideworldimporters`.`review` (
6  `StockItemID` INT(11) NOT NULL,
7  `AccountID` INT(11) NOT NULL,
8  `Rating` TINYINT(4) NULL DEFAULT NULL,
9  `Review` VARCHAR(255) NULL DEFAULT NULL,
10  INDEX `fk_review_user1` (`AccountID` ASC) VISIBLE,
11  PRIMARY KEY (`AccountID`, `StockItemID`),
12  CONSTRAINT `fk_review_stockitems1`
13    FOREIGN KEY (`StockItemID`)
14    REFERENCES `wideworldimporters`.`stockitems` (`StockItemID`)
15    ON DELETE NO ACTION
16    ON UPDATE NO ACTION,
17  CONSTRAINT `fk_review_user1`
18    FOREIGN KEY (`AccountID`)
19    REFERENCES `wideworldimporters`.`user` (`AccountID`)
20    ON DELETE NO ACTION
21    ON UPDATE NO ACTION)
22ENGINE = InnoDB
23DEFAULT CHARACTER SET = latin1;