You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
1.5 KiB
19 lines
1.5 KiB
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');
|