CREATE TABLE IF NOT EXISTS `Prominform_Sales_DB`.`purchased_Мaterials_And_Equipment` (
  `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Equipment_Manufacturer_ID` INT NOT NULL,
  `Equipment_Brand` VARCHAR(1024) NOT NULL,
  `Name_Of_Equipment` VARCHAR(1024) NOT NULL,
  `Equipment_Code` VARCHAR(1024) NULL,
  `Description` VARCHAR(1024) NULL,
  `Software` VARCHAR(1024) NULL,
  `Acquisition_Currency_ID` INT NOT NULL,
  `VAT` VARCHAR(45) NOT NULL,
  `Displayed_Name_Of_Equipment_1` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_2` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_3` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_4` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_5` VARCHAR(1024) NULL,
  PRIMARY KEY (`ID`, `Acquisition_Currency_ID`, `Equipment_Manufacturer_ID`),
  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) INVISIBLE,
  INDEX `fk_purchased_Мaterials_And_Equipment_equipment_Manufacture_idx1` (`Equipment_Manufacturer_ID` ASC) VISIBLE,
  INDEX `fk_purchased_Мaterials_And_Equipment_deal_Currency1_idx` (`Acquisition_Currency_ID` ASC) VISIBLE,
  CONSTRAINT `fk_purchased_Мaterials_And_Equipment_equipment_Manufacturer1`
    FOREIGN KEY (`Equipment_Manufacturer_ID`)
    REFERENCES `Prominform_Sales_DB`.`equipment_Manufacturer` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_purchased_Мaterials_And_Equipment_deal_Currency1`
    FOREIGN KEY (`Acquisition_Currency_ID`)
    REFERENCES `Prominform_Sales_DB`.`deal_Currency` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `Prominform_Sales_DB`.`prefabricated_Equipment` (
  `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Name_Of_Equipment` VARCHAR(1024) NOT NULL,
  `used_Purchased_Мaterials_And_Equipment_ID` INT UNSIGNED NOT NULL,
  `Displayed_Name_Of_Equipment_1` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_2` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_3` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_4` VARCHAR(1024) NULL,
  `Displayed_Name_Of_Equipment_5` VARCHAR(1024) NULL,
  `Equipment_Manufacturer` VARCHAR(1024) NOT NULL,
  `Description` VARCHAR(1024) NULL,
  `Other_Сosts` VARCHAR(1024) NULL,
  PRIMARY KEY (`ID`, `used_Purchased_Мaterials_And_Equipment_ID`),
  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) VISIBLE,
  INDEX `fk_prefabricated_Equipment_purchased_Мaterials_And_Equipme_idx` (`used_Purchased_Мaterials_And_Equipment_ID` ASC) VISIBLE,
  CONSTRAINT `fk_prefabricated_Equipment_purchased_Мaterials_And_Equipment1`
    FOREIGN KEY (`used_Purchased_Мaterials_And_Equipment_ID`)
    REFERENCES `Prominform_Sales_DB`.`purchased_Мaterials_And_Equipment` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `Prominform_Sales_DB`.`equipment_Manufacturer` (
  `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Equipment_Manufacturer` VARCHAR(1024) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) VISIBLE)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `Prominform_Sales_DB`.`deal_Currency` (
  `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(45) NOT NULL,
  `Currency_Symbols` VARCHAR(3) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) VISIBLE,
  UNIQUE INDEX `Name_UNIQUE` (`Name` ASC) VISIBLE,
  UNIQUE INDEX `Currency_Symbols_UNIQUE` (`Currency_Symbols` ASC) VISIBLE)
ENGINE = InnoDB