194 lines
48 KiB
SQL
194 lines
48 KiB
SQL
-- ----------------------------
|
|
-- Records of prd_tree
|
|
-- ----------------------------
|
|
INSERT INTO `prd_tree` VALUES ('1', '参数配置', 'code', 'ROOT', '1', '1', '1', '213', '1', '1', '2021-12-17 11:26:44', '2021-12-29', '00000000', '999999', '2021-12-18 11:51:10', '2021-12-18', 1, NULL, NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571716705814839296', '还款申请参数验证', 'REPAY', '1', NULL, NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:18:05', '2037-05-11', '00000000', '999999', '2021-12-22 15:27:19', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571716884467023872', '合作平台', 'coopNo', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:18:47', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571717243826601984', '借据号', 'duebillNo', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:20:13', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571717409929428992', '还款类型', 'rpyType', '571716705814839296', '0', NULL, NULL, 'RPY_TYPE_REPAY_INFO', '00000000', '999999', '2021-12-22 15:20:53', '2037-05-11', '00000000', '999999', '2021-12-22 15:27:04', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571717662640439296', '指定还款金额', 'receiptPriAmt', '571716705814839296', '1', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:21:53', '2037-05-11', '007001', '007', '2022-01-05 14:14:12', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571717809537548288', '还款期数', 'repaymentPeriod', '571716705814839296', '1', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:22:28', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571717917272440832', '还款日期', 'repayDate', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:22:53', '2037-05-11', '007001', '007', '2021-12-28 18:18:07', '2037-07-22', 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('571718047149064192', '应收本金', 'repayPricipal', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:23:24', '2037-05-11', '007001', '007', '2022-01-05 14:13:27', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571718162999934976', '应收利息', 'repayInterest', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:23:52', '2037-05-11', '007001', '007', '2022-01-05 14:13:16', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571718275994484736', '应收罚息', 'tototOntOnt', '571716705814839296', '0', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:24:19', '2037-05-11', '007001', '007', '2022-01-05 14:12:59', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571718467992944640', '备注', 'remark', '571716705814839296', '1', NULL, NULL, NULL, '00000000', '999999', '2021-12-22 15:25:05', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719092189265920', '用信参数验证', 'payout', '1', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-22 15:27:34', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719460793090048', '合作平台', 'coopNo', '571719092189265920', '0', NULL, '32', NULL, '007001', '007', '2021-12-22 15:29:01', '2037-05-11', '007001', '007', '2021-12-22 16:50:56', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719526534610944', '产品代码', 'prdCode', '571719092189265920', '0', NULL, '32', NULL, '007001', '007', '2021-12-22 15:29:17', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719601000284160', '第三方申请流水号', 'extAppNo', '571719092189265920', '0', NULL, '32', NULL, '007001', '007', '2021-12-22 15:29:35', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719667131875328', '额度编号', 'lmtNo', '571719092189265920', '0', NULL, '40', NULL, '007001', '007', '2021-12-22 15:29:51', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719746249031680', '支用币种代码', 'ccy', '571719092189265920', '0', NULL, '3', 'GLB_CCY', '007001', '007', '2021-12-22 15:30:10', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719821184466944', '支用金额', 'payAmt', '571719092189265920', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:30:27', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719927409410048', '支用期限类型', 'loanTermUnit', '571719092189265920', '0', NULL, '10', 'GLB_ALL_TERM_UNIT', '007001', '007', '2021-12-22 15:30:53', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571719994207895552', '支用期限', 'loanTerm', '571719092189265920', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:31:09', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571720075858411520', '担保方式', 'bondGrtType', '571719092189265920', '0', NULL, '10', 'BIZ_GRT_TYPE', '007001', '007', '2021-12-22 15:31:28', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571720149363589120', '还款方式代码', 'repayMode', '571719092189265920', '0', NULL, '4', 'REPAYMENT_METHOD', '007001', '007', '2021-12-22 15:31:46', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571720243815120896', '放款方式', 'payMode', '571719092189265920', '0', NULL, '10', 'BIZ_PAY_MODE', '007001', '007', '2021-12-22 15:32:08', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571720332868583424', '贷款用途', 'loanUse', '571719092189265920', '0', NULL, '10', 'BIZ_LOAN_USE_TYPE', '007001', '007', '2021-12-22 15:32:29', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571722848050085888', '还款试算参数验证', 'REPAY_TRIAL', '1', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-22 15:42:29', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571722966539173888', '合作平台', 'coopNo', '571722848050085888', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:42:57', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571723056142090240', '还款类型', 'rpyType', '571722848050085888', '0', NULL, NULL, 'RPY_TYPE_REPAY_INFO', '007001', '007', '2021-12-22 15:43:19', '2037-05-11', '007001', '007', '2021-12-22 15:46:13', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571723161574309888', '借据号', 'duebillNo', '571722848050085888', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:43:44', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571723272824029184', '指定还款金额', 'receiptPriAmt', '571722848050085888', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:44:10', '2037-05-11', '007001', '007', '2022-01-05 14:12:00', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571723471394963456', '还款期数', 'repaymentPeriod', '571722848050085888', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:44:58', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571723597387661312', '还款日期', 'repayDate', '571722848050085888', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:45:28', '2037-05-11', '007001', '007', '2021-12-28 18:19:13', '2037-07-22', 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('571724862230364160', '还款计划试算', 'REPAYPLAN_TRIAL', '1', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-22 15:50:29', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571725039007694848', '合作平台', 'coopNo', '571724862230364160', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:51:11', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571725252753620992', '产品编码', 'prdCode', '571724862230364160', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:52:02', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571725419879858176', '放款利率', 'loanRate', '571724862230364160', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:52:42', '2037-05-11', '007001', '007', '2022-01-05 17:40:14', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,6})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571725602881536000', '放款金额', 'loanAmt', '571724862230364160', '0', '', '', NULL, '007001', '007', '2021-12-22 15:53:26', '2037-05-11', '007001', '007', '2022-01-05 11:26:10', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571725784423596032', '贷款起息日期', 'startDate', '571724862230364160', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:54:09', '2037-05-11', '007001', '007', '2021-12-28 18:19:48', '2037-07-22', 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('571726291359760384', '支用期限类型', 'loanTermUnit', '571724862230364160', '0', NULL, NULL, 'GLB_ALL_TERM_UNIT', '007001', '007', '2021-12-22 15:56:10', '2037-05-11', '007001', '007', '2021-12-22 16:05:05', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571726432808468480', '支用期限', 'loanTerm', '571724862230364160', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 15:56:44', '2037-05-11', '007001', '007', '2022-01-05 11:41:03', '2037-12-07', 1, 'P22071001', '^[+]?[0-9]?$');
|
|
INSERT INTO `prd_tree` VALUES ('571726934866657280', '还款方式', 'repayMode', '571724862230364160', '0', NULL, NULL, 'REPAYMENT_METHOD', '007001', '007', '2021-12-22 15:58:43', '2037-05-11', '007001', '007', '2021-12-22 16:06:58', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571727321925419008', '还款频率', 'repayFrequency', '571724862230364160', '0', NULL, NULL, NULL, '007001', '007', '2021-12-22 16:00:16', '2037-05-11', '007001', '007', '2022-01-05 11:41:33', '2037-12-07', 1, 'P22071001', '^[+]?[0-9]?$');
|
|
INSERT INTO `prd_tree` VALUES ('571727447301554176', '还款频率单位', 'repayFrequencyUnit', '571724862230364160', '0', NULL, NULL, 'INTERVAL_UNIT', '007001', '007', '2021-12-22 16:00:46', '2037-05-11', '00000000', '999999', '2021-12-25 18:02:46', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571727564066783232', '免息天数', 'feeDays', '571724862230364160', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 16:01:13', '2037-05-11', '007001', '007', '2022-01-05 11:35:24', '2037-12-07', 1, 'P22071001', '^[+]?[0-9]?$');
|
|
INSERT INTO `prd_tree` VALUES ('571727839477366784', '费用列表', 'chargeList', '571724862230364160', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 16:02:19', '2037-05-11', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571727936084770816', '费用费率', 'chargeRate', '571727839477366784', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 16:02:42', '2037-05-11', '007001', '007', '2022-01-05 11:27:26', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571728139982471168', '费用类型', 'chargeType', '571727839477366784', '1', NULL, NULL, 'CHARGE_TYPE', '007001', '007', '2021-12-22 16:03:31', '2037-05-11', '007001', '007', '2022-01-05 11:43:44', '2037-12-07', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('571728244080902144', '金额', 'chargeFixAmt', '571727839477366784', '1', NULL, NULL, NULL, '007001', '007', '2021-12-22 16:03:56', '2037-05-11', '007001', '007', '2022-01-05 11:26:59', '2037-12-07', 1, 'P22071001', '^[+]?([0-9]+(.[0-9]{1,2})?)$');
|
|
INSERT INTO `prd_tree` VALUES ('571728343431380992', '手续费收取方式', 'chargeMode', '571727839477366784', '1', NULL, NULL, 'CHARGE_MODE', '007001', '007', '2021-12-22 16:04:19', '2037-05-11', '007001', '007', '2021-12-22 16:12:34', '2037-05-11', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572194975131893760', '授信参数校验', 'credit', '1', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-23 22:58:33', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195117658537984', '合作平台', 'coopNo', '572194975131893760', '0', NULL, '30', NULL, '007001', '007', '2021-12-23 22:59:07', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195172259987456', '授信申请流水号', 'extAppNo', '572194975131893760', '0', NULL, '32', NULL, '007001', '007', '2021-12-23 22:59:20', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195230871191552', '客户信息', 'customerInfo', '572194975131893760', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 22:59:34', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195350413049856', '客户编号 ', 'custNo', '572195230871191552', '0', NULL, '32', NULL, '007001', '007', '2021-12-23 23:00:02', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195419040251904', '客户中文名称', 'custName', '572195230871191552', '0', NULL, '30', NULL, '007001', '007', '2021-12-23 23:00:19', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195512191549440', '证件类型代码', 'certType', '572195230871191552', '0', NULL, '200', 'CUS_IND_CERT_TYPE', '007001', '007', '2021-12-23 23:00:41', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195741460594688', '证件号码', 'certNo', '572195230871191552', '0', NULL, '60', NULL, '007001', '007', '2021-12-23 23:01:36', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195845785518080', '客户类型代码', 'custType', '572195230871191552', '0', NULL, '60', 'CUS_CUST_TYPE', '007001', '007', '2021-12-23 23:02:01', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572195973422383104', '国籍代码', 'custCtry', '572195230871191552', '0', NULL, '3', 'GLB_CTRY', '007001', '007', '2021-12-23 23:02:31', '2037-05-13', '007001', '007', '2021-12-25 11:59:30', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572196031945506816', '个人客户基本信息', 'privateCustInfo', '572195230871191552', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 23:02:45', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572196128011845632', '性别代码', 'gender', '572196031945506816', '0', NULL, '1', 'GLB_GENDER', '007001', '007', '2021-12-23 23:03:08', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572196193518485504', '出生日期', 'birthDate', '572196031945506816', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 23:03:23', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('572196436020559872', '细分客户类型代码', 'custSubType', '572196031945506816', '0', NULL, '3', 'CUS_IND_CUS_SUB_TYPE', '007001', '007', '2021-12-23 23:04:21', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197225313075200', '是否农户标志', 'farmerFlag', '572196031945506816', '0', NULL, '1', 'CUS_TRUE_FALSE', '007001', '007', '2021-12-23 23:07:29', '2037-05-13', '007001', '007', '2021-12-24 10:04:16', '2037-05-13', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197328203546624', '是否为长期证件', 'certLongFlag', '572196031945506816', NULL, NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-23 23:07:54', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197436143960064', '移动电话号码', 'mobile', '572196031945506816', '0', NULL, '30', NULL, '007001', '007', '2021-12-23 23:08:20', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572197540598906880', '民族代码', 'ethnic', '572196031945506816', '0', NULL, '2', 'CUS_IND_ETHNIC', '007001', '007', '2021-12-23 23:08:45', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197666147008512', '居住地址', 'residAddr', '572196031945506816', '0', NULL, '300', NULL, '007001', '007', '2021-12-23 23:09:15', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197730856730624', '居住地邮政编码', 'residZip', '572196031945506816', NULL, NULL, '30', NULL, '007001', '007', '2021-12-23 23:09:30', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^[1-9]\\d{5}$');
|
|
INSERT INTO `prd_tree` VALUES ('572197852931948544', '居住地行政区域代码', 'residAdmin', '572196031945506816', '0', NULL, '6', 'GLB_ADM_DIV', '007001', '007', '2021-12-23 23:09:59', '2037-05-13', '007001', '007', '2021-12-25 14:51:23', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572197963485413376', '通讯地址', 'postAddr', '572196031945506816', '0', NULL, '300', NULL, '007001', '007', '2021-12-23 23:10:25', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198036722155520', '通讯地址邮政编码', 'postZip', '572196031945506816', NULL, NULL, '30', NULL, '007001', '007', '2021-12-23 23:10:43', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^[1-9]\\d{5}$');
|
|
INSERT INTO `prd_tree` VALUES ('572198124546686976', '通讯地行政区域代码', 'postAdmin', '572196031945506816', '0', NULL, '6', 'GLB_ADM_DIV', '007001', '007', '2021-12-23 23:11:04', '2037-05-13', '007001', '007', '2021-12-25 14:51:40', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198184013529088', '户籍地址', 'regAddr', '572196031945506816', NULL, NULL, '300', NULL, '007001', '007', '2021-12-23 23:11:18', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198294776709120', '户籍地行政区域代码', 'regAdmin', '572196031945506816', NULL, NULL, '6', 'GLB_ADM_DIV', '007001', '007', '2021-12-23 23:11:44', '2037-05-13', '007001', '007', '2021-12-25 14:51:57', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198405254676480', '婚姻状况代码', 'maritalSts', '572196031945506816', '0', NULL, '2', 'CUS_MARITAL_STS', '007001', '007', '2021-12-23 23:12:11', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198529183776768', '最高学历代码', 'education', '572196031945506816', '0', NULL, '5', 'CUS_EDU', '007001', '007', '2021-12-23 23:12:40', '2037-05-13', '007001', '007', '2021-12-23 23:13:44', '2037-05-13', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198753881030656', '最高学位代码', 'degree', '572196031945506816', NULL, NULL, '3', 'CUS_DEGREE', '007001', '007', '2021-12-23 23:13:34', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572198878397333504', '证件生效日期', 'certBeginDate', '572196031945506816', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 23:14:04', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('572198937851592704', '证件失效日期', 'certEndDate', '572196031945506816', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-23 23:14:18', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^((?!0000)[0-9]{4})-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])$');
|
|
INSERT INTO `prd_tree` VALUES ('572199001059753984', '证件签发机关名称', 'certOrgName', '572196031945506816', '0', NULL, '200', NULL, '007001', '007', '2021-12-23 23:14:33', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199059796787200', '证件签发机关行政区域代码', 'certOrgAdmin', '572196031945506816', NULL, NULL, '6', 'GLB_ADM_DIV', '007001', '007', '2021-12-23 23:14:47', '2037-05-13', '007001', '007', '2021-12-25 14:52:09', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199171411410944', '居住状况代码', 'residSts', '572196031945506816', '0', NULL, '3', 'CUS_RESID_STS', '007001', '007', '2021-12-23 23:15:13', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199259063975936', '家庭电话号码', 'homePhone', '572196031945506816', NULL, NULL, '30', NULL, '007001', '007', '2021-12-23 23:15:34', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572199375766290432', '从业状况代码', 'empSts', '572196031945506816', '0', NULL, '2', 'CUS_EMP_STS', '007001', '007', '2021-12-23 23:16:02', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199485602529280', '个人月收入', 'annIncom', '572196031945506816', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 23:16:28', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199538475925504', '电子邮箱地址', 'email', '572196031945506816', NULL, NULL, '300', NULL, '007001', '007', '2021-12-23 23:16:41', '2037-05-13', '007001', '007', '2022-01-04 21:25:31', '2037-12-06', 1, 'P22071001', '^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+(\\.[a-zA-Z0-9_-]+)+$');
|
|
INSERT INTO `prd_tree` VALUES ('572199615542067200', '家庭月收入', 'famIncom', '572196031945506816', '0', NULL, NULL, NULL, '007001', '007', '2021-12-23 23:16:59', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572199673251495936', '家庭负债', 'famLiabilities', '572196031945506816', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-23 23:17:13', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572358774052880384', '申请信息', 'applyInfo', '572194975131893760', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 09:49:26', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572358879195693056', '产品编号', 'prdCode', '572358774052880384', '0', NULL, '12', NULL, '007001', '007', '2021-12-24 09:49:51', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359153738055680', '贷款形式代码', 'occurType', '572358774052880384', '0', NULL, '1', 'LMT_OCCUR_TYPE', '007001', '007', '2021-12-24 09:50:56', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359241503866880', '授信币种代码', 'ccy', '572358774052880384', '0', NULL, '3', 'GLB_CCY', '007001', '007', '2021-12-24 09:51:17', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359371321769984', '主担保方式代码', 'grtType', '572358774052880384', '0', NULL, '3', 'BIZ_GRT_TYPE', '007001', '007', '2021-12-24 09:51:48', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359554864513024', '申请金额', 'appAmt', '572358774052880384', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 09:52:32', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359716940808192', '贷款用途类型代码', 'loanUseType', '572358774052880384', '0', NULL, '3', 'BIZ_LOAN_USE_TYPE', '007001', '007', '2021-12-24 09:53:10', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572359949510770688', '贷款用途', 'loanUse', '572358774052880384', '', NULL, '1000', NULL, '007001', '007', '2021-12-24 09:54:06', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572360023544430592', '备注', 'remark', '572358774052880384', NULL, NULL, '100', NULL, '007001', '007', '2021-12-24 09:54:24', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572360115139641344', '开户日期', 'openDate', '572358774052880384', NULL, NULL, '50', NULL, '007001', '007', '2021-12-24 09:54:45', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572362273796915200', '开户标识', 'createUserSign', '572358774052880384', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 10:03:20', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363213761413120', '开户失败原因', 'createUserFailReason', '572358774052880384', '', NULL, '200', '', '007001', '007', '2021-12-24 10:07:04', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363297437777920', '联网核查状态', 'onlineChkSign', '572358774052880384', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 10:07:24', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363378870190080', '联网核查失败原因', 'onlineChkFailReason', '572358774052880384', '', NULL, '200', NULL, '007001', '007', '2021-12-24 10:07:44', '2037-05-13', '007001', '007', '2021-12-24 10:52:48', '2037-05-13', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363476270317568', '银行卡四要素鉴权状态', 'cardAuthSign', '572358774052880384', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 10:08:07', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363571304857600', '银行卡四要素鉴权失败原因', 'cardAuthFailReason', '572358774052880384', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 10:08:29', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572363628120899584', '银行卡-卡号', 'bankCardNo', '572358774052880384', '0', NULL, '30', NULL, '007001', '007', '2021-12-24 10:08:43', '2037-05-13', '007001', '007', '2022-01-04 21:09:46', '2037-12-06', 1, 'P22071001', '^([1-9]{1})(\\d{14}|\\d{18})$');
|
|
INSERT INTO `prd_tree` VALUES ('572363888218079232', '银行卡-预留手机号', 'bankPhone', '572358774052880384', '0', NULL, '11', NULL, '007001', '007', '2021-12-24 10:09:45', '2037-05-13', '007001', '007', '2022-01-04 21:12:05', '2037-12-06', 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572364756426424320', '放款账户开户行行号', 'loanAccBank', '572358774052880384', NULL, NULL, '32', NULL, '007001', '007', '2021-12-24 10:13:12', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572364844217401344', '放款账户开户行名称', 'loanAccBankName', '572358774052880384', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 10:13:33', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372346606714880', '放款账户公私标志', 'loanAcctCls', '572358774052880384', '', NULL, '2', 'GLB_ACC_MARK', '007001', '007', '2021-12-24 10:43:22', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372444594044928', '还款账户开户行行号', 'repayAccBank', '572358774052880384', NULL, NULL, '32', NULL, '007001', '007', '2021-12-24 10:43:45', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372502659989504', '还款卡号', 'repayCardNo', '572358774052880384', NULL, NULL, '32', NULL, '007001', '007', '2021-12-24 10:43:59', '2037-05-13', '007001', '007', '2022-01-04 21:10:01', '2037-12-06', 1, 'P22071001', '^([1-9]{1})(\\d{14}|\\d{18})$');
|
|
INSERT INTO `prd_tree` VALUES ('572372557819281408', '还款账户开户行名称', 'repayAccBankName', '572358774052880384', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 10:44:12', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372612643028992', '还款账户户名', 'repayAccName', '572358774052880384', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 10:44:25', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372704078856192', '还款账户公私标志', 'repayAcctCls', '572358774052880384', NULL, NULL, '2', 'GLB_ACC_MARK', '007001', '007', '2021-12-24 10:44:47', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572372777185574912', '手机号码', 'repayAccBankPhone', '572358774052880384', NULL, NULL, '11', NULL, '007001', '007', '2021-12-24 10:45:04', '2037-05-13', '007001', '007', '2022-01-04 21:12:16', '2037-12-06', 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572372918386819072', '人脸识别结果', 'faceRecoResult', '572358774052880384', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 10:45:38', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572373225942548480', '人脸识别相似度', 'faceRecoDegree', '572358774052880384', NULL, NULL, '100', NULL, '007001', '007', '2021-12-24 10:46:51', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572373413864144896', '影像资料下载路径', 'imageFile', '572358774052880384', '0', NULL, '2000', NULL, '007001', '007', '2021-12-24 10:47:36', '2037-05-13', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572375044894752768', '是否已签订征信授权', 'isCreditLetter', '572358774052880384', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 10:54:05', '2037-05-13', '007001', '007', '2021-12-24 15:24:21', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572442954904371200', '扩展信息', 'extendedInfo', '572194975131893760', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 15:23:56', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572445918519885824', '活体识别是否通过', 'livingRecognition', '572442954904371200', '0', NULL, '1', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 15:35:43', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572446008655478784', '活体识别分', 'livingRecognitionCore', '572442954904371200', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 15:36:04', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572446106479230976', '个人客户工作信息', 'custWorkInfo', '572442954904371200', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 15:36:27', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572446194404425728', '工作单位名称', 'comName', '572446106479230976', '0', NULL, '200', NULL, '007001', '007', '2021-12-24 15:36:48', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572458182463455232', '单位性质', 'comNature', '572446106479230976', '0', NULL, '3', 'ECIF_CODE_COMPANY_TYPE', '007001', '007', '2021-12-24 16:24:26', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572458475829854208', '单位所属行业类型代码', 'industry', '572446106479230976', NULL, NULL, '5', 'GLB_INDUS_CLS', '007001', '007', '2021-12-24 16:25:36', '2037-06-10', '007001', '007', '2021-12-25 14:56:42', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572458595581427712', '职业代码', 'occupation', '572446106479230976', '0', NULL, '5', 'CUS_OCCUPATION', '007001', '007', '2021-12-24 16:26:05', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572458911131500544', '职务级别代码', 'duty', '572446106479230976', NULL, NULL, '1', 'CUS_COM_DUTY', '007001', '007', '2021-12-24 16:27:20', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478124021776384', '职称代码', 'techTitle', '572446106479230976', '0', NULL, '1', 'CUS_TECH_TITLE', '007001', '007', '2021-12-24 17:43:41', '2037-06-10', '007001', '007', '2021-12-24 18:48:36', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478209874984960', '单位电话号码', 'officePhone', '572446106479230976', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 17:44:01', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478330763214848', '单位详细地址', 'comAddr', '572446106479230976', '0', NULL, '300', NULL, '007001', '007', '2021-12-24 17:44:30', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478417249763328', '所在地邮编', 'comZip', '572446106479230976', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 17:44:51', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478503677591552', '所在地行政区域代码', 'comAdmin', '572446106479230976', '0', NULL, '6', 'GLB_ADM_DIV', '007001', '007', '2021-12-24 17:45:11', '2037-06-10', '007001', '007', '2021-12-25 14:57:47', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478589178478592', '联系地址信息', 'addrInfoList', '572442954904371200', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 17:45:32', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572478676008960000', '地址类型代码', 'typeCode', '572478589178478592', '0', NULL, '20', 'ADDRESS_TYPE', '007001', '007', '2021-12-24 17:45:53', '2037-06-10', '007001', '007', '2021-12-24 17:51:40', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480231462404096', '国家/地区', 'country', '572478589178478592', '0', NULL, '6', 'GLB_CTRY', '007001', '007', '2021-12-24 17:52:03', '2037-06-10', '007001', '007', '2021-12-25 14:59:13', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480306318147584', '行政区划 省市区', 'busiAddrAdmRoute', '572478589178478592', '0', NULL, '50', 'GLB_ADM_DIV', '007001', '007', '2021-12-24 17:52:21', '2037-06-10', '007001', '007', '2021-12-25 14:58:43', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480386811035648', '详细地址', 'addr', '572478589178478592', '0', NULL, '200', NULL, '007001', '007', '2021-12-24 17:52:40', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480490490036224', '手机号码或者电话号码', 'mobile', '572478589178478592', '0', NULL, '20', NULL, '007001', '007', '2021-12-24 17:53:05', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572480552733507584', '客户中心ID', 'centerId', '572478589178478592', '0', NULL, '20', NULL, '007001', '007', '2021-12-24 17:53:20', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480664067112960', '个人社会关系信息', 'custSocialInfo', '572442954904371200', '', NULL, NULL, NULL, '007001', '007', '2021-12-24 17:53:46', '2037-06-10', '007001', '007', '2021-12-24 17:54:06', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572480987842215936', '关系类型代码', 'relType', '572480664067112960', '', NULL, '5', 'CUS_IND_SOC_REL_TYPE', '007001', '007', '2021-12-24 17:55:04', '2037-06-10', '007001', '007', '2021-12-24 17:55:51', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572481133430702080', '关联人中文名称', 'relCustName', '572480664067112960', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 17:55:38', '2037-06-10', '007001', '007', '2022-01-04 21:13:58', '2037-12-06', 1, 'P22071001', '^[\\u4e00-\\u9fa5]+$');
|
|
INSERT INTO `prd_tree` VALUES ('572481438457266176', '关联人证件类型代码', 'relCertType', '572480664067112960', NULL, NULL, '6', 'CUS_IND_CERT_TYPE', '007001', '007', '2021-12-24 17:56:51', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572481527485562880', '关联人证件号码', 'relCertNo', '572480664067112960', NULL, NULL, '60', NULL, '007001', '007', '2021-12-24 17:57:12', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572481629784637440', '关联人电话号码', 'relCustPhone', '572480664067112960', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 17:57:37', '2037-06-10', '007001', '007', '2022-01-04 21:14:26', '2037-12-06', 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('572481752648384512', '关联人工作单位名称', 'relCustComName', '572480664067112960', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 17:58:06', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572481827663511552', '关联人客户编号', 'relCustNo', '572480664067112960', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 17:58:24', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482044907487232', '客户中心ID', 'centerId', '572480664067112960', NULL, NULL, '20', NULL, '007001', '007', '2021-12-24 17:59:16', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482135332487168', '个人房产信息', 'custHouseInfo', '572442954904371200', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-24 17:59:37', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482319705702400', '产权类型', 'propertyType', '572482135332487168', NULL, NULL, '1', 'PROPERTY_TYPE', '007001', '007', '2021-12-24 18:00:21', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482427050524672', '房产证号', 'housePropertyId', '572482135332487168', NULL, NULL, '32', NULL, '007001', '007', '2021-12-24 18:00:47', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482563705143296', '是否共有', 'ownerByAll', '572482135332487168', NULL, NULL, '2', 'GLB_TRUE_FALSE', '007001', '007', '2021-12-24 18:01:19', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482643535331328', '房屋地址', 'houseAddr', '572482135332487168', NULL, NULL, '200', NULL, '007001', '007', '2021-12-24 18:01:38', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482731456331776', '个人车辆信息', 'custVehInfo', '572442954904371200', NULL, NULL, NULL, NULL, '007001', '007', '2021-12-24 18:01:59', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572482812989407232', '号牌号码', 'licenseNum', '572482731456331776', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 18:02:19', '2037-06-10', '007001', '007', '2022-01-04 21:15:32', '2037-12-06', 1, 'P22071001', '^([京津晋冀蒙辽吉黑沪苏浙皖闽赣鲁豫鄂湘粤桂琼渝川贵云藏陕甘青宁新][ABCDEFGHJKLMNPQRSTUVWXY][1-9DF][1-9ABCDEFGHJKLMNPQRSTUVWXYZ]\\d{3}[1-9DF]|[京津晋冀蒙辽吉黑沪苏浙皖闽赣鲁豫鄂湘粤桂琼渝川贵云藏陕甘青宁新][ABCDEFGHJKLMNPQRSTUVWXY][\\dABCDEFGHJKLNMxPQRSTUVWXYZ]{5})');
|
|
INSERT INTO `prd_tree` VALUES ('572482889392848896', '车辆类型', 'vehicleType', '572482731456331776', NULL, NULL, '30', 'VEHICLE_TYPE', '007001', '007', '2021-12-24 18:02:37', '2037-06-10', '007001', '007', '2021-12-24 18:02:50', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483006359404544', '所有人', 'owner', '572482731456331776', NULL, NULL, '30', NULL, '007001', '007', '2021-12-24 18:03:05', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483064974802944', '经营主体信息', 'cusBusinessEntity', '572442954904371200', '0', NULL, NULL, NULL, '007001', '007', '2021-12-24 18:03:19', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483186261491712', '企业编号', 'entCustNo', '572483064974802944', '', NULL, '30', NULL, '007001', '007', '2021-12-24 18:03:48', '2037-06-10', '007001', '007', '2021-12-24 18:46:06', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483382366175232', '企业中文名称', 'entCustName', '572483064974802944', '0', NULL, '100', NULL, '007001', '007', '2021-12-24 18:04:35', '2037-06-10', '007001', '007', '2022-01-05 15:57:35', '2037-12-07', 1, 'P22071001', '^[\\u4e00-\\u9fa5]+$');
|
|
INSERT INTO `prd_tree` VALUES ('572483464201240576', '企业证件类型', 'entCertType', '572483064974802944', NULL, NULL, '8', 'CUS_ENT_CERT_TYPE', '007001', '007', '2021-12-24 18:04:54', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483535093366784', '企业证件号码', 'entCertNo', '572483064974802944', NULL, NULL, '60', NULL, '007001', '007', '2021-12-24 18:05:11', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483625623224320', '统一社会信用代码', 'uniCrdtCode', '572483064974802944', '0', NULL, '60', NULL, '007001', '007', '2021-12-24 18:05:33', '2037-06-10', '007001', '007', '2022-01-04 21:16:38', '2037-12-06', 1, 'P22071001', '^([0-9A-HJ-NPQRTUWXY]{2}\\d{6}[0-9A-HJ-NPQRTUWXY]{10}|[1-9]\\d{14})$');
|
|
INSERT INTO `prd_tree` VALUES ('572483903734939648', '组织机构代码', 'orgCode', '572483064974802944', NULL, NULL, '60', NULL, '007001', '007', '2021-12-24 18:06:39', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572483973670764544', '工商注册号', 'corpBusiNo', '572483064974802944', NULL, NULL, '100', NULL, '007001', '007', '2021-12-24 18:06:56', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572484094940676096', '所属行业类型代码', 'industry', '572483064974802944', '0', NULL, '10', 'GLB_INDUS_CLS', '007001', '007', '2021-12-24 18:07:24', '2037-06-10', '007001', '007', '2021-12-25 15:01:05', '2037-06-10', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('572843149152485376', '产品专案类型', 'productType', '572442954904371200', '0', '0', '2', 'CRDT_PRODUCT_TYPE', '007001', '007', '2021-12-25 17:54:10', '2037-06-10', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573600941895319552', '扩展信息', 'extendedInfo', '571719092189265920', '0', NULL, NULL, NULL, '007001', '007', '2021-12-27 20:05:22', '2037-07-04', '007001', '007', '2021-12-27 20:05:32', '2037-07-04', 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573602563690070016', '贷款投向行业', 'direcIndust', '573600941895319552', '0', NULL, '11', 'GLB_INDUS_CLS', '007001', '007', '2021-12-27 20:11:48', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573602944356712448', '贷款投向地区', 'direcArea', '573600941895319552', '0', NULL, '12', 'GLB_ADM_DIV', '007001', '007', '2021-12-27 20:13:19', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573603449736790016', '还款周期类型', 'repayPrincipalUnit', '573600941895319552', '', NULL, '2', 'GLB_ALL_TERM_UNIT', '007001', '007', '2021-12-27 20:15:19', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573603603307036672', '受托支付开户行行号', 'entrustedPayBank', '573600941895319552', '', NULL, '32', '', '007001', '007', '2021-12-27 20:15:56', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573603717987696640', '受托支付开户行名', 'entrustedPayBankName', '573600941895319552', '', NULL, '32', '', '007001', '007', '2021-12-27 20:16:23', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573603800535793664', '受托支付账号', 'entrustedPayCarNo', '573600941895319552', NULL, NULL, '32', NULL, '007001', '007', '2021-12-27 20:16:43', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573603867757903872', '受托支付账户名', 'entrustedPayAccName', '573600941895319552', NULL, NULL, '200', NULL, '007001', '007', '2021-12-27 20:16:59', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604093902192640', '受托支付账户公私标志', 'entrustedPayAcctCls', '573600941895319552', NULL, NULL, '2', 'GLB_ACC_MARK', '007001', '007', '2021-12-27 20:17:53', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604300379389952', '放款账户开户行行号', 'loanAccBank', '571719092189265920', NULL, NULL, '32', NULL, '007001', '007', '2021-12-27 20:18:42', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604363528830976', '放款卡号', 'loanCardNo', '571719092189265920', NULL, NULL, '32', NULL, '007001', '007', '2021-12-27 20:18:57', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604418629402624', '放款账户开户行名称', 'loanAccBankName', '571719092189265920', NULL, NULL, '200', NULL, '007001', '007', '2021-12-27 20:19:10', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604478326931456', '放款账户户名', 'loanAccName', '571719092189265920', NULL, NULL, '200', NULL, '007001', '007', '2021-12-27 20:19:25', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604620920684544', '放款账户公私标志', 'loanAcctCls', '571719092189265920', NULL, NULL, '2', 'GLB_ACC_MARK', '007001', '007', '2021-12-27 20:19:59', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573604800667582464', '手机号码', 'loanAccBankPhone', '571719092189265920', NULL, NULL, '11', NULL, '007001', '007', '2021-12-27 20:20:42', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('573604948831371264', '还款账户开户行行号', 'repayAccBank', '571719092189265920', NULL, NULL, '32', NULL, '007001', '007', '2021-12-27 20:21:17', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', '');
|
|
INSERT INTO `prd_tree` VALUES ('573605017458573312', '还款卡号', 'repayCardNo', '571719092189265920', NULL, NULL, '32', NULL, '007001', '007', '2021-12-27 20:21:33', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', '');
|
|
INSERT INTO `prd_tree` VALUES ('573605072756277248', '还款账户开户行名称', 'repayAccBankName', '571719092189265920', NULL, NULL, '200', NULL, '007001', '007', '2021-12-27 20:21:46', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573605120806223872', '还款账户户名', 'repayAccName', '571719092189265920', NULL, NULL, '200', NULL, '007001', '007', '2021-12-27 20:21:58', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573605193141190656', '还款账户公私标志', 'repayAcctCls', '571719092189265920', NULL, NULL, '2', 'GLB_ACC_MARK', '007001', '007', '2021-12-27 20:22:15', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL);
|
|
INSERT INTO `prd_tree` VALUES ('573605278583357440', '手机号码', 'repayAccBankPhone', '571719092189265920', NULL, NULL, '11', NULL, '007001', '007', '2021-12-27 20:22:35', '2037-07-04', NULL, NULL, NULL, NULL, 1, 'P22071001', '^(13[0-9]|14[01456789]|15[0-3,5-9]|16[2567]|17[0-8]|18[0-9]|19[0-3,5-9])\\d{8}$');
|
|
INSERT INTO `prd_tree` VALUES ('573938077018357760', '渠道还款申请流水号', 'chanTranNo', '571716705814839296', '0', '', '', NULL, '007001', '007', '2021-12-28 18:25:01', '2037-07-22', NULL, NULL, NULL, NULL, 1, 'P22071001', NULL); |