Qionk/a-share-quant

1-- SQLPub / MySQL 建表脚本2-- 在 SQLPub 控制台 → SQL 工具中运行（www.sqlpub.com）3 4CREATE TABLE training_sessions (5    id VARCHAR(36) PRIMARY KEY,6    stock_code VARCHAR(20) NOT NULL,7    stock_name VARCHAR(100),8    trained_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,9    forecast_days INT DEFAULT 5,10    selected_models JSON,11    ensemble_weights JSON,12    predictions JSON,13    config_summary JSON,14    last_close_price DOUBLE,15    stock_data JSON16) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;17 18CREATE TABLE model_results (19    id VARCHAR(36) PRIMARY KEY,20    session_id VARCHAR(36) NOT NULL,21    model_name VARCHAR(50) NOT NULL,22    cv_metrics JSON,23    training_time DOUBLE,24    future_predictions JSON,25    future_conf_lower JSON,26    future_conf_upper JSON,27    test_predictions JSON,28    test_actuals JSON,29    test_returns JSON,30    test_returns_actual JSON,31    confidence_lower JSON,32    confidence_upper JSON,33    FOREIGN KEY (session_id) REFERENCES training_sessions(id) ON DELETE CASCADE34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;35 36CREATE INDEX idx_sessions_stock ON training_sessions(stock_code, trained_at);37CREATE INDEX idx_results_session ON model_results(session_id);