2026-02-05 10:49:27 +08:00
|
|
|
|
ALTER TABLE `spdm_baseline`.`simulation_job`
|
2026-02-06 13:47:44 +08:00
|
|
|
|
ADD COLUMN `del_flag` CHAR(1) NOT NULL DEFAULT 'N' COMMENT '逻辑删除标识：N-未删除，Y-已删除';
|
|
|
|
|
|
|
|
|
|
|
|
-- 创建任务异常信息记录表
|
|
|
|
|
|
CREATE TABLE `simulation_task_ecn` (
|
|
|
|
|
|
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID，自增',
|
|
|
|
|
|
`project_code` VARCHAR(64) NOT NULL COMMENT '项目号',
|
|
|
|
|
|
`station_code` VARCHAR(64) NOT NULL COMMENT '工位号',
|
|
|
|
|
|
`ecn_info` MEDIUMTEXT NOT NULL COMMENT '异常数据，存储JSON字符串',
|
|
|
|
|
|
`source` VARCHAR(64) NOT NULL DEFAULT 'lyric' COMMENT '数据来源，默认值lyric',
|
|
|
|
|
|
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间，自动记录插入时间',
|
|
|
|
|
|
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间，自动记录更新时间',
|
|
|
|
|
|
PRIMARY KEY (`id`),
|
|
|
|
|
|
KEY `idx_project_station` (`project_code`, `station_code`) COMMENT '项目号+工位号联合索引，提升查询效率'
|
|
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='任务异常信息记录表';
|
|
|
|
|
|
|
