```[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:05:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fund_rate
-- ----------------------------
DROP TABLE IF EXISTS `fund_rate`;
CREATE TABLE `fund_rate` (
`fundCode` char(8) NOT NULL COMMENT '基金代碼',
`trusteeRate` float DEFAULT NULL COMMENT '基金管理費',
`serviceRate` float DEFAULT NULL COMMENT '基金托管費',
`saleRate` float DEFAULT NULL COMMENT '銷售服務費率',
`firstPurchae` float DEFAULT NULL COMMENT '首次購買最低金額',
`appendPurchae` float DEFAULT NULL COMMENT '追加購買最低金額',
`maxDayPurchae` float DEFAULT NULL COMMENT '單日累計申購限額',
`minPurchase` float DEFAULT NULL COMMENT '最小申購額度',
`minRedeem` float DEFAULT '1' COMMENT '最小贖回額度',
`minRegular` float DEFAULT NULL COMMENT '最小定投額度',
`regularStatus` tinyint(1) DEFAULT NULL COMMENT '定投狀態 1開啟 0關閉',
`subscribeRate` text COMMENT '認購費率集合',
`purchaeRate` text COMMENT '申購費率集合',
`redeemRate` text COMMENT '贖回費率集合',
`purchaeComfirmDay` int(3) DEFAULT NULL COMMENT '買入確認日',
`redeemComfirmDay` int(3) DEFAULT NULL COMMENT '賣出確認日',
`closedPeriod` varchar(25) DEFAULT NULL COMMENT '封閉期',
`openDate` varchar(255) DEFAULT NULL COMMENT '開放日期',
PRIMARY KEY (`fundCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```
