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.
20 lines
1.8 KiB
20 lines
1.8 KiB
CREATE TABLE `设备` (
|
|
`设备编号` VARCHAR(10) NOT NULL,
|
|
`状态` VARCHAR(50) NOT NULL,
|
|
`性能与效率` VARCHAR(50) NOT NULL,
|
|
`利用率` DECIMAL(3, 2) NOT NULL,
|
|
`供应编号` VARCHAR(10) NOT NULL,
|
|
PRIMARY KEY (`设备编号`)
|
|
);
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV001', '在线', '优秀', 0.95, 'SUP001');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV002', '下线', '良好', 0.70, 'SUP002');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV003', '在线', '一般', 0.60, 'SUP003');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV004', '报废', '差', 0.30, 'SUP001');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV005', '在线', '优秀', 0.85, 'SUP004');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV006', '下线', '良好', 0.75, 'SUP005');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV007', '在线', '一般', 0.65, 'SUP005');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV008', '报废', '差', 0.35, 'SUP006');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV009', '在线', '优秀', 0.95, 'SUP007');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV010', '维修', '良好', 0.80, 'SUP008');
|
|
INSERT INTO `设备`(`设备编号`, `状态`, `性能与效率`, `利用率`, `供应编号`) VALUES ('DEV012', '在线', '优秀', 0.90, 'SUP001');
|