```[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-08-06 00:00:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_hold_rate
-- ----------------------------
DROP TABLE IF EXISTS `fund_hold_rate`;
CREATE TABLE `fund_hold_rate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fundCode` char(8) DEFAULT NULL,
`stock` float DEFAULT NULL COMMENT '股票占比',
`bond` float DEFAULT NULL COMMENT '債券占比',
`bank` float DEFAULT NULL COMMENT '銀行存款',
`report_date` date DEFAULT NULL COMMENT '報告時間',
PRIMARY KEY (`id`),
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8mb4;
```
