SQLize Online / PHPize Online  /  SQLtest Online

-- ----------------------------------------------------- -- Table `mydb`.`Manufacture` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `Manufacture` ( `Manufacture_ID` INT NOT NULL, `Name` VARCHAR(70) NOT NULL, PRIMARY KEY (`Manufacture_ID`)) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`Part` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `Part` ( `ID_Detail` INT NOT NULL, `IdManufacture` INT NOT NULL, `Original_Number` VARCHAR(70) NOT NULL, `Type_of_part` VARCHAR(150) NOT NULL, `Name` VARCHAR(200) NULL, `Year` DATE NULL, `Name_Car` VARCHAR(150) NULL, `Model_of_Car` VARCHAR(150) NULL, `Year_of_Car` DATE NULL, `Market_of_Car` VARCHAR(150) NULL, `Generetion_of_Car` INT NULL, `Price` DECIMAL(15,2) NOT NULL, PRIMARY KEY (`ID_Detail`, `IdManufacture`), INDEX `fk_Part_Manufacture1_idx` (`IdManufacture` ASC) VISIBLE, CONSTRAINT `fk_Part_Manufacture1` FOREIGN KEY (`IdManufacture`) REFERENCES `Manufacture` (`Manufacture_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;