CREATE TABLE `mo_report_base_info`
(
    `id`            int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `file_id`       int(11) NOT NULL,
    `report_date`   datetime     DEFAULT NULL COMMENT '报告日期',
    `report_name`   varchar(255) DEFAULT NULL COMMENT '报告名称',
    `report_type`   varchar(255) DEFAULT NULL COMMENT '报告类型',
    `with_contacts` tinyint(4) NOT NULL DEFAULT '0' COMMENT '观点报告是否存在管理人联系信息（包括联系电话、地址、姓名等敏感信息）',
    `isvalid`       int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`     int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`     int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`    datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`    datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COMMENT='报告基础信息表'

CREATE TABLE `mo_report_fund_info`
(
    `id`                        int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自动递增',
    `file_id`                   int(11) NOT NULL,
    `fund_name`                 varchar(255)   DEFAULT NULL COMMENT '基金的名称',
    `fund_code`                 varchar(50)    DEFAULT NULL COMMENT '基金的唯一识别代码',
    `company_name`              varchar(255)   DEFAULT NULL COMMENT '基金管理人的名称',
    `currency`                  varchar(20)    DEFAULT NULL COMMENT '基金交易使用的货币种类',
    `custodian_name`            varchar(255)   DEFAULT NULL COMMENT '基金托管人',
    `advisor_name`              varchar(255)   DEFAULT NULL COMMENT '投资顾问',
    `operation_type`            varchar(20)    DEFAULT NULL COMMENT '基金运作方式',
    `inception_date`            date           DEFAULT NULL COMMENT '基金成立日期',
    `investment_objective`      text COMMENT '投资目标',
    `fund_strategy_description` text COMMENT '投资策略',
    `secondary_benchmark`       varchar(255)   DEFAULT NULL COMMENT '业绩比较基准',
    `risk_return_desc`          text COMMENT '风险收益特征',
    `due_date`                  date           DEFAULT NULL COMMENT '基金到期日期',
    `reviewed`                  int(11) DEFAULT NULL COMMENT '信息披露报告是否经托管机构复核',
    `leverage`                  decimal(22, 6) DEFAULT NULL COMMENT '杠杆比例',
    `leverage_note`             text COMMENT '杠杆比例描述',
    `industry_trend`            text COMMENT '行业趋势',
    `fund_manager`              text COMMENT '基金经理描述',
    `isvalid`                   tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`                 int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`                 int(11) NOT NULL COMMENT '修改者Id',
    `createtime`                datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime`                datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COMMENT='报告解析结果之基金信息表'

CREATE TABLE `mo_report_fund_transaction`
(
    `id`                        int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `file_id`                   int(11) NOT NULL,
    `fund_account`              varchar(100)   DEFAULT NULL COMMENT '基金账户编号',
    `fund_name`                 varchar(100)   DEFAULT NULL COMMENT '基金名称',
    `distributor`               varchar(100)   DEFAULT NULL COMMENT '销售此基金产品的经销商或银行',
    `transaction_type`          varchar(50)    DEFAULT NULL COMMENT '业务类型（例如：申购、赎回）',
    `business_reason`           varchar(100)   DEFAULT NULL COMMENT '业务操作的原因或类型说明',
    `status`                    varchar(50)    DEFAULT NULL COMMENT '交易确认的状态（例如：已确认、待处理等）',
    `holding_date`              date           DEFAULT NULL COMMENT '交易确认的日期',
    `apply_date`                date           DEFAULT NULL COMMENT '申请的日期',
    `apply_amount`              decimal(22, 6) DEFAULT NULL COMMENT '申请的金额',
    `apply_share`               decimal(22, 6) DEFAULT NULL COMMENT '申请的基金份额数量',
    `amount`                    decimal(22, 6) DEFAULT NULL COMMENT '确认的金额',
    `share`                     decimal(22, 6) DEFAULT NULL COMMENT '确认的基金份额数量',
    `net_amount`                decimal(22, 6) DEFAULT NULL COMMENT '净认购/申购的金额，确认净额',
    `nav`                       decimal(22, 6) DEFAULT NULL COMMENT '单位净值',
    `confirmation_ratio`        decimal(22, 6) DEFAULT NULL COMMENT '确认比例',
    `ta_confirmation_number`    varchar(100)   DEFAULT NULL COMMENT '交易授权确认编号',
    `ta_number`                 varchar(100)   DEFAULT NULL COMMENT 'TA代码',
    `apply_no`                  varchar(100)   DEFAULT NULL COMMENT '申请单号',
    `share_balance`             decimal(22, 6) DEFAULT NULL COMMENT '份额余额',
    `share_category`            varchar(50)    DEFAULT NULL COMMENT '份额类别',
    `large_redemption_type`     varchar(50)    DEFAULT NULL COMMENT '巨额赎回方式',
    `reward_mark`               varchar(50)    DEFAULT NULL COMMENT '提成或保底标志',
    `holding_days`              int(11) DEFAULT NULL COMMENT '持有天数',
    `share_registry_date`       date           DEFAULT NULL COMMENT '份额明细注册日期',
    `fee`                       decimal(22, 6) DEFAULT NULL COMMENT '总费用',
    `interest`                  decimal(22, 6) DEFAULT NULL COMMENT '利息',
    `interest_to_fund_assets`   decimal(22, 6) DEFAULT NULL COMMENT '利息转份额/利息归基金资产',
    `trade_fee`                 decimal(22, 6) DEFAULT NULL COMMENT '交易费',
    `default_fee`               decimal(22, 6) DEFAULT NULL COMMENT '违约金',
    `performance_fee`           decimal(22, 6) DEFAULT NULL COMMENT '业绩报酬',
    `fee_discounts`             decimal(22, 6) DEFAULT NULL COMMENT '费用折扣',
    `performance_fee_discounts` decimal(22, 6) DEFAULT NULL COMMENT '业绩报酬折扣',
    `dividend_type`             varchar(50)    DEFAULT NULL COMMENT '分红方式',
    `dividend_registry_date`    date           DEFAULT NULL COMMENT '分红登记日',
    `dividend_payment_date`     date           DEFAULT NULL COMMENT '红利发放日',
    `base_share_dividend`       decimal(22, 6) DEFAULT NULL COMMENT '分红基数份额',
    `dividend_mode`             varchar(50)    DEFAULT NULL COMMENT '分红模式',
    `unit_dividend`             decimal(22, 6) DEFAULT NULL COMMENT '单位分红',
    `dividend_per_unit`         decimal(22, 6) DEFAULT NULL COMMENT '每单位分红',
    `total_dividend_amount`     decimal(22, 6) DEFAULT NULL COMMENT '红利总额',
    `actual_cash_dividend`      decimal(22, 6) DEFAULT NULL COMMENT '实发现金红利',
    `frozen_shares`             decimal(22, 6) DEFAULT NULL COMMENT '冻结份额',
    `frozen_amount`             decimal(22, 6) DEFAULT NULL COMMENT '冻结金额',
    `actual_performance_amount` decimal(22, 6) DEFAULT NULL COMMENT '实际业绩提成金额',
    `actual_performance_share`  decimal(22, 6) DEFAULT NULL COMMENT '实际提成份额',
    `isvalid`                   int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`                 int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`                 int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`                datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`                datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    `is_sync`                   tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否同步(0-否；1-是)',
    PRIMARY KEY (`id`),
    KEY                         `file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='交易流水表'

CREATE TABLE `mo_report_invest_industry`
(
    `id`            int(11) NOT NULL AUTO_INCREMENT,
    `file_id`       int(11) NOT NULL,
    `invest_type`   int(11) DEFAULT NULL COMMENT '投资地区: 1-境内, 2-港股通',
    `isb_code`      varchar(255)   DEFAULT NULL COMMENT '行业标准编码',
    `industry_code` varchar(255)   DEFAULT NULL COMMENT '行业分类编码',
    `industry_name` varchar(255)   DEFAULT NULL COMMENT '行业分类名称',
    `market_value`  decimal(22, 6) DEFAULT NULL COMMENT '公允价值',
    `ratio`         decimal(22, 6) DEFAULT NULL COMMENT '占基金资产净值的比例',
    `isvalid`       int(11) DEFAULT '1' COMMENT '是否有效：0-无效，1-有效',
    `creatorid`     int(11) DEFAULT NULL COMMENT '创建者Id',
    `createtime`    datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updaterid`     int(11) DEFAULT NULL COMMENT '修改者Id',
    `updatetime`    datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `INVEST_INDUSTRY_UIX_KEY` (`file_id`,`invest_type`,`isb_code`,`industry_code`,`industry_name`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='按行业分类的股票投资组合'

CREATE TABLE `mo_report_investor_info`
(
    `id`                 int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自动递增',
    `file_id`            int(11) NOT NULL,
    `investor_name`      varchar(255) DEFAULT NULL COMMENT '投资人的姓名',
    `investor_type`      varchar(50)  DEFAULT NULL COMMENT '投资人的类别（例如：个人、机构）',
    `certificate_type`   varchar(50)  DEFAULT NULL COMMENT '证件类型（例如：身份证、护照）',
    `certificate_number` varchar(50)  DEFAULT NULL COMMENT '投资人证件号码',
    `fund_account`       varchar(50)  DEFAULT NULL COMMENT '基金账户编号',
    `trading_account`    varchar(50)  DEFAULT NULL COMMENT '投资者交易账号',
    `isvalid`            tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`          int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`          int(11) NOT NULL COMMENT '修改者Id',
    `createtime`         datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime`         datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    KEY                  `file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='报告解析结果之投资者信息表'

CREATE TABLE `mo_report_net_report`
(
    `id`               int(11) NOT NULL AUTO_INCREMENT,
    `file_id`          int(11) NOT NULL,
    `level`            varchar(20)    DEFAULT NULL COMMENT '基金分级',
    `valuation_date`   date           DEFAULT NULL COMMENT '估值日期',
    `nav`              decimal(22, 6) DEFAULT NULL COMMENT '单位净值',
    `cumulative_nav`   decimal(22, 6) DEFAULT NULL COMMENT '累计净值',
    `end_total_shares` decimal(22, 6) DEFAULT NULL COMMENT '基金份额总额',
    `fund_asset_size`  decimal(22, 6) DEFAULT NULL COMMENT '基金资产净值',
    `isvalid`          int(11) DEFAULT '1' COMMENT '是否有效：0-无效，1-有效',
    `creatorid`        int(11) DEFAULT NULL COMMENT '创建者Id',
    `createtime`       datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updaterid`        int(11) DEFAULT NULL COMMENT '修改者Id',
    `updatetime`       datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `NET_REPORT_UIX_KEY` (`file_id`,`level`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='基协报告净值月报'

CREATE TABLE `mo_report_share_change`
(
    `id`                int(11) NOT NULL AUTO_INCREMENT,
    `file_id`           int(11) NOT NULL,
    `level`             varchar(20)    DEFAULT NULL COMMENT '基金分级',
    `init_total_shares` decimal(22, 6) DEFAULT NULL COMMENT '报告期期初基金份额总额',
    `subscription`      decimal(22, 6) DEFAULT NULL COMMENT '报告期期间基金总申购份额',
    `redemption`        decimal(22, 6) DEFAULT NULL COMMENT '减: 报告期期间基金总赎回份额',
    `split`             decimal(22, 6) DEFAULT NULL COMMENT '报告期期间基金拆分变动份额',
    `share_per_asset`   decimal(22, 6) DEFAULT NULL COMMENT '期末基金总份额/期末基金实缴总额',
    `isvalid`           int(11) DEFAULT '1' COMMENT '是否有效：0-无效，1-有效',
    `creatorid`         int(11) DEFAULT NULL COMMENT '创建者Id',
    `createtime`        datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updaterid`         int(11) DEFAULT NULL COMMENT '修改者Id',
    `updatetime`        datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `UIX_KEY` (`file_id`,`level`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='基金份额变动情况'

CREATE TABLE `mo_report_financial_indicators`
(
    `id`                   int(11) NOT NULL AUTO_INCREMENT,
    `file_id`              int(11) NOT NULL,
    `level`                varchar(50)    DEFAULT NULL COMMENT '基金分级',
    `end_date`             int(11) DEFAULT NULL COMMENT '年度',
    `realized_income`      decimal(22, 6) DEFAULT NULL COMMENT '本期已实现收益',
    `profit`               decimal(22, 6) DEFAULT NULL COMMENT '本期利润',
    `undistributed_profit` decimal(22, 6) DEFAULT NULL COMMENT '期末可供分配利润',
    `fund_asset_size`      decimal(22, 6) DEFAULT NULL COMMENT '期末基金净资产',
    `nav`                  decimal(22, 6) DEFAULT NULL COMMENT '报告期期末单位净值',
    `isvalid`              int(11) DEFAULT '1' COMMENT '是否有效：0-无效，1-有效',
    `creatorid`            int(11) DEFAULT NULL COMMENT '创建者Id',
    `createtime`           datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updaterid`            int(11) DEFAULT NULL COMMENT '修改者Id',
    `updatetime`           datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `UNIQUE_FINANCIAL_INDICATORS` (`file_id`,`level`,`end_date`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='报告主要财务指标'

CREATE TABLE `mo_report_asset_allocation`
(
    `id`           int(11) NOT NULL AUTO_INCREMENT,
    `file_id`      int(11) NOT NULL,
    `asset_type`   varchar(255)   DEFAULT NULL COMMENT '资产类别',
    `column_name`  varchar(255)   DEFAULT NULL COMMENT '统计列名',
    `market_value` decimal(22, 6) DEFAULT NULL COMMENT '金额(元)',
    `remark`       varchar(50)    DEFAULT NULL COMMENT '备注',
    `isvalid`      int(11) DEFAULT '1' COMMENT '是否有效：0-无效，1-有效',
    `creatorid`    int(11) DEFAULT NULL COMMENT '创建者Id',
    `createtime`   datetime       DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updaterid`    int(11) DEFAULT NULL COMMENT '修改者Id',
    `updatetime`   datetime       DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `ASSET_ALLOCATION_UIX_KEY` (`file_id`,`asset_type`,`column_name`,`market_value`,`remark`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COMMENT='基金资产组合情况'

CREATE TABLE `mo_mailbox_info`
(
    `id`          int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `type`        int(11) DEFAULT NULL COMMENT '邮箱类型:1-QQ邮箱,2-腾讯企业邮箱,3-网易邮箱,4-新浪邮箱,99-其他',
    `email`       varchar(255) DEFAULT NULL COMMENT '邮箱账号',
    `password`    varchar(255) DEFAULT NULL COMMENT '邮箱密码',
    `protocol`    varchar(255) DEFAULT NULL COMMENT '协议',
    `server`      varchar(255) DEFAULT NULL COMMENT '收件服务器',
    `port`        varchar(255) DEFAULT NULL COMMENT '端口',
    `cron`        varchar(255) DEFAULT NULL COMMENT 'cron表达式',
    `open_status` int(11) DEFAULT '0' COMMENT '是否开启，0-不开启，1-开启',
    `description` text COMMENT '备注信息',
    `isvalid`     int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`   int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`   int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`  datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`  datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='邮箱信息表'

CREATE TABLE `mo_email_file_info`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `email_id`   int(11) NOT NULL COMMENT '邮件id',
    `fund_id`    int(11) DEFAULT NULL COMMENT '基金id',
    `file_name`  varchar(255)  NOT NULL COMMENT '附件名称',
    `file_path`  varchar(1024) NOT NULL COMMENT '附件路径',
    `ai_parse`   tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否利用ai工具来解析的',
    `ai_file_id` varchar(64) DEFAULT NULL COMMENT 'ai解析时上传的文件id（方便重新解析）',
    `isvalid`    tinyint(4) NOT NULL DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效',
    `creatorid`  int(11) NOT NULL COMMENT '创建者Id',
    `updaterid`  int(11) NOT NULL COMMENT '修改者Id',
    `createtime` datetime    DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updatetime` datetime    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8 COMMENT='邮件附件信息表'

CREATE TABLE `mo_email_parse_info`
(
    `id`           int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `sender_email` varchar(255) DEFAULT NULL COMMENT '邮件发送方',
    `email`        varchar(255) DEFAULT NULL COMMENT '邮箱地址',
    `email_key`    varchar(64)  DEFAULT NULL,
    `email_date`   datetime     DEFAULT NULL COMMENT '邮箱日期',
    `parse_date`   datetime     DEFAULT NULL COMMENT '解析日期',
    `email_title`  varchar(255) DEFAULT NULL COMMENT '邮件主题',
    `email_type`   int(11) DEFAULT NULL,
    `parse_status` int(11) DEFAULT NULL COMMENT '解析状态',
    `fail_reason`  text COMMENT '失败原因',
    `attr_size`    int(11) DEFAULT NULL COMMENT '附件文件大小，byte',
    `isvalid`      int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`    int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`    int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime`   datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime`   datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COMMENT='邮件解析信息表'

CREATE TABLE `mo_email_field_mapping`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `code`       varchar(255) DEFAULT NULL COMMENT '字段编码',
    `name`       text COMMENT '字段(多个以英文逗号隔开)',
    `type`       int(11) DEFAULT NULL COMMENT '3-定期报告，4-交易流水确认函，0-共用的',
    `isvalid`    int(11) DEFAULT '1' COMMENT '记录的有效性；1-有效；0-无效；',
    `creatorid`  int(11) DEFAULT NULL COMMENT '创建者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `updaterid`  int(11) DEFAULT NULL COMMENT '修改者Id;第一次创建时与Creator值相同，修改时与修改人值相同',
    `createtime` datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime` datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='邮件字段映射表'

CREATE TABLE `mo_task_record`
(
    `id`         int(11) NOT NULL AUTO_INCREMENT COMMENT '主键Id',
    `task_key`   varchar(50) NOT NULL COMMENT '任务的标识',
    `start_time` datetime DEFAULT NULL COMMENT '任务开始执行的时间',
    `end_time`   datetime DEFAULT NULL COMMENT '任务执行结束时的时间',
    `status`     int(4) DEFAULT '0' COMMENT '任务执行状态，0-执行中，1-执行完成，2-执行失败',
    `err_msg`    text COMMENT '任务执行失败时的信息',
    `createtime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间,默认第一次创建的getdate()时间',
    `updatetime` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间;第一次创建时与CreatTime值相同，修改时与修改时间相同',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8 COMMENT='任务执行记录表（轮询任务的执行记录表，前面的任务未执行完成时不允许重复执行）'



INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundName', '基金名称,产品名称', 0, 1, null, null, '2025-02-20 15:54:06', '2025-02-20 15:54:06');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundCode', '产品代码,基金代码', 0, 1, null, null, '2025-02-20 15:54:06', '2025-02-20 15:54:06');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('companyName', '管理人,基金管理人', 0, 1, null, null, '2025-02-20 15:54:06', '2025-02-20 15:54:06');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('currency', '币种,货币种类', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('investorName', '投资人,客户名称,投资者名称,投资者姓名,投资者,投资人名称,委托人名称,委托人姓名', 4, 1, null, null, '2025-02-20 16:05:35', '2025-03-18 16:07:36');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('investorType', '投资人类别,投资者类型,投资人类型', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-22 09:18:54');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('certificateType', '证件类型,投资者证件类型', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('certificateNumber', '证件号码,投资者证件号码', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundAccount', '基金账号,投资者基金账号', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('tradingAccount', '交易账号,投资者交易账号', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('distributor', '销售商,销售机构', 4, 1, null, null, '2025-02-20 16:05:35', '2025-02-20 16:05:35');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('nav', '单位净值,再投资单位净值,期末单位净值', 0, 1, null, null, '2025-02-20 17:17:20', '2025-02-22 09:41:48');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('transactionType', '业务类型,业务代码,业务类别', 4, 1, null, null, '2025-02-20 18:07:51', '2025-03-11 18:32:56');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('businessReason', '业务类型原因,失败原因,原因', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('status', '确认状态', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('holdingDate', '确认日期,交易确认日期', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyDate', '申请日期', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyAmount', '申请的金额,申请金额,申请金额(元)', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:39');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyShare', '申请的份额,申请份额,申请的基金份额数量', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('amount', '确认的金额,确认金额,确认金额(元),业绩报酬计提金额,再投资金额,再投资红利金额,原确认金额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:39');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('share', '确认的份额,确认份额,扣减份额,再投资份额,持有份额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-28 17:28:30');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('netAmount', '净认购/申购的金额,确认净额', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fee', '交易费,手续费用,交易费(元),手续费用(元),总费用,总费用(元),再投资费用', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('confirmationRatio', '确认比例', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('taConfirmationNumber', 'TA确认号,TA确认编号,确认单号,TA确认单号', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('interest', '利息,利息(元)', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-22 11:04:38');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('interestToFundAssets', '利息转份额,利息归基金资产', 4, 1, null, null, '2025-02-20 18:07:51', '2025-02-20 18:08:10');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('applyNo', '申请单号', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareBalance', '份额余额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareCategory', '份额类别', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('largeRedemptionType', '巨额赎回方式', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('tradeFee', '交易费,交易费(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('defaultFee', '违约金,违约金(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('performanceFee', '业绩报酬,业绩报酬(元)', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('feeDiscounts', '费用折扣', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('performanceFeeDiscounts', '业绩报酬折扣', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendRegistryDate', '分红登记日', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendPaymentDate', '红利发放日,红利下发日', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('baseShareDividend', '分红基数份额,分红总份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendMode', '分红模式', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('unitDividend', '单位分红', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendPerUnit', '每单位分红', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('totalDividendAmount', '红利总额,分红总金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualCashDividend', '实发现金红利,实际所得现金红利', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('frozenShares', '冻结份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('frozenAmount', '冻结金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualPerformanceAmount', '实际业绩提成金额,实际提成金额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('actualPerformanceShare', '实际提成份额,实际业绩提成份额', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('rewardMark', '提成或保底标志', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('holdingDays', '持有天数', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareRegistryDate', '份额明细注册日期', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('taNumber', 'TA代码', 4, 1, null, null, '2025-02-22 11:04:39', '2025-02-22 11:05:32');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dividendType', '分红方式', 4, 1, null, null, '2025-02-22 13:41:57', '2025-02-28 17:30:31');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('advisorName', '投资顾问(如有),投资顾问,投资顾问（如有）', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('custodianName', '基金托管人,基金托管人(如有),基金托管人（如有）', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundManager', '基金经理', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundStrategyDescription', '投资策略', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('inceptionDate', '成立日期,基金成立日期', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('industryTrend', '行业趋势', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('investmentObjective', '投资目标', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('leverage', '杠杆比例', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('leverageNote', '杠杆比例描述', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('operationType', '运作方式,基金运作方式', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('riskReturnDesc', '风险收益特征', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('secondaryBenchmark', '业绩比较基准,业绩比较基准(如有),业绩比较基准（如有）', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('companyName', '基金管理人,管理人', 3, 1, null, null, '2024-10-09 14:39:26', '2025-04-24 17:24:05');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('dueDate', '基金到期日期,到期日期', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('isReviewed', '信息披露报告是否经托管机构复核', 3, 1, null, null, '2024-10-09 14:39:26', '2024-10-09 14:39:26');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('level', '基金分级,分级,分级基金', 3, 1, null, null, '2024-10-09 14:45:05', '2024-10-09 14:45:05');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('valuationDate', '估值日期', 3, 1, null, null, '2024-10-09 14:45:05', '2024-10-09 14:45:05');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('assetShare', '基金份额总额,基金份额总额(份),基金总份额', 3, 1, null, null, '2024-10-09 17:18:05', '2025-04-23 17:31:27');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('assetNet', '基金资产净值,资产净值,总资产净值,资产净值元,总净值,规模,子产品基金规模,产品资产净值,基金总净值,基金总净值元,资产净值市值,基金净资产,期末基金净资产,期末基金资产净值', 3, 1, null, null, '2024-10-09 17:26:00', '2024-10-09 17:26:00');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('undistributedProfit', '期末可供分配利润', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('realizedIncome', '本期已实现收益', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('profit', '本期利润', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('yearly', '年度', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('initTotalShares', '报告期期初基金份额总额', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('redemption', '减:报告期期间基金总赎回份额,减报告期期间基金总赎回份额,报告期期间基金总赎回份额', 3, 1, null, null, '2024-10-10 14:13:49', '2025-04-12 16:48:27');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('sharePerAsset', '期末基金总份额/期末基金实缴总额,报告期期末基金份额总额', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('splitChangeShare', '报告期期间基金拆分变动份额', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('subscription', '报告期期间基金总申购份额', 3, 1, null, null, '2024-10-10 14:13:49', '2024-10-10 14:13:49');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('shareNavRet', '基金份额累计净值增长率', 3, 1, null, null, '2024-10-11 11:04:47', '2024-10-11 11:04:47');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('undistributedShareProfit', '期末可供分配基金份额利润', 3, 1, null, null, '2024-10-11 11:04:47', '2024-10-11 11:04:47');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundName', '基金名称,产品名称,产品全称,基金产品,名称,资产名称,账户名称,账套名称,子产品名称,项目名称', 3, 1, null, null, '2024-10-15 15:57:55', '2024-10-15 15:57:55');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('fundCode', '备案编码,协会备案编号,协会备案编码,协会备案代码,基金协会代码,产品编码,产品代码,产品备案号,产品备案编码,基金代码,基金编码,资产代码,代码,子产品代码,协会代码,基金编号', 3, 1, null, null, '2024-10-15 15:58:26', '2025-04-12 11:41:01');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('nav', '单位净值,单位净值元,当日单位净值,今日单位净值,计提前单位净值,实际净值,基金净值,资产份额净值,资产份额净值元,份额净值,基金份额净值,基金份额净值元,基金单位净值,虚拟净值提取前单位净值,报告期期末单位净值,虚拟计提前单位净值,试算前单位净值,期末单位净值,子产品单位净值,产品单位净值,本级别单位净值,委托资产份额净值元,期末基金份额净值', 3, 1, null, null, '2024-10-15 15:58:43', '2024-10-15 15:58:43');
INSERT INTO rz_market_operate_ppwfund.mo_email_field_mapping (code, name, type, isvalid, creatorid, updaterid, createtime, updatetime) VALUES ('cumulativeNavWithdrawal', '累计净值,累计净值元,累计单位净值,累计单位净值元,虚拟计提前累计单位净值,虚拟计提前累计净值,虚拟净值提取前累计单位净值,基金份额累计净值,计提前累计净值,报告期期末单位累计净值,实际累计净值,资产份额累计净值,资产份额累计净值元,期末累计净值,当日累计净值,基金份额累计单位净值,基金累计单位净值,产品累计单位净值,累计后单位净值,单位累计净值,基金累计净值,试算前累计单位净值,子产品累计净值,本级别累计单位净值,委托资产份额累计净值元,基金份额累计净值元,份额累计净值', 3, 1, null, null, '2024-10-15 15:59:44', '2024-10-15 15:59:44');


create table mo_email_tg_config
(
    id         int auto_increment
        primary key,
    tg         varchar(50)                        null comment '托管方',
    email      varchar(50)                        null comment '托管方邮箱',
    isvalid    int      default 1                 null comment '是否有效：0-无效，1-有效',
    creatorid  int                                null comment '创建者Id',
    createtime datetime default CURRENT_TIMESTAMP null comment '创建时间',
    updaterid  int                                null comment '修改者Id',
    updatetime datetime default CURRENT_TIMESTAMP null on update CURRENT_TIMESTAMP comment '更新时间'
)
    comment '托管邮箱配置表';


alter table mo_email_file_info
    add parse_status int default 1 null comment '当前报告解析状态，1-成功，0或其他-失败' after ai_file_id;

alter table mo_email_file_info
    add fail_reason varchar(255) null comment '解析失败的原因' after parse_status;
