SQLize Online / PHPize Online  /  SQLtest Online

-- ----------------------------------------------------- -- Table `mydb`.`Warehouse` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `Warehouse` ( `ID` INT NOT NULL, `Adress` VARCHAR(255) NOT NULL, PRIMARY KEY (`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`) ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`Seller` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `Seller` ( `Id` VARCHAR(20) NOT NULL, `Name` VARCHAR(200) NULL, `DateBirth` DATE NULL, `Date_of_admission` DATE NULL, `Username` VARCHAR(45) NULL, `Password` VARCHAR(25) NULL, PRIMARY KEY (`Id`) ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`Order` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `Order` ( `IdCheck` INT NOT NULL, `Date_sell` DATE NULL, `Seller_Id` VARCHAR(20) NOT NULL, PRIMARY KEY (`IdCheck`, `Seller_Id`), INDEX `fk_Order_Seller1_idx` (`Seller_Id` ASC), CONSTRAINT `fk_Order_Seller1` FOREIGN KEY (`Seller_Id`) REFERENCES `Seller` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`CHWHP` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `CHWHP` ( `Check_IdCheck` INT NOT NULL, `ID_WHP` INT NOT NULL, PRIMARY KEY (`Check_IdCheck`, `ID_WHP`), CONSTRAINT `fk_Check_has_Warehouse_has_part_Check1` FOREIGN KEY (`Check_IdCheck`) REFERENCES `mydb`.`Order` (`IdCheck`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`WHP` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `WHP` ( `ID` INT NOT NULL, `Detail_ID` INT NOT NULL, `Warehouse_ID` INT NOT NULL, PRIMARY KEY ( `ID`, `Detail_ID`, `Warehouse_ID` ), INDEX `fk_Warehouse_has_part_part1_idx` (`Detail_ID` ASC), INDEX `fk_WHP_Warehouse1_idx` (`Warehouse_ID` ASC), CONSTRAINT `fk_Warehouse_has_part_part1` FOREIGN KEY (`Detail_ID`) REFERENCES `mydb`.`part` (`ID_Detail`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_WHP_CHWHP1` FOREIGN KEY (`ID`) REFERENCES `mydb`.`CHWHP` (`ID_WHP`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_WHP_Warehouse1` FOREIGN KEY (`Warehouse_ID`) REFERENCES `Warehouse` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `mydb`.`manufacture` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `manufacture` ( `manufactureid` INT NOT NULL, `Name` VARCHAR(70) NOT NULL, PRIMARY KEY (`manufactureid`), CONSTRAINT `fk_manufacture_part1` FOREIGN KEY (`manufactureid`) REFERENCES `part` (`idmanufacture`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB;