|
|
|
|
|
/*
|
|
|
|
|
|
Navicat Premium Dump SQL
|
|
|
|
|
|
|
|
|
|
|
|
Source Server : 192.168.0.222
|
|
|
|
|
|
Source Server Type : MySQL
|
|
|
|
|
|
Source Server Version : 80031 (8.0.31)
|
|
|
|
|
|
Source Host : 192.168.0.222:3306
|
|
|
|
|
|
Source Schema : ry_refactor0120
|
|
|
|
|
|
|
|
|
|
|
|
Target Server Type : MySQL
|
|
|
|
|
|
Target Server Version : 80031 (8.0.31)
|
|
|
|
|
|
File Encoding : 65001
|
|
|
|
|
|
|
|
|
|
|
|
Date: 24/01/2026 10:59:49
|
|
|
|
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
|
|
|
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
|
-- Table structure for t_industry_index
|
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
|
DROP TABLE IF EXISTS `t_industry_index`;
|
|
|
|
|
|
CREATE TABLE `t_industry_index` (
|
|
|
|
|
|
`industry_index_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '行业指数代码（如802089.EI）',
|
|
|
|
|
|
`industry_index_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '行业指数名称（如“银行”）',
|
|
|
|
|
|
`component_count` int NULL DEFAULT NULL COMMENT '成份个数（行业包含个股数量）',
|
|
|
|
|
|
`trade_date` date NOT NULL COMMENT '交易日期',
|
|
|
|
|
|
`open_price` decimal(20, 2) NULL DEFAULT NULL COMMENT '开盘价（指数点位）',
|
|
|
|
|
|
`close_price` decimal(20, 2) NOT NULL COMMENT '收盘价（指数点位）',
|
|
|
|
|
|
`high_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '最高价（指数点位）',
|
|
|
|
|
|
`low_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '最低价（指数点位）',
|
|
|
|
|
|
`up_count` int NULL DEFAULT NULL COMMENT '成份股上涨家数',
|
|
|
|
|
|
`down_count` int NULL DEFAULT NULL COMMENT '成份股下跌家数',
|
|
|
|
|
|
`limit_up_count` int NULL DEFAULT NULL COMMENT '成份股涨停家数',
|
|
|
|
|
|
`limit_down_count` int NULL DEFAULT NULL COMMENT '成份股跌停家数',
|
|
|
|
|
|
`no_change_count` int NULL DEFAULT NULL COMMENT '成份股平盘家数',
|
|
|
|
|
|
`suspend_count` int NULL DEFAULT NULL COMMENT '成份股停牌家数',
|
|
|
|
|
|
`new_high_flag` tinyint NULL DEFAULT NULL COMMENT '近期创历史新高（1=是，0=否）',
|
|
|
|
|
|
`new_low_flag` tinyint NULL DEFAULT NULL COMMENT '近期创历史新低（1=是，0=否）',
|
|
|
|
|
|
`volume` bigint NULL DEFAULT NULL COMMENT '成交量（指数成交总量）',
|
|
|
|
|
|
`turnover` decimal(20, 2) NULL DEFAULT NULL COMMENT '成交额（单位：万元）',
|
|
|
|
|
|
`total_market_cap` decimal(20, 2) NULL DEFAULT NULL COMMENT '总市值（单位：万元）',
|
|
|
|
|
|
`free_circulation_cap` decimal(20, 2) NULL DEFAULT NULL COMMENT '自由流通市值（单位：万元）',
|
|
|
|
|
|
`price_change_rate` decimal(10, 4) NULL DEFAULT NULL COMMENT '涨跌幅（百分比，如1.2937=1.2937%）',
|
|
|
|
|
|
`pe_ttm` decimal(10, 2) NULL DEFAULT NULL COMMENT '市盈率PE(TTM)',
|
|
|
|
|
|
`pe_ttm_median` decimal(10, 2) NULL DEFAULT NULL COMMENT '市盈率PE(TTM)中位值',
|
|
|
|
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据创建时间（自动填充）',
|
|
|
|
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '数据更新时间（自动更新）',
|
|
|
|
|
|
PRIMARY KEY (`industry_index_code`, `trade_date`) USING BTREE,
|
|
|
|
|
|
INDEX `idx_t_industry_index_trade_date`(`trade_date` ASC) USING BTREE,
|
|
|
|
|
|
CONSTRAINT `t_industry_index_ibfk_1` FOREIGN KEY (`industry_index_code`) REFERENCES `t_industry_basic` (`industry_code`) ON DELETE RESTRICT ON UPDATE CASCADE
|
|
|
|
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '东财二级行业指数每日数据' ROW_FORMAT = Dynamic;
|
|
|
|
|
|
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
