-- 逐信号（含 executed/skip_reason，用于区分「想买」与「买到了」）
-- 由 src/hdiv/data/schema.py 生成，请勿手工修改
CREATE TABLE IF NOT EXISTS `hd_backtest_signal` (
  `id`              BIGINT       NOT NULL AUTO_INCREMENT,
  `run_id`          VARCHAR(32)  NOT NULL,
  `symbol`          VARCHAR(12)  NOT NULL,
  `signal_date`     DATE         NOT NULL,
  `signal_type`     VARCHAR(8)   NOT NULL COMMENT 'BUY/SELL/HOLD/WATCH',
  `yield_value`     DECIMAL(18,8) NULL COMMENT '触发时的股息率',
  `yield_percentile` DECIMAL(12,6) NULL COMMENT '触发时的历史分位 %',
  `target_weight`   DECIMAL(12,8) NULL,
  `price`           DECIMAL(16,4) NULL,
  `executed`        TINYINT(1)   NOT NULL DEFAULT 0,
  `skip_reason`     VARCHAR(64)  NULL COMMENT 'LIMIT_UP/LIMIT_DOWN/SUSPENDED/NO_CASH/MIN_COMMISSION',
  `reason_json`     TEXT         NULL,
  `created_at`      DATETIME     NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_hd_bt_sig` (`run_id`,`symbol`,`signal_date`),
  KEY `ix_hd_bt_sig_type` (`run_id`,`signal_type`,`executed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回测信号流水';