/*
Navicat MySQL Data Transfer
Source Server : bendi
Source Server Version : 50529
Source Host : localhost:3306
Source Database : fadmin
Target Server Type : MYSQL
Target Server Version : 50529
File Encoding : 65001
Date: 2023-05-29 16:22:22
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fa_jj
-- ----------------------------
DROP TABLE IF EXISTS `fa_jj`;
CREATE TABLE `fa_jj` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(30) DEFAULT NULL COMMENT '基金代码',
`pyin` varchar(30) DEFAULT NULL COMMENT '基金拼音简写',
`name` varchar(50) DEFAULT NULL,
`type` varchar(30) DEFAULT NULL COMMENT '基金类型',
`qpyin` varchar(30) DEFAULT NULL COMMENT '基金拼音全称',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18842 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of fa_jj
-- ----------------------------
INSERT INTO `fa_jj` VALUES ('1', '000001', 'HXCZHH', '华夏成长混合', '混合型-灵活', 'HUAXIACHENGZHANGHUNHE');
INSERT INTO `fa_jj` VALUES ('2', '000002', 'HXCZHH', '华夏成长混合(后端)', '混合型-灵活', 'HUAXIACHENGZHANGHUNHE');
INSERT INTO `fa_jj` VALUES ('3', '000003', 'ZHKZZZQA', '中海可转债债券A', '债券型-可转债', 'ZHONGHAIKEZHUANZHAIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('4', '000004', 'ZHKZZZQC', '中海可转债债券C', '债券型-可转债', 'ZHONGHAIKEZHUANZHAIZHAIQUANC');
INSERT INTO `fa_jj` VALUES ('5', '000005', 'JSZQXYDQZQ', '嘉实增强信用定期债券', '债券型-长债', 'JIASHIZENGQIANGXINYONGDINGQIZH');
INSERT INTO `fa_jj` VALUES ('6', '000006', 'XBLDLHCZHHA', '西部利得量化成长混合A', '混合型-偏股', 'XIBULIDELIANGHUACHENGZHANGHUNH');
INSERT INTO `fa_jj` VALUES ('7', '000008', 'JSZZ500ETFLJA', '嘉实中证500ETF联接A', '指数型-股票', 'JIASHIZHONGZHENG500ETFLIANJIEA');
INSERT INTO `fa_jj` VALUES ('8', '000009', 'YFDTTLCHBA', '易方达天天理财货币A', '货币型', 'YIFANGDATIANTIANLICAIHUOBIA');
INSERT INTO `fa_jj` VALUES ('9', '000010', 'YFDTTLCHBB', '易方达天天理财货币B', '货币型', 'YIFANGDATIANTIANLICAIHUOBIB');
INSERT INTO `fa_jj` VALUES ('10', '000011', 'HXDPJXHHA', '华夏大盘精选混合A', '混合型-灵活', 'HUAXIADAPANJINGXUANHUNHEA');
INSERT INTO `fa_jj` VALUES ('11', '000012', 'HXDPJXHHA', '华夏大盘精选混合A(后端)', '混合型-灵活', 'HUAXIADAPANJINGXUANHUNHEA');
INSERT INTO `fa_jj` VALUES ('12', '000013', 'YFDTTLCHBR', '易方达天天理财货币R', '货币型', 'YIFANGDATIANTIANLICAIHUOBIR');
INSERT INTO `fa_jj` VALUES ('13', '000014', 'HXJLZQA', '华夏聚利债券A', '债券型-混合债', 'HUAXIAJULIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('14', '000015', 'HXCZZQA', '华夏纯债债券A', '债券型-长债', 'HUAXIACHUNZHAIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('15', '000016', 'HXCZZQC', '华夏纯债债券C', '债券型-长债', 'HUAXIACHUNZHAIZHAIQUANC');
INSERT INTO `fa_jj` VALUES ('16', '000017', 'CTKCXHH', '财通可持续混合', '混合型-偏股', 'CAITONGKECHIXUHUNHE');
INSERT INTO `fa_jj` VALUES ('17', '000020', 'JSCCPZTZHHA', '景顺长城品质投资混合A', '混合型-偏股', 'JINGSHUNCHANGCHENGPINZHITOUZIH');
INSERT INTO `fa_jj` VALUES ('18', '000021', 'HXYSZZHH', '华夏优势增长混合', '混合型-偏股', 'HUAXIAYOUSHIZENGZHANGHUNHE');
INSERT INTO `fa_jj` VALUES ('19', '000024', 'DMSLZQZQA', '大摩双利增强债券A', '债券型-长债', 'DAMOSHUANGLIZENGQIANGZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('20', '000025', 'DMSLZQZQC', '大摩双利增强债券C', '债券型-长债', 'DAMOSHUANGLIZENGQIANGZHAIQUANC');
INSERT INTO `fa_jj` VALUES ('21', '000028', 'HFAXZQ', '华富安鑫债券', '债券型-混合债', 'HUAFUANXINZHAIQUAN');
INSERT INTO `fa_jj` VALUES ('22', '000029', 'FGHGCLLHPZHHA', '富国宏观策略灵活配置混合A', '混合型-灵活', 'FUGUOHONGGUANCELUELINGHUOPEIZH');
INSERT INTO `fa_jj` VALUES ('23', '000030', 'CCHXYXHH', '长城核心优选混合', '混合型-灵活', 'CHANGCHENGHEXINYOUXUANHUNHE');
INSERT INTO `fa_jj` VALUES ('24', '000031', 'HXFXHHA', '华夏复兴混合A', '混合型-偏股', 'HUAXIAFUXINGHUNHEA');
INSERT INTO `fa_jj` VALUES ('25', '000032', 'YFDXYZZQA', '易方达信用债债券A', '债券型-长债', 'YIFANGDAXINYONGZHAIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('26', '000033', 'YFDXYZZQC', '易方达信用债债券C', '债券型-长债', 'YIFANGDAXINYONGZHAIZHAIQUANC');
INSERT INTO `fa_jj` VALUES ('27', '000037', 'GFJNZQA', '广发景宁债券A', '债券型-长债', 'GUANGFAJINGNINGZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('28', '000039', 'NYGZZHH', '农银高增长混合', '混合型-偏股', 'NONGYINGAOZENGZHANGHUNHE');
INSERT INTO `fa_jj` VALUES ('29', '000041', 'HXQQGPQDII', '华夏全球股票(QDII)', 'QDII', 'HUAXIAQUANQIUGUPIAOQDII');
INSERT INTO `fa_jj` VALUES ('30', '000042', 'CTZZESG100ZSZQA', '财通中证ESG100指数增强A', '指数型-股票', 'CAITONGZHONGZHENGESG100ZHISHUZ');
INSERT INTO `fa_jj` VALUES ('31', '000043', 'JSMGCZGPRMB', '嘉实美国成长股票人民币', 'QDII', 'JIASHIMEIGUOCHENGZHANGGUPIAORE');
INSERT INTO `fa_jj` VALUES ('32', '000044', 'JSMGCZGPMYXH', '嘉实美国成长股票美元现汇', 'QDII', 'JIASHIMEIGUOCHENGZHANGGUPIAOME');
INSERT INTO `fa_jj` VALUES ('33', '000045', 'GYCYZZQA', '工银产业债债券A', '债券型-混合债', 'GONGYINCHANYEZHAIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('34', '000046', 'GYCYZZQB', '工银产业债债券B', '债券型-混合债', 'GONGYINCHANYEZHAIZHAIQUANB');
INSERT INTO `fa_jj` VALUES ('35', '000047', 'HXSZZQA', '华夏双债债券A', '债券型-混合债', 'HUAXIASHUANGZHAIZHAIQUANA');
INSERT INTO `fa_jj` VALUES ('36', '000048', 'HXSZZQC', '华夏双债债券C', '债券型-混合债', 'HUAXIASHUANGZHAIZHAIQUANC');
INSERT INTO `fa_jj` VALUES ('37', '000051', 'HXHS300ETFLJA', '华夏沪深300ETF联接A', '指数型-股票', 'HUAXIAHUSHEN300ETFLIANJIEA');
INSERT INTO `fa_jj` VALUES ('38', '000053', 'PHYCYNDKZQ', '鹏华永诚一年定开债券', '债券型-长债', 'PENGHUAYONGCHENGYINIANDINGKAIZ');
INSERT INTO `fa_jj` VALUES ('39', '000054', 'PHSZZLZQA', '鹏华双债增利债券A', '债券型-混合债', 'PENGHUASHUANGZHAIZENGLIZHAIQUA');
INSERT INTO `fa_jj` VALUES ('40', '000055', 'GFNZ100ETFLJMYQDIIA', '广发纳指100ETF联接美元(QDII)A', 'QDII', 'GUANGFANAZHI100ETFLIANJIEMEIYU');
INSERT INTO `fa_jj` VALUES ('41', '000056', 'JXXFSJHH', '建信消费升级混合', '混合型-灵活', 'JIANXINXIAOFEISHENGJIHUNHE');
INSERT INTO `fa_jj` VALUES ('42', '000057', 'ZYXFZTHH', '中银消费主题混合', '混合型-偏股', 'ZHONGYINXIAOFEIZHUTIHUNHE');
INSERT INTO `fa_jj` VALUES ('43', '000058', 'GLAATLHPZHH', '国联安安泰灵活配置混合', '混合型-灵活', 'GUOLIANANANTAILINGHUOPEIZHIHUN');
INSERT INTO `fa_jj` VALUES ('44', '000059', 'GLAZZYY100A', '国联安中证医药100A', '指数型-股票', 'GUOLIANANZHONGZHENGYIYAO100A');
INSERT INTO `fa_jj` VALUES ('45', '000061', 'HXSSHH', '华夏盛世混合', '混合型-偏股', 'HUAXIASHENGSHIHUNHE');
INSERT INTO `fa_jj` VALUES ('46', '000063', 'CSDZXXZTLHPZHH', '长盛电子信息主题灵活配置混合', '混合型-灵活', 'CHANGSHENGDIANZIXINXIZHUTILING');
INSERT INTO `fa_jj` VALUES ('47', '000064', 'DM18GYDKZC', '大摩18个月定开债C', '债券型-长债', 'DAMO18GEYUEDINGKAIZHAIC');
INSERT INTO `fa_jj` VALUES ('48', '000065', 'GFJDQDHHA', '国富焦点驱动混合A', '混合型-灵活', 'GUOFUJIAODIANQUDONGHUNHEA');
INSERT INTO `fa_jj` VALUES ('49', '000066', 'NAHXHHA', '诺安鸿鑫混合A', '混合型-偏股', 'NUOANHONGXINHUNHEA');
INSERT INTO `fa_jj` VALUES ('50', '000067', 'MSJYZZYXA', '民生加银转债优选A', '债券型-可转债', 'MINSHENGJIAYINZHUANZHAIYOUXUAN');
INSERT INTO `fa_jj` VALUES ('51', '000068', 'MSJYZZYXC', '民生加银转债优选C', '债券型-可转债', 'MINSHENGJIAYINZHUANZH
