CREATE TABLE `table_1` (
  `Vendor_ID` int NOT NULL,
  `Address` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Vendor_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `table_2` (
  `Order_ID` int NOT NULL,
  `Vendor_ID` int DEFAULT NULL,
  `Quantity` int DEFAULT NULL,
  PRIMARY KEY (`Order_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8