```[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;
```
