8LHvU5Zi

1CREATE TABLE IF NOT EXISTS `firstModel`.`invoice` (
2  `idinvoice` INT NOT NULL AUTO_INCREMENT,
3  `userid` INT NOT NULL,
4  `productid` INT NOT NULL,
5  `cost` DECIMAL(10,2) NOT NULL,
6  PRIMARY KEY (`idinvoice`),
7  INDEX `user_idx` (`userid` ASC) VISIBLE,
8  CONSTRAINT `user`
9    FOREIGN KEY (`userid`)
10    REFERENCES `firstModel`.`user` (`id`)
11    ON DELETE NO ACTION
12    ON UPDATE NO ACTION)
13ENGINE = InnoDB