-- zy INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('自定义名单网格热力图-公司指标', 'gridshapecountindex_gs', '0', 'admin', '2025-06-20 16:15:28', 'admin', '2025-06-20 16:16:18', NULL); INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('自定义名单网格热力图-零售指标', 'gridshapecountindex_ls', '0', 'admin', '2025-06-20 16:16:08', '', NULL, NULL); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '入格客户数', 'cust_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '活期存款余额', 'hq_cur_balance', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '保证金存款余额', 'bz_cur_balance', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款余额', 'loan_balance_cny', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贴现余额', 'finance_prod_711_balance', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '承兑汇票余额', 'finance_prod_716_balance', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款年日均', 'loan_year_dailyaverage', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '合同签约率', 'htqy_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '签发承兑汇票率', 'qfcd_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贴现业务率', 'tx_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '保函业务率', 'bh_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '有效代发工资率', 'yxdfgz_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣电费率', 'dkdf_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣水费率', 'dksf_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣税费率', 'dkshf_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '票据宝签约率', 'pjb_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '财资宝签约率', 'czb_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '收付宝签约率', 'sfb_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贸融宝签约率', 'mrb_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '数字生态产品签约率', 'szst_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '开户率', 'kh_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '国际结算业务率', 'gjjsyw_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '远期结算汇业务率', 'yqjsh_rat', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '合同签约数', 'htqy_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '签发承兑汇票数', 'qfcd_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贴现业务数', 'tx_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '保函业务数', 'bh_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '有效代发工资数', 'yxdfgz_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '月均代发工资笔数', 'ustr_count_per_m', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '月均代发工资金额(元)', 'ustr_bal_m', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣电费数', 'dkdf_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣水费数', 'dksf_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣税费数', 'dkshf_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '票据宝签约数', 'pjb_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '财资宝签约数', 'czb_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '收付宝签约数', 'sfb_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贸融宝签约数', 'mrb_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '数字生态产品签约数', 'szst_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '开户数', 'kh_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '国际结算业务数', 'gjjsyw_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '远期结算汇业务数', 'yqjsh_num', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近365天已走访人数', 'zf_365cnt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近180天已走访人数', 'zf_180cnt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近90天已走访人数', 'zf_90cnt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近30天已走访人数', 'zf_30cnt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', '', NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近365天走访率', 'zf_365rt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近180天走访率', 'zf_180rt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近90天走访率', 'zf_90rt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近30天走访率', 'zf_30rt', 'gridshapecountindex_gs', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '入格客户数', 'cust_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '活期存款余额', 'cur_bal_d', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '定期存款余额', 'cur_bal_t', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款余额', 'bal_loan', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '五级不良贷款余额', 'cur_bal_5_bad', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '活期存款年日均', 'cur_d_ave', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '定期存款年日均', 'cur_t_ave', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款年日均', 'loan_ave', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '建档率', 'ph_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '授信率', 'sx_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '合同签约率', 'yxht_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '信用卡覆盖率', 'xyk_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '丰收互联覆盖率', 'fshl_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '收单覆盖率', 'sd_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, 'ETC覆盖率', 'etc_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣电费覆盖率', 'dian_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款黑名单占比', 'black_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '五级不良贷款占比(人)', 'bad_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '五级不良贷款占比(金额)', 'bad_bal_rat', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '建档客户数', 'ph_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '授信客户数', 'sx_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '合同签约客户数', 'yxht_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '持有信用卡客户数', 'xyk_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '开通丰收互联客户数', 'fshl_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '收单客户数', 'sd_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, 'ETC客户数', 'etc_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '代扣电费客户数', 'dian_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '贷款黑名单客户数', 'black_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '五级不良贷款客户数', 'bad_num', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近365天已走访人数', 'zf_365cnt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近180天已走访人数', 'zf_180cnt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近90天已走访人数', 'zf_90cnt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近30天已走访人数', 'zf_30cnt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近365天走访率', 'zf_365rt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近180天走访率', 'zf_180rt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近90天走访率', 'zf_90rt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '近30天走访率', 'zf_30rt', 'gridshapecountindex_ls', '', '', 'N', '0', 'admin', '2025-03-12 10:50:15', NULL, NULL, ''); ALTER TABLE sys_campaign_group_customer ADD cust_name varchar(100) NULL COMMENT '客戶姓名'; ALTER TABLE sys_campaign_group_customer ADD cust_isn varchar(100) NULL COMMENT '客戶内碼'; ALTER TABLE sys_campaign_group_customer ADD lp_name varchar(100) NULL COMMENT '法人姓名'; ALTER TABLE sys_campaign ADD `related_model_id` varchar(100) NULL COMMENT '关联反馈模板uuid 默认模板-1'; CREATE TABLE `lowcode_visst_feedback_model` ( `id` bigint(21) NOT NULL AUTO_INCREMENT COMMENT '主键', `uuid` varchar(100) DEFAULT NULL COMMENT '主键', `dept_id` bigint(21) DEFAULT NULL COMMENT '机构号', `model_name` varchar(200) DEFAULT NULL COMMENT '模板名字', `model_detal` json DEFAULT NULL COMMENT '模板内容', `belong_outlet_id` varchar(500) DEFAULT NULL COMMENT '归属网点', `belong_outlet_name` varchar(500) DEFAULT NULL COMMENT '归属网点', `CREATED_BY` varchar(32) DEFAULT NULL COMMENT '创建人', `CREATED_TIME` datetime DEFAULT NULL COMMENT '创建时间', `UPDATED_BY` varchar(32) DEFAULT NULL COMMENT '更新人', `UPDATED_TIME` datetime DEFAULT NULL COMMENT '更新时间', `model_type` varchar(2) DEFAULT NULL COMMENT '模板类型 0零售1公司2运管', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='走访反馈自定义模板编辑表'; INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES( '外部系统链接', 'external_url', '0', 'admin', '2025-07-03 18:07:27', '', NULL, NULL); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(0, 'product_manual', '数智支行操作手册V1.0.docx', 'product_manual_szzh', NULL, 'default', 'N', '0', 'admin', '2025-06-26 19:28:33', '', NULL, NULL); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(0, '965-系统A', 'http://xxxxx/', 'external_url', NULL, 'default', 'N', '0', 'admin', '2025-07-03 18:08:44', '', NULL, NULL); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES(1, '965-系统B', 'http://xxxx', 'external_url', NULL, 'default', 'N', '0', 'admin', '2025-07-03 18:09:09', '', NULL, NULL); INSERT INTO sys_dict_data ( dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) VALUES( 0, '932-系统C', 'HTTPS://1213', 'external_url', NULL, 'default', 'N', '0', 'admin', '2025-07-03 18:35:28', '', NULL, NULL); INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES( '数智支行操作手册名称', 'product_manual_szzh', '0', 'admin', '2025-06-26 19:27:31', '', NULL, NULL); -- ibs.grid_region_transfer definition CREATE TABLE `grid_region_transfer` ( `id` bigint(21) NOT NULL AUTO_INCREMENT COMMENT 'id', `status` varchar(10) DEFAULT NULL COMMENT '状态 0支行审批 1总行审批 2审批通过 -1审批拒绝', `cust_id` varchar(100) DEFAULT NULL COMMENT '客户号', `cust_name` varchar(100) DEFAULT NULL COMMENT '客户名称', `cust_type` varchar(100) DEFAULT NULL, `ops_dept` varchar(10) DEFAULT NULL COMMENT '部室', `prev_grid_id` bigint(21) DEFAULT NULL COMMENT '原网格', `prev_grid_name` varchar(255) DEFAULT NULL COMMENT '原网格名称', `prev_user` varchar(100) DEFAULT NULL COMMENT '原客户经理', `prev_branch_id` bigint(21) DEFAULT NULL COMMENT '原支行', `prev_branch_name` varchar(100) DEFAULT NULL COMMENT '原支行名称', `next_grid_id` bigint(21) DEFAULT NULL COMMENT '移交网格', `next_grid_name` varchar(255) DEFAULT NULL COMMENT '移交网格名称', `next_branch_ids` varchar(255) DEFAULT NULL COMMENT '移交支行', `next_branch_name` varchar(255) DEFAULT NULL COMMENT '移交支行名称', `next_users` varchar(255) DEFAULT NULL COMMENT '移交客户经理', `approve_branch_user` varchar(255) DEFAULT NULL COMMENT '审批支行管理员', `approve_branch_result` varchar(1) DEFAULT NULL COMMENT '审批支行结果', `approve_head_user` varchar(255) DEFAULT NULL COMMENT '审批总行部室管理员', `approve_head_result` varchar(1) DEFAULT NULL COMMENT '审批总行结果', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(100) DEFAULT NULL COMMENT '创建者', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='行政网格移交表'; ALTER TABLE ibs.grid_region_cust_user_965 ADD region_name varchar(100) NULL; ALTER TABLE ibs.grid_region_cust_user_965 ADD top_grid_duty_type varchar(100) NULL; ALTER TABLE ibs.grid_region_cust_user_965 ADD sec_grid_duty_type varchar(100) NULL; -- ibs.task_visit_cust_address definition CREATE TABLE `task_visit_cust_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cust_id` varchar(50) NOT NULL, `province` varchar(50) DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `county` varchar(50) DEFAULT NULL, `detail_address` text, `lng` decimal(15,8) DEFAULT NULL, `lat` decimal(15,8) DEFAULT NULL, `user_name` varchar(50) DEFAULT NULL, `update_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='走访地址采集'; -- ibs.task_visit_image definition CREATE TABLE `task_visit_image` ( `file_id` varchar(100) NOT NULL COMMENT 'uuid', `record_id` varchar(100) NOT NULL COMMENT '任务走访id', `sign_type` varchar(1) NOT NULL COMMENT '打卡类型 0签到 1签退', `create_time` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`file_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='走访打卡图片'; -- ibs.task_visit_record definition CREATE TABLE `task_visit_record` ( `id` varchar(100) NOT NULL COMMENT 'id', `campaign_id` varchar(100) NOT NULL COMMENT '任务id', `campaign_name` varchar(100) NOT NULL COMMENT '任务名称', `cust_id` varchar(100) NOT NULL COMMENT '客户号', `cust_name` varchar(100) NOT NULL COMMENT '客户名称', `user_id` bigint(20) DEFAULT NULL, `nick_name` varchar(100) NOT NULL COMMENT '客户经理名称', `user_name` varchar(100) NOT NULL COMMENT '客户经理柜员号', `sign_id` varchar(100) DEFAULT NULL, `latest_sign` varchar(100) DEFAULT NULL, `duration` double DEFAULT '0', `feedback_id` varchar(100) DEFAULT NULL, `feedback_type` varchar(100) DEFAULT NULL COMMENT '反馈模板类型 0对私 1对公 2自定义', `feedback_template_id` varchar(100) DEFAULT NULL, `cust_type` varchar(100) DEFAULT NULL, `visit_type` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务走访记录'; -- ibs.task_visit_sign definition CREATE TABLE `task_visit_sign` ( `id` varchar(100) NOT NULL COMMENT 'id', `record_id` varchar(100) DEFAULT NULL COMMENT '走访记录id', `sign_in_time` datetime DEFAULT NULL COMMENT '签到时间', `sign_in_address` text COMMENT '签到地址', `sign_in_lng` decimal(15,8) DEFAULT NULL COMMENT '签到经度', `sign_in_lat` decimal(15,8) DEFAULT NULL COMMENT '签到纬度', `sign_out_time` datetime DEFAULT NULL COMMENT '签退时间', `sign_out_address` text COMMENT '签退地址', `sign_out_lng` decimal(15,8) DEFAULT NULL COMMENT '签退经度', `sign_out_lat` decimal(15,8) DEFAULT NULL COMMENT '签退纬度', `sign_out_remark` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='走访任务打卡记录'; -- ibs.visit_feedback_private definition CREATE TABLE `visit_feedback_private` ( `id` varchar(100) NOT NULL COMMENT 'uuid', `client_suggestion` text COMMENT '客户反馈意见', `client_label` text COMMENT '客户标签', `intend_product` text COMMENT '意向产品', `other_intend` text COMMENT '其他意向', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='走访反馈对私'; -- ibs.visit_feedback_public definition CREATE TABLE `visit_feedback_public` ( `id` varchar(100) NOT NULL COMMENT 'uuid', `client_suggestion` text COMMENT '客户意见', `client_label` text COMMENT '客户标签', `status_flag` varchar(1) DEFAULT NULL COMMENT '是否经营', `address_consist` varchar(1) DEFAULT NULL COMMENT '地址是否一致', `address` text COMMENT '地址', `scope_consist` varchar(1) DEFAULT NULL COMMENT '经营范围是否一致', `scope` text COMMENT '经营范围', `relate_person` text COMMENT '关联人', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='走访反馈对公'; -- ibs.oss_file_data definition CREATE TABLE `oss_file_data` ( `file_id` varchar(255) NOT NULL COMMENT 'uuid', `file_name` varchar(255) NOT NULL COMMENT '文件名', `original_file_name` varchar(100) DEFAULT NULL, `content_type` varchar(255) DEFAULT NULL COMMENT '文件类型', `file_size` double DEFAULT NULL, `file_enum` varchar(100) DEFAULT NULL, `user_name` varchar(100) DEFAULT NULL, `file_url` varchar(255) NOT NULL COMMENT '文件url', `create_time` datetime DEFAULT NULL, PRIMARY KEY (`file_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `qywx_org` ( `org_id` varchar(100) DEFAULT NULL COMMENT '机构id', `app_id` varchar(100) DEFAULT NULL, `agent_id` varchar(100) DEFAULT NULL, `secret` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='企业微信机构参数表'