```[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:18:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_kind
-- ----------------------------
DROP TABLE IF EXISTS `fund_kind`;
CREATE TABLE `fund_kind` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fundCode` char(8) DEFAULT NULL COMMENT '基金編號',
`kind_name` varchar(64) DEFAULT NULL COMMENT '行業名稱',
`kind_rate` float DEFAULT NULL COMMENT '凈值比例',
`trend` int(11) DEFAULT NULL COMMENT '趨勢',
`report_no` varchar(64) DEFAULT NULL COMMENT '報告期數',
PRIMARY KEY (`id`),
KEY `fundcode` (`fundCode`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=38854 DEFAULT CHARSET=utf8mb4 COMMENT='基金行業';
```
