CREATE TABLE `设备供应商` (
  `设备供应商编号` INT NOT NULL AUTO_INCREMENT,
  `设备编号` VARCHAR(10) NOT NULL,
  `供应编号` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`设备供应商编号`),
  FOREIGN KEY (`设备编号`) REFERENCES `设备`(`设备编号`),
  FOREIGN KEY (`供应编号`) REFERENCES `供应商`(`供应编号`)
);
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (1, 'DEV001', 'SUP001');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (2, 'DEV002', 'SUP002');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (3, 'DEV003', 'SUP003');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (4, 'DEV004', 'SUP004');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (5, 'DEV005', 'SUP005');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (6, 'DEV006', 'SUP006');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (7, 'DEV007', 'SUP007');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (8, 'DEV008', 'SUP008');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (9, 'DEV009', 'SUP009');
INSERT INTO `设备供应商`(`设备供应商编号`, `设备编号`, `供应编号`) VALUES (10, 'DEV010', 'SUP010');