CREATE TABLE IF NOT EXISTS robo_rebalance_signal ( rrs_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rrs_date DATETIME NOT NULL COMMENT '信号日期', rrs_type TINYINT NOT NULL COMMENT '信号类型', rrs_risk TINYINT NOT NULL COMMENT '风险等级', rrs_p_type VARCHAR(255) DEFAULT NULL COMMENT '投组类型', rrs_p_weight JSON DEFAULT NULL COMMENT '投组信息', rrs_effective TINYINT NOT NULL DEFAULT 0 COMMENT '是否生效', rrs_create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, rrs_update_time DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (rrs_id), INDEX (rrs_date), INDEX (rrs_type), INDEX (rrs_risk) ) ENGINE = InnoDB AUTO_INCREMENT = 0 DEFAULT CHARSET = utf8mb4 COMMENT '再平衡信号表'; CREATE TABLE IF NOT EXISTS robo_weight_drift ( rwd_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rwd_date DATETIME NOT NULL COMMENT '日期', rwd_risk TINYINT NOT NULL COMMENT '风险等级', rwd_weight DOUBLE NOT NULL COMMENT '高风险资产权重', rwd_drift DOUBLE NOT NULL COMMENT '资产权重漂移计算值', rwd_create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, rwd_update_time DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (rwd_id), UNIQUE INDEX (rwd_date, rwd_risk), INDEX (rwd_risk) ) ENGINE = InnoDB AUTO_INCREMENT = 0 DEFAULT CHARSET = utf8mb4 COMMENT '高风险资产权重漂移表';