-- ============================================================================
|
-- 设备报修 device_repair
|
-- ============================================================================
|
|
ALTER TABLE `device_repair`
|
ADD COLUMN `acceptance_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收人' AFTER `repair_name`;
|
|
ALTER TABLE `device_repair`
|
ADD COLUMN `acceptance_time` datetime NULL DEFAULT NULL COMMENT '验收时间' AFTER `acceptance_name`;
|
|
ALTER TABLE `device_repair`
|
ADD COLUMN `acceptance_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收备注' AFTER `acceptance_time`;
|
|
-- 状态说明：0-待维修 1-完成 2-维修失败 3-待验收
|
