-- 诊断结果追溯表
-- 目标库：energy_prod
-- 版本：2026-11-05

CREATE TABLE IF NOT EXISTS vibration_diagnosis_result (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  engine_code VARCHAR(64) NOT NULL,
  wind_code VARCHAR(64) NULL,
  point_name VARCHAR(255) NULL,
  diagnosis_type VARCHAR(32) NOT NULL,
  max_status TINYINT NOT NULL DEFAULT -1 COMMENT '0正常 1报警 2危险 -1未定义',
  component_type VARCHAR(32) NULL,
  brand VARCHAR(128) NULL,
  model VARCHAR(128) NULL,
  frequencies_json TEXT NULL,
  unsupported_json TEXT NULL,
  meta_json TEXT NULL,
  create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
  KEY idx_engine_time (engine_code, create_time),
  KEY idx_type_time (diagnosis_type, create_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='振动诊断结果与证据追溯';