4VNkQvs1

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