-- 画像运行头
-- 由 src/hdiv/data/schema.py 生成，请勿手工修改
CREATE TABLE IF NOT EXISTS `hd_profile_run` (
  `run_id`        VARCHAR(32)  NOT NULL,
  `name`          VARCHAR(64)  NOT NULL,
  `asof_date`     DATE         NOT NULL,
  `universe_run_id` VARCHAR(32) NULL COMMENT '来源股票池 run',
  `config_json`   MEDIUMTEXT   NOT NULL,
  `config_hash`   VARCHAR(64)  NOT NULL,
  `data_version`  VARCHAR(64)  NULL,
  `symbol_count`  INT          NOT NULL DEFAULT 0,
  `status`        VARCHAR(16)  NOT NULL DEFAULT 'OK',
  `created_at`    DATETIME     NOT NULL,
  PRIMARY KEY (`run_id`),
  KEY `ix_hd_prof_run_asof` (`asof_date`),
  KEY `ix_hd_prof_run_hash` (`config_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='画像运行头';