```[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 09:17:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_history
-- ----------------------------
DROP TABLE IF EXISTS `fund_history`;
CREATE TABLE `fund_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fundCode` char(8) DEFAULT NULL COMMENT '基金代碼',
`date` date DEFAULT NULL COMMENT '日期',
`netValue` float DEFAULT NULL COMMENT '單位凈值',
`totalValue` float DEFAULT NULL COMMENT '累計凈值',
`dayOfGrowth` float DEFAULT NULL COMMENT '日漲幅',
PRIMARY KEY (`id`),
KEY `fundcode` (`fundCode`) USING BTREE,
KEY `date` (`date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=399499 DEFAULT CHARSET=utf8mb4;
```
