7a2Van2Z

1CREATE TABLE IF NOT EXISTS `mham4_db`.`product` (
2  `id` INT NOT NULL,
3  `prijs` DOUBLE NOT NULL,
4  `naam` VARCHAR(45) NOT NULL,
5  `omschijving` VARCHAR(45) NULL,
6  `categorie` VARCHAR(45) NOT NULL,
7  `subcategorie` VARCHAR(45) NULL,
8  PRIMARY KEY (`id`),
9  INDEX `sub_categorie_idx` (`subcategorie` ASC),
10  INDEX `categorie_idx` (`categorie` ASC),
11  CONSTRAINT `categorie`
12    FOREIGN KEY (`categorie`)
13    REFERENCES `mham4_db`.`categorie` (`categorie`)
14    ON DELETE NO ACTION
15    ON UPDATE NO ACTION,
16  CONSTRAINT `sub_categorie`
17    FOREIGN KEY (`subcategorie`)
18    REFERENCES `mham4_db`.`subcategorie` (`subcategorie`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION)
21ENGINE = InnoDB;