-- 安全边际分项得分（plan.md §15）
-- 由 src/hdiv/data/schema.py 生成，请勿手工修改
CREATE TABLE IF NOT EXISTS `hd_profile_score` (
  `id`            BIGINT       NOT NULL AUTO_INCREMENT,
  `run_id`        VARCHAR(32)  NOT NULL,
  `symbol`        VARCHAR(12)  NOT NULL,
  `score_code`    VARCHAR(48)  NOT NULL COMMENT 'dividend_yield/valuation/financial_quality/balance_sheet/dividend_quality/composite',
  `score`         DECIMAL(12,6) NULL,
  `detail_json`   TEXT         NULL COMMENT '分项明细与所用锚点',
  `created_at`    DATETIME     NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hd_prof_score` (`run_id`,`symbol`,`score_code`),
  KEY `ix_hd_prof_score_v` (`run_id`,`score_code`,`score`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全边际得分';