-- 敏感性扫描的每个参数组合及其绩效
-- 由 src/hdiv/data/schema.py 生成，请勿手工修改
CREATE TABLE IF NOT EXISTS `hd_sensitivity_point` (
  `id`            BIGINT       NOT NULL AUTO_INCREMENT,
  `sens_id`       VARCHAR(32)  NOT NULL,
  `point_index`   INT          NOT NULL,
  `param_values_json` TEXT     NOT NULL,
  `param_key`     VARCHAR(128) NULL COMMENT '单参数扫描时的主键（便于画曲线）',
  `run_id`        VARCHAR(32)  NULL COMMENT '对应回测 run',
  `cagr`          DECIMAL(18,8) NULL,
  `total_return`  DECIMAL(18,8) NULL,
  `max_drawdown`  DECIMAL(18,8) NULL,
  `sharpe`        DECIMAL(18,8) NULL,
  `calmar`        DECIMAL(18,8) NULL,
  `sortino`       DECIMAL(18,8) NULL,
  `trade_count`   INT          NULL,
  `turnover`      DECIMAL(18,8) NULL,
  `extra_json`    TEXT         NULL,
  `created_at`    DATETIME     NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hd_sens_pt` (`sens_id`,`point_index`),
  KEY `ix_hd_sens_pt_key` (`sens_id`,`param_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='敏感性扫描点';