54 lines
20 KiB
SQL
54 lines
20 KiB
SQL
-- BIZ_TMPL_TYPE 字典增加 综合信息授权书 字典值 09
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20601878931649331200', '09', '综合信息授权书', 9, '综合信息授权书', '20444811324770222080', '007001', '007', '2022-03-15 20:52:00', '2039-03-17', NULL, NULL, NULL, NULL, 1);
|
||
|
||
-- ZHXXSQS_PRD_CONFIG 字典增加 综合信息授权书回传配置字典值 /wtdksit/upload/xdl/%s/imagezhxxsq/:xdl-imagezhxxsq-%s-%s.pdf:imagezhxxsq.ok
|
||
INSERT INTO `rec_loan`.`sys_select`(`id`, `select_name`, `select_key`, `select_desc`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20605121920190382080', '综合信息授权书路径配置', 'ZHXXSQS_PRD_CONFIG', '综合信息授权书路径配置', '007001', '007', '2022-03-24 19:38:28', '2023-05-19', NULL, NULL, NULL, NULL, 1);
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20605122089719955456', 'P22071001', '/wtdksit/upload/xdl/%s/imagezhxxsq/:xdl-imagezhxxsq-%s-%s.pdf:imagezhxxsq.ok', 0, '上传路径:文件名:ok文件名', '20605121920190382080', '007001', '007', '2022-03-24 19:39:09', '2023-05-19', '007001', '007', '2022-03-24 20:06:02', '2023-05-19', 1);
|
||
-- 新大陆还款类型支持字典 提前全部结清，指定逾期期数还款，代偿结清
|
||
INSERT INTO `rec_loan`.`sys_select`(`id`, `select_name`, `select_key`, `select_desc`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20617767169484128256', '新大陆还款类型', 'XDL_RPY_TYPE_REPAY_INFO', '新大陆还款类型', '007001', '007', '2022-04-28 17:06:11', '2041-08-10', NULL, NULL, NULL, NULL, 1);
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20617767410069405696', '1', '提前全部结清', 1, '提前全部结清', '20617767169484128256', '007001', '007', '2022-04-28 17:07:08', '2041-08-10', NULL, NULL, NULL, NULL, 1);
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20617767445360279552', '6', '指定逾期期数还款', 2, '指定逾期期数还款', '20617767169484128256', '007001', '007', '2022-04-28 17:07:17', '2041-08-10', NULL, NULL, NULL, NULL, 1);
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20617767478403006464', '7', '代偿结清', 3, '代偿结清', '20617767169484128256', '007001', '007', '2022-04-28 17:07:24', '2041-08-10', NULL, NULL, NULL, NULL, 1);
|
||
|
||
-- 合同管理->合同模板列表增加 新大陆综合信息授权书 协议模板编号 XDLZHXXSQS
|
||
INSERT INTO `rec_loan`.`biz_cont_tmpl`(`id`, `tmpl_code`, `tmpl_name`, `prd_code`, `sign_type`, `tmpl_type`, `sign_tmpl_code`, `local_tmpl_path`, `remote_download_url`, `position_type`, `template_params`, `bank_code`, `app_sts`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `remark`, `cur_vers`, `inst_no`, `tmpl_provider`) VALUES (601881080055726081, 'XDLZHXXSQS', '新大陆综合信息授权书', 'P22071001', '2', '09', 'XDLZHXXSQS', '', NULL, '2', 'xxsq1:本单位作为借款人（包括共同还款人）向贵行申请/办理授信业务及其他金融业务的，用于授信前调查、审查审批、放款支用、贷后检查、贷款清收以及其他业务存续期管理等用途的:CHECKED,xxsq2:本单位作为担保人（包括保证人、抵（质）押人、债务加入人或以其他方式提供增信的主体，以下统称“担保人”），用于贵行对本单位提供担保的审核、放款支用、贷后检查、贷款清收以及其他业务存续期管理等用途的:CHECKED,xxsq3:本单位关联单位向贵行申请办理授信业务或作为担保人的业务，用于相应业务办理和后续管理过程中了解本单位信用状况的:CHECKED,xxsq4:本单位法定代表人、负责人、股东、发起人、出资人或实际控制人、高级管理人员等重要关系人向贵行申请办理授信业务或作为担保人的业务，用于相应业务办理和后续管理过程中了解本单位信用状况的:CHECKED,custName:法定代表人/授权代表（签名或盖名章）:,signDateYear:年:,signDateMonth:月:,signDateDay:日:', '007', '30', '007001', '007', '2039-03-17', '2022-03-15 21:01:21', NULL, NULL, '2039-03-17', '2022-03-15 21:01:21', NULL, 1, NULL, 'BANK');
|
||
INSERT INTO `rec_loan`.`biz_cont_signer_config`(`id`, `tmpl_id`, `signer_order`, `signer_type`, `signer_name`, `signer_id_type`, `signer_id_no`, `signer_mail`, `position_type`, `chapte_name`, `chapte_json`, `search_key`, `search_extend`, `search_convert_extend`, `sign_level`, `sign_id`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `remark`, `cur_vers`, `signer_key`, `user_id`) VALUES (601881287543754752, '601881080055726081', '0', '0', NULL, NULL, NULL, NULL, '2', NULL, NULL, '盖章', NULL, '{\"fixX\": 20,\"fixY\": -10}', '0', NULL, '007001', '007', '2039-03-17', '2022-03-15 21:00:32', NULL, NULL, NULL, NULL, NULL, 1, 'FIRST', NULL);
|
||
|
||
-- 新大陆产品参数校验 增加 ip地址和图片流水号
|
||
INSERT INTO `rec_loan`.`prd_tree`(`id`, `label`, `code`, `pid`, `is_empty`, `mix_length`, `max_length`, `key_value`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`, `prd_code`, `regex`) VALUES (607226528266190848, 'IP地址', 'ipAddr', '572358774052880384', '0', NULL, '32', '', '007001', '007', '2022-03-30 15:01:26', '2040-07-14', '007001', '007', '2022-05-10 20:15:52', '2041-12-04', 1, 'P22071001', '^([1-9]|[1-9]\\d|1\\d{2}|2[0-4]\\d|25[0-5])(\\.(\\d|[1-9]\\d|1\\d{2}|2[0-4]\\d|25[0-5])){3}$');
|
||
INSERT INTO `rec_loan`.`prd_tree`(`id`, `label`, `code`, `pid`, `is_empty`, `mix_length`, `max_length`, `key_value`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`, `prd_code`, `regex`) VALUES (607226666179100672, '活体识别图片流水号', 'imgNo', '572358774052880384', '0', NULL, '200', NULL, '007001', '007', '2022-03-30 15:01:59', '2040-07-14', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
||
INSERT INTO `rec_loan`.`prd_tree`(`id`, `label`, `code`, `pid`, `is_empty`, `mix_length`, `max_length`, `key_value`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`, `prd_code`, `regex`) VALUES (607226750308450304, 'IP地址', 'ipAddr', '571719092189265920', '0', NULL, '32', NULL, '007001', '007', '2022-03-30 15:02:19', '2040-07-14', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
||
INSERT INTO `rec_loan`.`prd_tree`(`id`, `label`, `code`, `pid`, `is_empty`, `mix_length`, `max_length`, `key_value`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`, `prd_code`, `regex`) VALUES (607226793316843520, 'IP地址', 'ipAddr', '571716705814839296', '0', NULL, '32', NULL, '007001', '007', '2022-03-30 15:02:29', '2040-07-14', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
||
-- 删除活体识别分和活体识是否通过
|
||
DELETE FROM prd_tree WHERE ID = '572445918519885824';
|
||
DELETE FROM prd_tree WHERE ID = '572446008655478784';
|
||
-- 修改人脸识别结果和人脸识别相似度为必传
|
||
UPDATE `rec_loan`.`prd_tree` SET `label` = '人脸识别结果', `code` = 'faceRecoResult', `pid` = '572358774052880384', `is_empty` = '0', `mix_length` = NULL, `max_length` = '10', `key_value` = 'GLB_TRUE_FALSE', `create_user` = '007001', `create_org` = '007', `create_time` = '2021-12-24 10:45:38', `create_date` = '2037-05-13', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-04-14 15:33:01', `update_date` = '2040-12-15', `cur_vers` = 1, `prd_code` = 'P22071001', `regex` = NULL WHERE `id` = 572372918386819072;
|
||
UPDATE `rec_loan`.`prd_tree` SET `label` = '人脸识别相似度', `code` = 'faceRecoDegree', `pid` = '572358774052880384', `is_empty` = '0', `mix_length` = NULL, `max_length` = '100', `key_value` = NULL, `create_user` = '007001', `create_org` = '007', `create_time` = '2021-12-24 10:46:51', `create_date` = '2037-05-13', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-04-14 15:32:52', `update_date` = '2040-12-15', `cur_vers` = 1, `prd_code` = 'P22071001', `regex` = NULL WHERE `id` = 572373225942548480;
|
||
-- 还款试算和还款接口 还款类型限定为 提前全部结清，指定逾期期数还款，代偿结清
|
||
UPDATE `rec_loan`.`prd_tree` SET `label` = '还款类型', `code` = 'rpyType', `pid` = '571716705814839296', `is_empty` = '0', `mix_length` = NULL, `max_length` = NULL, `key_value` = 'XDL_RPY_TYPE_REPAY_INFO', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2021-12-22 15:20:53', `create_date` = '2037-05-11', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-04-28 17:12:10', `update_date` = '2041-08-10', `cur_vers` = 1, `prd_code` = 'P22071001', `regex` = NULL WHERE `id` = 571717409929428992;
|
||
UPDATE `rec_loan`.`prd_tree` SET `label` = '还款类型', `code` = 'rpyType', `pid` = '571722848050085888', `is_empty` = '0', `mix_length` = NULL, `max_length` = NULL, `key_value` = 'XDL_RPY_TYPE_REPAY_INFO', `create_user` = '007001', `create_org` = '007', `create_time` = '2021-12-22 15:43:19', `create_date` = '2037-05-11', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-04-28 17:14:13', `update_date` = '2041-08-10', `cur_vers` = 1, `prd_code` = 'P22071001', `regex` = NULL WHERE `id` = 571723056142090240;
|
||
|
||
-- 于新大陆产品配置与合同关联 产品编号为P22071001
|
||
INSERT INTO `rec_loan`.`prd_agr_tmpl_ref`(`id`, `prd_code`, `tmpl_code`, `bank_code`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `cur_vers`) VALUES (605120770548432896, 'P22071001', 'XDLZHXXSQS', '007', '007001', '007', '2023-05-19', '2022-03-24 19:33:54', NULL, NULL, NULL, NULL, 1);
|
||
|
||
-- 影像方案管理-文件类型配置增加综合信息授权书F00107
|
||
INSERT INTO `rec_loan`.`bam_file_type`(`id`, `file_type`, `type_name`, `bank_code`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `cur_vers`) VALUES (602632044404539392, 'F00107', '综合信息授权书', '007', '007001', '007', '2039-03-17', '2022-03-17 22:44:36', NULL, NULL, NULL, NULL, 1);
|
||
|
||
-- 影像方案管理-影像分组管理 新大陆授信申请影像详情增加综合信息授权书F00107
|
||
INSERT INTO `rec_loan`.`bam_file_grp_detail`(`id`, `grp_code`, `file_type`, `chk_flag`, `ord_num`, `remark`, `bank_code`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `cur_vers`) VALUES (605134236164292608, 'XDLSXSQYX', 'F00107', '0', 7, NULL, '007', '007001', '007', '2023-05-19', '2022-03-24 20:27:25', NULL, NULL, NULL, NULL, 1);
|
||
|
||
-- 影像平台根节点映射子节点增加综合信息授权节点
|
||
INSERT INTO `rec_loan`.`sys_option`(`id`, `option_val`, `option_txt`, `option_ord`, `option_desc`, `select_id`, `create_user`, `create_org`, `create_time`, `create_date`, `update_user`, `update_org`, `update_time`, `update_date`, `cur_vers`) VALUES ('20608251604038057984', 'XDLSXSQYX:F00107', 'LSXDSXYX0108', 6, '授信申请综合信息授权书', '20563678510263042048', '007001', '007', '2022-04-02 10:54:43', '2040-07-28', '007001', '007', '2022-04-06 17:55:56', '2040-08-11', 1);
|
||
|
||
-- 授信处理组件增加综合信息授权合同签署节点 这个要注意顺序！是覆盖性质的，如果两个修改sql一起执行，只会留下一个(节点是以json形式保存到这条记录里的)
|
||
UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'ONLINE000001', `tran_name` = '授信处理', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = NULL, `retry_space` = NULL, `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2021-11-05', `create_time` = '2021-11-08 14:33:25', `update_user` = '007001', `update_org` = '007', `update_date` = '2023-05-19', `update_time` = '2022-03-24 19:58:45', `cur_vers` = 21, `json_res` = '{\"lines\":[{\"target\":\"1636353319876\",\"source\":\"1636353289980\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1636353347788\",\"source\":\"1636353319876\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1640091917721\",\"source\":\"1640087001489\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1641622201715\",\"source\":\"1640091917721\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1641622204168\",\"source\":\"1641622201715\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1640006542469\",\"source\":\"1648123666621\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1636353289980\",\"source\":\"1640006542469\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1648123666621\",\"source\":\"1641622204168\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1636353289980,\"nodeName\":\"授信反欺诈复审\",\"left\":\"557px\",\"top\":\"106px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditAntiFraudFinalService\"},{\"id\":1636353319876,\"nodeName\":\"授信保存额度\",\"left\":\"719px\",\"top\":\"106px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditLmtSaveService\"},{\"id\":1636353347788,\"nodeName\":\"结束节点\",\"left\":\"721px\",\"top\":\"204px\",\"type\":\"end\",\"code\":\"\"},{\"id\":1640006542469,\"nodeName\":\"授信征信报告申请\",\"left\":\"370px\",\"top\":\"106px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditApplyReportService\"},{\"id\":1640087001489,\"nodeName\":\"开始\",\"left\":\"20px\",\"top\":\"106px\",\"type\":\"start\",\"code\":\"creditAuthAgreeSignService\"},{\"id\":1640091917721,\"nodeName\":\"征信授权书签署\",\"left\":\"190px\",\"top\":\"106px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditAuthAgreeSignService\"},{\"id\":1641622201715,\"nodeName\":\"第三方数据授权书签署\",\"left\":\"182px\",\"top\":\"200px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditDsfDataAuthSignService\"},{\"id\":1641622204168,\"nodeName\":\"人脸处理授权书签署\",\"left\":\"179px\",\"top\":\"290px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditCusFaceAuthSignService\"},{\"id\":1648123666621,\"nodeName\":\"综合信息授权书签署\",\"left\":\"177px\",\"top\":\"379px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"creditComplexAuthSignService\"}]}', `validate_res` = NULL, `business_open_date` = NULL, `business_close_date` = NULL, `retry` = NULL WHERE `id` = 555760399664807936;
|
||
-- 用信申请组件增加二类户还款账户信息查询节点
|
||
UPDATE `rec_loan`.`biz_tran_config` SET `tran_code` = 'TRAN000010', `tran_name` = '用信申请', `tran_sts` = '1', `tran_lock` = '1', `rec_save_flag` = '1', `retry_times` = 0, `retry_space` = 0, `bank_code` = '007', `create_user` = '007001', `create_org` = '007', `create_date` = '2021-11-05', `create_time` = '2021-11-03 20:53:14', `update_user` = '007001', `update_org` = '007', `update_date` = '2037-12-06', `update_time` = '2022-01-04 20:01:38', `cur_vers` = 18, `json_res` = '{\"lines\":[{\"target\":\"1636643963556\",\"source\":\"1636643945692\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1636639610351\",\"source\":\"1637058797858\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1639062393342\",\"source\":\"1639062240606\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1635944845182\",\"source\":\"1635944807616\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1637058797858\",\"source\":\"1635944845182\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1639062240606\",\"source\":\"1635944805654\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1640006455336\",\"source\":\"1636639610351\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1636643945692\",\"source\":\"1640006455336\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1648371328758\",\"source\":\"1639062393342\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1635944807616\",\"source\":\"1648371328758\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1635944805654,\"nodeName\":\"开始\",\"left\":\"24px\",\"top\":\"86px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1635944807616,\"nodeName\":\"用信申请信息保存\",\"left\":\"707px\",\"top\":\"82px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditAppSaveService\"},{\"id\":1635944845182,\"nodeName\":\"用信申请产品校验\",\"left\":\"706px\",\"top\":\"176px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditAppCheckService\"},{\"id\":1636639610351,\"nodeName\":\"支用申请参数校验\",\"left\":\"530px\",\"top\":\"264px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"disburseAppCheckService\"},{\"id\":1636643945692,\"nodeName\":\"发起流程\",\"left\":\"181px\",\"top\":\"256px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"publishFlowService\"},{\"id\":1636643963556,\"nodeName\":\"结束节点\",\"left\":\"19px\",\"top\":\"252px\",\"type\":\"end\",\"code\":\"\"},{\"id\":1637058797858,\"nodeName\":\"用信额度校验\",\"left\":\"717px\",\"top\":\"269px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditLinesCheckService\"},{\"id\":1639062240606,\"nodeName\":\"初始化用信申请\",\"left\":\"179px\",\"top\":\"86px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditAppInitService\"},{\"id\":1639062393342,\"nodeName\":\"用信申请入参检查\",\"left\":\"343px\",\"top\":\"86px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditInputCheckService\"},{\"id\":1640006455336,\"nodeName\":\"用信申请反欺诈\",\"left\":\"352px\",\"top\":\"262px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditAntiFraudService\"},{\"id\":1648371328758,\"nodeName\":\"二类户还款账户信息查询\",\"left\":\"526px\",\"top\":\"87px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"useCreditAppSaveLinkedAcctService\"}]}', `validate_res` = NULL, `business_open_date` = NULL, `business_close_date` = NULL, `retry` = NULL WHERE `id` = 554044044053839872;
|
||
-- 增加二类户转账组件
|
||
INSERT INTO `rec_loan`.`biz_tran_config`(`id`, `tran_code`, `tran_name`, `tran_sts`, `tran_lock`, `rec_save_flag`, `retry_times`, `retry_space`, `wait_end`, `bank_code`, `create_user`, `create_org`, `create_date`, `create_time`, `update_user`, `update_org`, `update_date`, `update_time`, `cur_vers`, `json_res`, `validate_res`, `business_open_date`, `business_close_date`, `retry`) VALUES (611715876357406720, 'ONLINE000123', '二类户转账', '1', '1', '1', 3, 5, '0', '007', '007001', '007', '2040-11-10', '2022-04-12 00:20:30', '007001', '007', '2040-11-13', '2022-04-12 15:02:29', 2, '{\"lines\":[{\"target\":\"1649695486106\",\"source\":\"1649695484049\",\"text\":\"\",\"condition\":\"\"},{\"target\":\"1649695487521\",\"source\":\"1649695486106\",\"text\":\"\",\"condition\":\"\"}],\"nodes\":[{\"id\":1649695484049,\"nodeName\":\"开始\",\"left\":\"27px\",\"top\":\"84px\",\"type\":\"start\",\"code\":\"\"},{\"id\":1649695486106,\"nodeName\":\"二类户转一类户\",\"left\":\"246px\",\"top\":\"82px\",\"type\":\"tranConfigScheduleExecutor\",\"code\":\"disbursePayoutLinkedAcctService\"},{\"id\":1649695487521,\"nodeName\":\"结束节点\",\"left\":\"506px\",\"top\":\"92px\",\"type\":\"end\",\"code\":\"\"}]}', NULL, NULL, NULL, '0');
|
||
|
||
-- 用信申请表 rate_type 备注 从 定价基准(0:1-6个月含6个月,1:1年以内含一年,2:1-3年含3年,3:3-5年含5年,4:5年以上) 改为 利率定价方式 固定利率 0 浮动利率 1
|
||
ALTER TABLE `rec_loan`.`pay_credit_app`
|
||
MODIFY COLUMN `rate_type` varchar(2) NULL DEFAULT NULL COMMENT '利率定价方式 固定利率 0 浮动利率 1' AFTER `loan_rate_mode`;
|