```[sql]
/*
Navicat MySQL Data Transfer
Source Server : 基金數據包年
Source Server Version : 50648
Source Host : 139.196.50.92:3306
Source Database : fund
Target Server Type : MYSQL
Target Server Version : 50648
File Encoding : 65001
Date: 2020-07-20 00:39:17
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_grow
-- ----------------------------
DROP TABLE IF EXISTS `fund_grow`;
CREATE TABLE `fund_grow` (
`fundCode` char(8) NOT NULL COMMENT '基金代碼',
`lastWeek` float DEFAULT NULL COMMENT '周增長率',
`lastWeekAvg` float DEFAULT NULL COMMENT '周同類平均漲跌率',
`lastWeekRank` int(11) DEFAULT NULL COMMENT '周同類排名',
`lastWeekCount` int(11) DEFAULT NULL COMMENT '周同類總數',
`lastMonth` float DEFAULT NULL COMMENT '近一月漲跌幅',
`lastMonthAvg` float DEFAULT NULL COMMENT '近一月同類漲跌幅',
`lastMonthRank` int(11) DEFAULT NULL COMMENT '近一月同類排名',
`lastMonthCount` int(11) DEFAULT NULL COMMENT '近一月同類總量',
`lastQuarter` float DEFAULT NULL COMMENT '近一季漲跌幅',
`lastQuarterAvg` float DEFAULT NULL,
`lastQuarterRank` int(11) DEFAULT NULL,
`lastQuarterCount` int(11) DEFAULT NULL,
`lastHalfYear` float DEFAULT NULL COMMENT '近半年漲跌幅',
`lastHalfYearAvg` float DEFAULT NULL,
`lastHalfYearRank` int(11) DEFAULT NULL,
`lastHalfYearCount` int(11) DEFAULT NULL,
`lastYear` float DEFAULT NULL COMMENT '近一年漲跌幅',
`lastYearAvg` float DEFAULT NULL,
`lastYearRank` int(11) DEFAULT NULL,
`lastYearCount` int(11) DEFAULT NULL,
`twoYear` float DEFAULT NULL,
`twoYearAvg` float DEFAULT NULL,
`twoYearRank` int(11) DEFAULT NULL,
`twoYearCount` int(11) DEFAULT NULL,
`thirdYear` float DEFAULT NULL,
`thirdYearAvg` float DEFAULT NULL,
`thirdYearRank` int(11) DEFAULT NULL,
`thirdYearCount` int(11) DEFAULT NULL,
`fiveYear` float DEFAULT NULL,
`fiveYearAvg` float DEFAULT NULL,
`fiveYearRank` int(11) DEFAULT NULL,
`fiveYearCount` int(11) DEFAULT NULL,
`nowYear` float DEFAULT NULL COMMENT '今年以來漲跌幅',
,
`nowYearAvg` float DEFAULT NULL,
`nowYearRank` int(11) DEFAULT NULL,
`nowYearCount` int(11) DEFAULT NULL,
`allYear` float DEFAULT NULL COMMENT '成立以來漲跌幅',
`allYearAvg` float DEFAULT NULL,
`allYearRank` int(11) DEFAULT NULL,
`allYearCount` int(11) DEFAULT NULL,
PRIMARY KEY (`fundCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
