/*
SQLyog Community v13.1.6 (64 bit)
MySQL - 8.0.33 : Database - db_quant
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_quant_test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `db_quant_test`;

/*Table structure for table `tb_member` */

DROP TABLE IF EXISTS `tb_member`;

CREATE TABLE `tb_member` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `authstring` varchar(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_member_daily_strategy` */

DROP TABLE IF EXISTS `tb_member_daily_strategy`;

CREATE TABLE `tb_member_daily_strategy` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mid` int DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `region` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `startdate` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `enddate` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `preUpper` float DEFAULT NULL,
  `preLower` float DEFAULT NULL,
  `chgUpper` float DEFAULT NULL,
  `chgLower` float DEFAULT NULL,
  `dealUpper` float DEFAULT NULL,
  `dealLower` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_member_daily_strategy_tb` */

DROP TABLE IF EXISTS `tb_member_daily_strategy_tb`;

CREATE TABLE `tb_member_daily_strategy_tb` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sid` int DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_member_daily_strategy_tb_item` */

DROP TABLE IF EXISTS `tb_member_daily_strategy_tb_item`;

CREATE TABLE `tb_member_daily_strategy_tb_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` int DEFAULT NULL,
  `label` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `prop` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sortable` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_mr_bias_info` */

DROP TABLE IF EXISTS `tb_mr_bias_info`;

CREATE TABLE `tb_mr_bias_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `stockcode` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tradedate` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stockopen` float DEFAULT NULL,
  `stockclose` float DEFAULT NULL,
  `preclose` float DEFAULT NULL,
  `high` float DEFAULT NULL,
  `low` float DEFAULT NULL,
  `bias` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1041 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_mr_daily_result` */

DROP TABLE IF EXISTS `tb_mr_daily_result`;

CREATE TABLE `tb_mr_daily_result` (
  `id` int NOT NULL AUTO_INCREMENT,
  `thcode` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pricavg` float DEFAULT NULL,
  `pctavg` float DEFAULT NULL,
  `amountavg` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15184 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_stock_basic_info` */

DROP TABLE IF EXISTS `tb_stock_basic_info`;

CREATE TABLE `tb_stock_basic_info` (
  `tscode` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stockcode` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
  `stockname` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stockarea` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `industry` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cnspell` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `market` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `list_date` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_hs` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `op_date` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`stockcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tb_stock_daily_info` */

DROP TABLE IF EXISTS `tb_stock_daily_info`;

CREATE TABLE `tb_stock_daily_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `thcode` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tradedate` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `stockopen` float DEFAULT NULL,
  `high` float DEFAULT NULL,
  `low` float DEFAULT NULL,
  `stockclose` float DEFAULT NULL,
  `preclose` float DEFAULT NULL,
  `stockchange` float DEFAULT NULL,
  `pctchg` float DEFAULT NULL,
  `vol` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `thcodetradedate` (`thcode`,`tradedate`)
) ENGINE=InnoDB AUTO_INCREMENT=42196 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;