pipe-ner-server/pipe-network-service/sql/migration_alarm_review_log.sql

-- 报警审核日志收敛，KingbaseES PostgreSQL兼容模式。
-- 不删除或改写历史日志；NOT VALID保留既有旧类型记录，只约束后续写入。
-- 停止相关写入，执行后同步部署管理端和zk-api-service。
BEGIN;
LOCK TABLE app_user.alarm_data, app_user.work_order_log, app_user.alarm_log IN SHARE ROW EXCLUSIVE MODE;
DROP TRIGGER IF EXISTS trg_alarm_lifecycle_log ON app_user.alarm_data;
DROP TRIGGER IF EXISTS trg_work_order_alarm_log ON app_user.work_order_log;
DROP FUNCTION IF EXISTS app_user.record_alarm_lifecycle();
DROP FUNCTION IF EXISTS app_user.record_alarm_work_order_log();
ALTER TABLE app_user.alarm_log DROP CONSTRAINT IF EXISTS alarm_log_oper_type_check;
ALTER TABLE app_user.alarm_log DROP CONSTRAINT IF EXISTS ck_alarm_log_oper_type_current;
ALTER TABLE app_user.alarm_log ADD CONSTRAINT ck_alarm_log_oper_type_current CHECK (oper_type IN (0,1,2,3)) NOT VALID;
COMMENT ON TABLE app_user.alarm_log IS '报警操作日志，记录报警触发、审核及处理；确认日志包含转工单号';
COMMENT ON COLUMN app_user.alarm_log.oper_type IS 'AlarmLogOperTypeEnum：0触发 1确认 2误报 3处理；工单日志只写work_order_log';
COMMENT ON COLUMN app_user.alarm_log.oper_user_name IS '操作人昵称(sys_user.nick_name)；自动操作使用系统名称';
COMMIT;