/*
Navicat Premium Data Transfer
Source Server : local2
Source Server Type : MySQL
Source Server Version : 80021
Source Host : 192.168.1.100:3306
Source Schema : db_east_money
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 22/10/2020 16:42:24
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_bankuai
-- ----------------------------
DROP TABLE IF EXISTS `t_bankuai`;
CREATE TABLE `t_bankuai` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '板块代码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '板块名称',
`cate` int(0) NULL DEFAULT NULL COMMENT '1-地域 2-行业 3-概念',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 339 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_bankuai_gegu
-- ----------------------------
DROP TABLE IF EXISTS `t_bankuai_gegu`;
CREATE TABLE `t_bankuai_gegu` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '个股代码',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '个股名称',
`cate` int(0) NULL DEFAULT NULL COMMENT '1-地域 2-行业 3-概念',
`bkName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '板块代码',
`bkCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '板块名称',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code_bkcode`(`code`, `bkCode`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4083826 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_code
-- ----------------------------
DROP TABLE IF EXISTS `t_code`;
CREATE TABLE `t_code` (
`id` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代码',
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '中文名称',
`type` int(0) NULL DEFAULT NULL COMMENT '0：上证 1：深证',
`bkName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属主要板块',
`bkCode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属主要板块代码',
`shiYingLvD` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市盈率（动）',
`shiYingLvJ` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市盈率（静）',
`shiYingLvT` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市盈率（TTM）',
`shiJingLv` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市净率',
`shiXiaoLv` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市销率',
`meiGuJZC` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '每股净资产',
`jingZCSYLv` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '净资产收益率',
`zongGuBen` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总股本',
`zongZhi` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总值 ',
`liuTongGu` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流通股',
`liuZhi` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流值',
`heXinTiCai` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '核心题材',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code_type`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_day_line
-- ----------------------------
DROP TABLE IF EXISTS `t_day_line`;
CREATE TABLE `t_day_line` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代码',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
`market` int(0) NULL DEFAULT NULL COMMENT '交易所：0-上 1-深',
`riqi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开盘日期',
`kaipan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开盘价',
`shoupan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收盘价',
`zuigao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最高价',
`zuidi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最低价',
`chengjiaoliang` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成交量',
`chengjiaoer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成交额',
`zhenfu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '振幅',
`percent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '涨幅',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_id`(`id`) USING BTREE,
UNIQUE INDEX `idx_code_riqi`(`code`, `riqi`) USING BTREE,
INDEX `idx_all`(`code`, `name`, `market`, `riqi`, `zhenfu`, `percent`) USING BTREE,
INDEX `idx_riqi`(`riqi`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12658059 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_notify
-- ----------------------------
DROP TABLE IF EXISTS `t_notify`;
CREATE TABLE `t_notify` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`max` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上限',
`min` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下限',
`maxType` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态： 0-未提示， 1-已提示',
`minType` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态： 0-未提示， 1-已提示',
`percent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上下浮动,监控值：2,5,7,9.9',
`updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_temp
-- ----------------------------
DROP TABLE IF EXISTS `t_temp`;
CREATE TABLE `t_temp` (
`id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`cTime` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_time_line
-- ----------------------------
DROP TABLE IF EXISTS `t_time_line`;
CREATE TABLE `t_time_line` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`market` int(0) NULL DEFAULT NULL COMMENT '0- 1-',
`shijian` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`zuixinjia` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`percent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`chengjiaoliang` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`chengjiaoer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`zhenfu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`huanshoulv` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`shiyinglv` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`shijinglv` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`jinkai` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`zuoshou` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`zuigao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`zuidi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code_shijian`(`code`, `shijian`) USING BTREE,
INDEX `idx_all`(`code`, `name`, `market`, `shijian`, `zuixinjia`, `percent`, `chengjiaoliang`, `zhenfu`, `huanshoulv`) USING BTREE,
INDEX `idx_shijian`(`shijian`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38799924 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_tmp_day_line
-- ----------------------------
DROP TABLE IF EXISTS `t_tmp_day_line`;
CREATE TABLE `t_tmp_day_line` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '代码',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
`market` int(0) NULL DEFAULT NULL COMMENT '交易所：0-上 1-深',
`riqi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开盘日期',
`kaipan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开盘价',
`shoupan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收盘价',
`zuigao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最高价',
`zuidi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最低价',
`chengjiaoliang` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成交量',
`chengjiaoer` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成交额',
`zhenfu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '振幅',
`percent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '涨幅',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_id`(`id`) USING BTREE,
UNIQUE INDEX `idx_code_riqi`(`code`, `riqi`) USING BTREE,
INDEX `idx_all`(`code`, `name`, `market`, `riqi`, `zhenfu`, `percent`) USING BTREE,
INDEX `idx_riqi`(`riqi`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '缓存个股连接两天涨幅>15的记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_tmp_day_percent
-- ----------------------------
DROP TABLE IF EXISTS `t_tmp_day_percent`;
CREATE TABLE `t_tmp_day_percent` (
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`percent` decimal(18, 2) NOT NULL,
`day` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`updateTime` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
UNIQUE INDEX `idx_code_day`(`code`, `day`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_yanzheng1
-- ----------------------------
DROP TABLE IF EXISTS `t_yanzheng1`;
CREATE TABLE `t_yanzheng1` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`earn` decimal(10, 2) NULL DEFAULT NULL,
`price` decimal(10, 2) NULL DEFAULT NULL,
`time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 64057 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_yanzheng2
-- ----------------------------
DROP TABLE IF EXISTS `t_yanzheng2`;
CREATE TABLE `t_yanzheng2` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`earn` decimal(10, 2) NULL DEFAULT NULL,
`price` decimal(10, 2) NULL DEFAULT NULL,
`time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53714 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_yanzheng_notify
-- ----------------------------
DROP TABLE IF EXISTS `t_yanzheng_notify`;
CREATE TABLE `t_yanzheng_notify` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_zijinliu_bankuai
-- ----------------------------
DROP TABLE IF EXISTS `t_zijinliu_bankuai`;
CREATE TABLE `t_zijinliu_bankuai` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`shijian` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发生时间',
`type` int(0) NULL DEFAULT NULL COMMENT '板块：1-地区,，2-行业，3-概念',
`zhangfu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日涨跌幅',
`level_zhuli` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入净额',
`level_zhuli_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入占比',
`level_chaoda` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日超大单净流入净额',
`level_chaoda_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日超大单净流入占比',
`level_da` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日大单净流入净额',
`level_da_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日大单净流入占比',
`level_zhong` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日中单净流入净额',
`level_zhong_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日中单净流入占比',
`level_xiao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日小单净流入净额',
`level_xiao_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日小单净流入占比',
`first_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入最大股',
`first_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入最大股',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code_shijian`(`code`, `shijian`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3467012 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_zijinliu_gegu
-- ----------------------------
DROP TABLE IF EXISTS `t_zijinliu_gegu`;
CREATE TABLE `t_zijinliu_gegu` (
`id` int(0) NOT NULL AUTO_INCREMENT,
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`shijian` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发生时间',
`type` int(0) NULL DEFAULT NULL COMMENT '板块：1-地区,，2-行业，3-概念',
`zhangfu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日涨跌幅',
`level_zhuli` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入净额',
`level_zhuli_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日主力净流入占比',
`level_chaoda` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日超大单净流入净额',
`level_chaoda_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日超大单净流入占比',
`level_da` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日大单净流入净额',
`level_da_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日大单净流入占比',
`level_zhong` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日中单净流入净额',
`level_zhong_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日中单净流入占比',
`level_xiao` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日小单净流入净额',
`level_xiao_per` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '今日小单净流入占比',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_code_shijian`(`code`, `shijian`) USING BTREE,
INDEX `idx_shijian`(`shijian`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 317972285 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Procedure structure for pro_calc_percent
-- ----------------------------
DROP PROCEDURE IF EXISTS `pro_calc_percent`;
delimiter ;;
CREATE PROCEDURE `pro_calc_percent`(in dayType INTEGER)
BEGIN
declare done int DEFAULT 1;
declare var_code varchar(32);
declare var_percent decimal(18,2);
declare c_lines cursor for SELECT DISTINCT code FROM t_day_line tdl;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 0;
open c_lines;
loop1: loop
fetch c_lines into var_code;
if done = 0 then
leave loop1;
end if;
select sum(a) into var_percent from (
select CONVERT (percent ,decimal(18,2)) as a from t_day_line
where `code` = var_code order by riqi desc limit dayType) d;
REPLACE into t_tmp_day_percent
values(var_code,var_percent, dayType, NOW());
set done = 1;
end loop loop1;
close c_lines;
END
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;
