/* Navicat MySQL Data Transfer Source Server : test_v5_qy Source Server Version : 50731 Source Host : 220.243.148.23:2111 Source Database : crmeb Target Server Type : MYSQL Target Server Version : 50731 File Encoding : 65001 Date: 2023-08-15 13:50:16 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for eb_huifu_wallet -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet`; CREATE TABLE `eb_huifu_wallet` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '服务开通主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uid', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_complete_open` varchar(1) DEFAULT '0' COMMENT '是否完成开通', `open_time` datetime DEFAULT NULL COMMENT '完成开通时间', `cooperate_treaty_url` varchar(200) DEFAULT NULL COMMENT '合作协议url', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包服务开通'; INSERT INTO `eb_huifu_wallet` (`id`, `uni_id`, `create_time`, `update_time`, `is_complete_open`, `open_time`, `cooperate_treaty_url`) VALUES ('11', 'aSuXCEfz', '2023-08-09 17:23:11', '2023-08-10 16:45:11', '1', '2023-08-09 20:04:22', NULL); INSERT INTO `eb_huifu_wallet` (`id`, `uni_id`, `create_time`, `update_time`, `is_complete_open`, `open_time`, `cooperate_treaty_url`) VALUES ('12', '__iZjB3As6MOfttXkZTXo', '2023-08-09 17:23:11', '2023-08-10 16:45:11', '1', '2023-08-10 20:04:22', NULL); INSERT INTO `eb_huifu_wallet` (`id`, `uni_id`, `create_time`, `update_time`, `is_complete_open`, `open_time`, `cooperate_treaty_url`) VALUES ('13', 'iXOdYWce', '2023-08-12 17:25:32', '2023-08-12 17:27:22', '1', '2023-08-12 17:27:22', NULL); -- ---------------------------- -- Table structure for eb_huifu_wallet_account -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_account`; CREATE TABLE `eb_huifu_wallet_account` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户基础信息主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uid', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `com_name` varchar(50) DEFAULT NULL COMMENT '公司名称', `short_name` varchar(50) DEFAULT NULL COMMENT '经营简称', `com_cer_no` varchar(50) DEFAULT NULL COMMENT '企业证件号码', `license_validity_type` varchar(2) DEFAULT NULL COMMENT '证照有效期类型:1:长期有效 0:非长期有效；', `license_begin_date` varchar(10) DEFAULT NULL COMMENT '证照有效期起始日期yyyyMMdd', `license_end_date` varchar(10) DEFAULT NULL COMMENT '证照有效期结束日期yyyyMMdd', `reg_prov_id` varchar(6) DEFAULT NULL COMMENT '注册地址(省)', `reg_area_id` varchar(6) DEFAULT NULL COMMENT '注册地址(市)', `reg_district_id` varchar(6) DEFAULT NULL COMMENT '注册地址(区)', `reg_address` varchar(200) DEFAULT NULL COMMENT '注册地址(详细信息)', `legal_rep_name` varchar(50) DEFAULT NULL COMMENT '法定代表人姓名', `idcard_type` varchar(6) DEFAULT NULL COMMENT '法人身份证件类型', `idCard_no` varchar(20) DEFAULT NULL COMMENT '法定代表人证件号码', `legal_cert_validity_type` varchar(2) DEFAULT NULL COMMENT '证照有效期类型:1:长期有效 0:非长期有效；', `legal_cert_begin_date` varchar(10) DEFAULT NULL COMMENT '身份证有效期开始日期', `legal_cert_end_date` varchar(10) DEFAULT NULL COMMENT '身份证有效期截止日期', `contact_name` varchar(50) DEFAULT NULL COMMENT '联系人姓名', `contact_phone` varchar(20) DEFAULT NULL COMMENT '联系电话', `hf_com_type` varchar(6) DEFAULT NULL COMMENT '汇付企业类型', `wallet_account_no` varchar(30) DEFAULT NULL COMMENT '钱包账户号', `frozen_amount` decimal(10,2) DEFAULT '0.00' COMMENT '冻结金额', `acct_stat` varchar(6) DEFAULT NULL COMMENT '账户状态', PRIMARY KEY (`id`) USING BTREE, KEY `index_com_wallet_account_walletAccountNo` (`wallet_account_no`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包账户基础信息'; INSERT INTO `eb_huifu_wallet_account` (`id`, `uni_id`, `create_time`, `update_time`, `com_name`, `short_name`, `com_cer_no`, `license_validity_type`, `license_begin_date`, `license_end_date`, `reg_prov_id`, `reg_area_id`, `reg_district_id`, `reg_address`, `legal_rep_name`, `idcard_type`, `idCard_no`, `legal_cert_validity_type`, `legal_cert_begin_date`, `legal_cert_end_date`, `contact_name`, `contact_phone`, `hf_com_type`, `wallet_account_no`, `frozen_amount`, `acct_stat`) VALUES ('17', 'aSuXCEfz', '2023-08-09 17:23:11', '2023-08-14 20:18:32', '陕西众合保安服务有限公司', '陕西众合保安服务有限公司', '91610102MA6U0CPG8J', '1', '20161124', '99990101', '610000', '610100', '610102', '西安市新城区新民街38号1幢1单元10803室', '李静', '00', '610502198603142850', '1', '19860314', '99990101', '李静', '13606084244', '3', '6666000137506841', '0.05', 'N'); INSERT INTO `eb_huifu_wallet_account` (`id`, `uni_id`, `create_time`, `update_time`, `com_name`, `short_name`, `com_cer_no`, `license_validity_type`, `license_begin_date`, `license_end_date`, `reg_prov_id`, `reg_area_id`, `reg_district_id`, `reg_address`, `legal_rep_name`, `idcard_type`, `idCard_no`, `legal_cert_validity_type`, `legal_cert_begin_date`, `legal_cert_end_date`, `contact_name`, `contact_phone`, `hf_com_type`, `wallet_account_no`, `frozen_amount`, `acct_stat`) VALUES ('18', '__iZjB3As6MOfttXkZTXo', '2023-08-09 17:23:11', '2023-08-10 16:44:47', '百川信（北京）信息服务有限公司', '百川信（北京）信息服务有限公司', '91350200302969730N', '0', '20140910', '20640909', '110000', '110100', '110101', '青龙胡同甲1号、3号2幢2层205-08 室', '王慧梅', '00', '622824197801040189', '0', '20190925', '20390925', '黎兴旺', '13599911340', '3', '6666000137445326', '0.00', 'N'); INSERT INTO `eb_huifu_wallet_account` (`id`, `uni_id`, `create_time`, `update_time`, `com_name`, `short_name`, `com_cer_no`, `license_validity_type`, `license_begin_date`, `license_end_date`, `reg_prov_id`, `reg_area_id`, `reg_district_id`, `reg_address`, `legal_rep_name`, `idcard_type`, `idCard_no`, `legal_cert_validity_type`, `legal_cert_begin_date`, `legal_cert_end_date`, `contact_name`, `contact_phone`, `hf_com_type`, `wallet_account_no`, `frozen_amount`, `acct_stat`) VALUES ('19', 'iXOdYWce', '2023-08-12 17:25:32', '2023-08-12 17:27:25', '众惠盾(厦门)保安服务有限公司', '众惠盾(厦门)保安服务有限公司', '91350200MA2YHM821H', '0', '20170825', '20670824', '350000', '350200', '350211', '厦门市软件园三期诚毅大街358号1604单元之一', '向小云', '00', '350204195610272038', '1', '20060116', '99990101', '洪明耀', '15980898667', '3', '6666000137685569', '0.00', 'N'); -- ---------------------------- -- Table structure for eb_huifu_wallet_account_detail -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_account_detail`; CREATE TABLE `eb_huifu_wallet_account_detail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '收支明细主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uni_id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `trade_date` varchar(20) DEFAULT NULL COMMENT '交易时间', `trade_flow_no` varchar(64) DEFAULT NULL COMMENT '交易流水号', `flow_no` varchar(64) DEFAULT NULL COMMENT '账务流水号（业务流水号）', `accounts_deal_type` varchar(10) DEFAULT NULL COMMENT '账务处理类型', `accounts_deal_date` varchar(20) DEFAULT NULL COMMENT '账务处理时间', `amount` varchar(20) DEFAULT NULL COMMENT '交易金额', `balance` varchar(20) DEFAULT NULL COMMENT '交易后余额', `direction` varchar(10) DEFAULT NULL COMMENT '资金流向', `hand_status` varchar(10) DEFAULT NULL COMMENT '处理状态', `create_date` varchar(20) DEFAULT NULL COMMENT '订单创建时间', `service_type` varchar(10) DEFAULT NULL COMMENT '服务类型', `trade_type` varchar(10) DEFAULT NULL COMMENT '交易类型', `account_in` varchar(30) DEFAULT NULL COMMENT '收款方账户', `account_out` varchar(30) DEFAULT NULL COMMENT '付款方账户', `account_in_name` varchar(100) DEFAULT NULL COMMENT '收款方账户中文', `account_out_name` varchar(100) DEFAULT NULL COMMENT '付款方账户中文', `memo` varchar(100) DEFAULT NULL COMMENT '备注', `voucher_url` varchar(500) DEFAULT NULL COMMENT '电子回单url', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包账户-收支明细'; INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('2', '__iZjB3As6MOfttXkZTXo', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810205207', '003500TOP1A230810205207P003ac139c1300000', '4540429074', '内部户处理', '20230810', '1.00', '2.00', '入账', '成功', NULL, NULL, '转账转入', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('3', '__iZjB3As6MOfttXkZTXo', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810205030', '003500TOP3A230810205030P128ac139c5c00000', '4540427805', '内部户处理', '20230810', '1.00', '1.00', '入账', '成功', NULL, NULL, '转账转入', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('4', '__iZjB3As6MOfttXkZTXo', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810183720', '00470topo1A230810183501P607ac1364ef00000', '4540000747', '内部户处理', '20230810', '0.00', '0.00', '出账', '成功', NULL, NULL, '手续费收取', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('5', '__iZjB3As6MOfttXkZTXo', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810183720', '00470topo1A230810183501P607ac1364ef00000', '4540000745', '内部户处理', '20230810', '8.00', '8.00', '入账', '成功', NULL, NULL, '支付收款', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('6', 'aSuXCEfz', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810205207', '003500TOP1A230810205207P003ac139c1300000', '4540429075', '内部户处理', '20230810', '1.00', '10.00', '出账', '成功', NULL, NULL, '转账转出', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('7', 'aSuXCEfz', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810205030', '003500TOP3A230810205030P128ac139c5c00000', '4540427806', '内部户处理', '20230810', '1.00', '11.00', '出账', '成功', NULL, NULL, '转账转出', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('8', 'aSuXCEfz', '2023-08-11 16:15:02', '2023-08-11 16:15:02', '20230810183720', '00470topo1A230810183501P607ac1364ef00000', '4540000746', '内部户处理', '20230810', '12.00', '12.00', '入账', '成功', NULL, NULL, '支付收款', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('58', '__iZjB3As6MOfttXkZTXo', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811170217', '003500TOP1A230811170216P876ac139c3200000', '4542082386', '内部户处理', '20230811', '0.01', '2.01', '入账', '成功', NULL, NULL, '转账转入', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('59', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811210659', '003000TOP1A230811210658P793ac139fed00000', '4542854371', '内部户处理', '20230811', '0.10', '0.89', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('60', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811205232', '003000TOP1B230811205231P508ac139d2300000', '4542808627', '内部户处理', '20230811', '1.00', '0.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('61', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811204039', '003000TOP3A230811204038P913ac139d2100000', '4542764080', '内部户处理', '20230811', '1.00', '1.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('62', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811203747', '003000TOP2B230811203747P042ac139d3100000', '4542766837', '内部户处理', '20230811', '1.00', '2.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('63', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811200821', '003000TOP2B230811200820P444ac139c0b00000', '4542675687', '内部户处理', '20230811', '1.00', '3.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('64', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811200706', '003000TOP3B230811200705P450ac139ffc00000', '4542660922', '内部户处理', '20230811', '1.00', '4.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('65', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811200545', '003000TOP2B230811200545P282ac139d3100000', '4542654224', '内部户处理', '20230811', '1.00', '5.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('66', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811193158', '003000TOP3A230811193157P388ac139d2100000', '4542546503', '内部户处理', '20230811', '1.00', '6.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('67', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811193132', '003000TOP2A230811193131P515ac139c0800000', '4542534938', '内部户处理', '20230811', '1.00', '7.99', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('68', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811170217', '003500TOP1A230811170216P876ac139c3200000', '4542082387', '内部户处理', '20230811', '0.01', '8.99', '出账', '成功', NULL, NULL, '转账转出', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `eb_huifu_wallet_account_detail` (`id`, `uni_id`, `create_time`, `update_time`, `trade_date`, `trade_flow_no`, `flow_no`, `accounts_deal_type`, `accounts_deal_date`, `amount`, `balance`, `direction`, `hand_status`, `create_date`, `service_type`, `trade_type`, `account_in`, `account_out`, `account_in_name`, `account_out_name`, `memo`, `voucher_url`) VALUES ('69', 'aSuXCEfz', '2023-08-12 10:59:56', '2023-08-12 10:59:56', '20230811154325', '003000TOP2A230811154325P140ac139ced00000', '4541917587', '内部户处理', '20230811', '1.00', '9.00', '出账', '成功', NULL, NULL, '取现', NULL, NULL, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for eb_huifu_wallet_busi -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_busi`; CREATE TABLE `eb_huifu_wallet_busi` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户业务入驻主键ID', `account_id` int(10) NOT NULL DEFAULT '0' COMMENT '账户基础信息id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `req_seq_id` varchar(32) DEFAULT NULL COMMENT '流水号', `wallet_account_no` varchar(30) DEFAULT NULL COMMENT '钱包账户号', `mp` varchar(20) DEFAULT NULL COMMENT '银行卡绑定手机号', `cash_type` varchar(6) DEFAULT NULL COMMENT '业务类型 D1：下一自然日到银行账户 D0：当日到银行账户', `card_type` varchar(2) DEFAULT NULL COMMENT '卡类型：对公，1：对私，2：对私非法人', `card_name` varchar(128) DEFAULT NULL COMMENT '卡户名', `card_no` varchar(32) DEFAULT NULL COMMENT '卡号', `prov_id` varchar(6) DEFAULT NULL COMMENT '银行所在省', `area_id` varchar(6) DEFAULT NULL COMMENT '银行所在市', `bank_code` varchar(8) DEFAULT NULL COMMENT '银行号', `branch_code` varchar(12) DEFAULT NULL COMMENT '支行联行号', `branch_name` varchar(64) DEFAULT NULL COMMENT '支行名称', `token_no` varchar(20) DEFAULT NULL COMMENT '取现卡序列号', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包账户业务入驻'; INSERT INTO `eb_huifu_wallet_busi` (`id`, `account_id`, `create_time`, `update_time`, `req_seq_id`, `wallet_account_no`, `mp`, `cash_type`, `card_type`, `card_name`, `card_no`, `prov_id`, `area_id`, `bank_code`, `branch_code`, `branch_name`, `token_no`) VALUES ('3', '17', '2023-08-09 20:04:22', '2023-08-11 14:30:48', '202308092004198009w0kz2fgtfzh96', NULL, NULL, 'D1', '0', '陕西众合保安服务有限公司', '3700020509245218394', '610000', '610100', '1020000', '102791000195', '工行陕西省西安北关支行', '10032533917'); INSERT INTO `eb_huifu_wallet_busi` (`id`, `account_id`, `create_time`, `update_time`, `req_seq_id`, `wallet_account_no`, `mp`, `cash_type`, `card_type`, `card_name`, `card_no`, `prov_id`, `area_id`, `bank_code`, `branch_code`, `branch_name`, `token_no`) VALUES ('4', '18', '2023-08-09 20:04:22', '2023-08-11 14:30:52', NULL, NULL, NULL, 'T1', '0', '百川信（北京）信息服务有限公司', '0200053419200063402', '110000', '110100', '1050000', '105100010037', '中国建设银行北京呼家楼支行', '10032484976'); INSERT INTO `eb_huifu_wallet_busi` (`id`, `account_id`, `create_time`, `update_time`, `req_seq_id`, `wallet_account_no`, `mp`, `cash_type`, `card_type`, `card_name`, `card_no`, `prov_id`, `area_id`, `bank_code`, `branch_code`, `branch_name`, `token_no`) VALUES ('5', '19', '2023-08-12 17:27:22', '2023-08-12 17:27:22', '20230812172720809vn36stvdsgldh3', NULL, NULL, 'D1', '0', '众惠盾(厦门)保安服务有限公司', '35150198540100000484', '350000', '350200', '1050000', '105393000499', '中国建设银行股份有限公司厦门滨东支行', '10032671586'); -- ---------------------------- -- Table structure for eb_huifu_wallet_process -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_process`; CREATE TABLE `eb_huifu_wallet_process` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '开户流程主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uni_id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `step` int(4) NOT NULL COMMENT '第几步', `description` varchar(30) DEFAULT NULL COMMENT '描述', `is_complete` varchar(1) DEFAULT NULL COMMENT '是否完成', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包开户流程'; INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('16', 'aSuXCEfz', '2023-08-09 14:23:11', '2023-08-09 14:45:23', '1', '企业基本信息录入', '1'); INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('17', 'aSuXCEfz', '2023-08-09 17:23:11', '2023-08-10 16:45:23', '2', '账户业务入驻', '1'); INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('18', '__iZjB3As6MOfttXkZTXo', '2023-08-09 14:23:11', '2023-08-09 14:45:23', '1', '企业基本信息录入', '1'); INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('19', '__iZjB3As6MOfttXkZTXo', '2023-08-09 17:23:11', '2023-08-10 16:45:23', '2', '账户业务入驻', '1'); INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('20', 'iXOdYWce', '2023-08-12 17:25:32', '2023-08-12 17:25:32', '1', '企业基本信息录入', '1'); INSERT INTO `eb_huifu_wallet_process` (`id`, `uni_id`, `create_time`, `update_time`, `step`, `description`, `is_complete`) VALUES ('21', 'iXOdYWce', '2023-08-12 17:25:32', '2023-08-15 13:55:03', '2', '账户业务入驻', '1'); -- ---------------------------- -- Table structure for eb_huifu_wallet_reconciliation -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_reconciliation`; CREATE TABLE `eb_huifu_wallet_reconciliation` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '对账主键ID', `trade_serial_no` varchar(64) NOT NULL COMMENT '交易流水号', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `merchant_no` varchar(30) DEFAULT NULL COMMENT '商户号', `trade_date` varchar(10) DEFAULT NULL COMMENT '交易日期', `request_serial_no` varchar(64) DEFAULT NULL COMMENT '请求流水号', `trade_amount` decimal(14,2) DEFAULT NULL COMMENT '交易金额', `trade_status` varchar(6) DEFAULT NULL COMMENT '交易状态', `bank_trade_type` varchar(6) DEFAULT NULL COMMENT '银行交易类型', `trade_start_time` varchar(20) DEFAULT NULL COMMENT '交易订单创建时间', `trade_end_time` varchar(20) DEFAULT NULL COMMENT '交易订单完成时间', `expend_account_no` varchar(30) DEFAULT NULL COMMENT '出账方账号', `expend_account_name` varchar(30) DEFAULT NULL COMMENT '出账方户名', `expend_bank_code` varchar(20) DEFAULT NULL COMMENT '出账方银行编码', `income_account_no` varchar(30) DEFAULT NULL COMMENT '入账方账号', `income_account_name` varchar(30) DEFAULT NULL COMMENT '入账方户名', `incomed_bank_code` varchar(20) DEFAULT NULL COMMENT '入账方银行编码', `income_cer_no` varchar(50) DEFAULT NULL COMMENT '入账方卡号', `merchant_retain` varchar(50) DEFAULT NULL COMMENT '商户保留域', `remark` varchar(200) DEFAULT NULL COMMENT '交易备注', `service_charge` varchar(100) DEFAULT NULL COMMENT '手续费', `expend_uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '出账用户uni_id', `income_uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '入账用户uni_id', PRIMARY KEY (`id`) USING BTREE, KEY `index_com_wallet_reconciliation_expendAccountNo` (`expend_account_no`) USING BTREE, KEY `index_com_wallet_reconciliation_incomeAccountNo` (`income_account_no`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包对账'; INSERT INTO `eb_huifu_wallet_reconciliation` (`id`, `trade_serial_no`, `create_time`, `update_time`, `merchant_no`, `trade_date`, `request_serial_no`, `trade_amount`, `trade_status`, `bank_trade_type`, `trade_start_time`, `trade_end_time`, `expend_account_no`, `expend_account_name`, `expend_bank_code`, `income_account_no`, `income_account_name`, `incomed_bank_code`, `income_cer_no`, `merchant_retain`, `remark`, `service_charge`, `expend_uni_id`, `income_uni_id`) VALUES ('1', '003500TOP1A230810205207P003ac139c1300000', '2023-08-11 17:41:19', '2023-08-11 19:16:46', NULL, '20230810', '300000', '1.00', '1', NULL, '20230810', '20230810', '6666000137506841', '陕西众合保安服务有限公司', '102791000195', '6666000137445326', '百川信（北京）信息服务有限公司', '105100010037', NULL, '购买产品', NULL, NULL, 'aSuXCEfz', '__iZjB3As6MOfttXkZTXo'); INSERT INTO `eb_huifu_wallet_reconciliation` (`id`, `trade_serial_no`, `create_time`, `update_time`, `merchant_no`, `trade_date`, `request_serial_no`, `trade_amount`, `trade_status`, `bank_trade_type`, `trade_start_time`, `trade_end_time`, `expend_account_no`, `expend_account_name`, `expend_bank_code`, `income_account_no`, `income_account_name`, `incomed_bank_code`, `income_cer_no`, `merchant_retain`, `remark`, `service_charge`, `expend_uni_id`, `income_uni_id`) VALUES ('2', '003500TOP1A230810205207P003ac139c1300001', '2023-08-11 17:41:19', '2023-08-11 19:16:49', '', '20230810', '300001', '8.00', '1', '', '20230810', '20230810', '6666000137506841', '陕西众合保安服务有限公司', '102791000195', '6666000137445326', '百川信（北京）信息服务有限公司', '105100010037', '', '购买产品', '', '', 'aSuXCEfz', '__iZjB3As6MOfttXkZTXo'); -- ---------------------------- -- Table structure for eb_huifu_wallet_trade -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_trade`; CREATE TABLE `eb_huifu_wallet_trade` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户交易记录主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uni_id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `req_seq_id` varchar(32) DEFAULT NULL COMMENT '请求流水号', `hf_seq_id` varchar(64) DEFAULT NULL COMMENT '全局流水号', `expend_account_no` varchar(32) DEFAULT NULL COMMENT '出账方商户号', `income_account_no` varchar(32) DEFAULT NULL COMMENT '入账方商户号', `amount` decimal(10,2) DEFAULT NULL COMMENT '金额', `good_desc` varchar(256) DEFAULT NULL COMMENT '商品描述', `remark` varchar(256) DEFAULT NULL COMMENT '备注', `trade_status` varchar(6) DEFAULT NULL COMMENT '交易状态', `trans_finish_time` timestamp NULL DEFAULT NULL COMMENT '交易完成时间', `business_partner_seq` varchar(60) DEFAULT NULL COMMENT '业务交易流水号', `business_code` varchar(20) DEFAULT NULL COMMENT '业务编码', `trade_type` varchar(255) DEFAULT NULL COMMENT '校验类型', `error_msg` varchar(255) DEFAULT NULL COMMENT '失败原因', PRIMARY KEY (`id`) USING BTREE, KEY `index_com_wallet_trade_uni_id` (`uni_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包账户交易记录'; INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('3', 'aSuXCEfz', '2023-08-10 20:51:59', '2023-08-10 20:52:07', '20230810205159799wlwayzstn708st', '003500TOP1A230810205207P003ac139c1300000', '6666000137506841', '6666000137445326', '0.00', NULL, NULL, '1', '2023-08-10 20:52:07', '20230810203741630', '01001', '03', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('4', 'aSuXCEfz', '2023-08-10 20:51:59', '2023-08-10 20:52:07', '20230810205159799wlwayzstn708st', '003500TOP1A230810205207P003ac139c1300000', '6666000137506841', '6666000137445326', '0.00', NULL, NULL, '1', '2023-08-10 20:52:07', '20230810203741630', '01001', '03', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('5', 'aSuXCEfz', '2023-08-11 17:02:16', '2023-08-11 17:02:17', '20230811170216526k69gyy66ggk4ok', '003500TOP1A230811170216P876ac139c3200000', '6666000137506841', '6666000137445326', '0.01', NULL, NULL, '1', '2023-08-11 17:02:17', 'PT660169174453337142296', '1', '03', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('6', 'aSuXCEfz', '2023-08-11 19:31:31', '2023-08-11 19:31:31', '202308111931312022j37mg8v9u9e0t', '003000TOP2A230811193131P515ac139c0800000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('7', 'aSuXCEfz', '2023-08-11 19:31:57', '2023-08-11 19:31:57', '20230811193157083brroxat176tydd', '003000TOP3A230811193157P388ac139d2100000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('8', 'aSuXCEfz', '2023-08-11 20:05:45', '2023-08-11 20:05:45', '20230811200544957ypr7o2votrn2se', '003000TOP2B230811200545P282ac139d3100000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('9', 'aSuXCEfz', '2023-08-11 20:07:05', '2023-08-11 20:07:05', '20230811200705110y0u38sx53b5xal', '003000TOP3B230811200705P450ac139ffc00000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('10', 'aSuXCEfz', '2023-08-11 20:08:20', '2023-08-11 20:08:20', '20230811200820132sswzb272nj2wi0', '003000TOP2B230811200820P444ac139c0b00000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('11', 'aSuXCEfz', '2023-08-11 20:37:46', '2023-08-11 20:37:47', '20230811203746706aqf07cl33mty18', '003000TOP2B230811203747P042ac139d3100000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('12', 'aSuXCEfz', '2023-08-11 20:40:38', '2023-08-11 20:40:39', '20230811204038570xnuqh9fw6xpswi', '003000TOP3A230811204038P913ac139d2100000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('13', 'aSuXCEfz', '2023-08-11 20:52:31', '2023-08-11 20:52:31', '20230811205231207bqfqvpjey00f1q', '003000TOP1B230811205231P508ac139d2300000', '6666000137506841', NULL, '1.00', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('14', 'aSuXCEfz', '2023-08-11 21:06:58', '2023-08-11 21:06:58', '202308112106584726vwuche3zbpw86', '003000TOP1A230811210658P793ac139fed00000', '6666000137506841', NULL, '0.10', NULL, NULL, '0', '2023-08-11 00:00:00', NULL, NULL, '02', '受理成功'); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('15', 'aSuXCEfz', '2023-08-12 14:13:37', '2023-08-12 14:13:37', '20230812141337390lkdjyeyrx7fikx', NULL, '6666000137506841', NULL, '0.01', NULL, NULL, '1', '2023-08-12 14:13:37', 'PT165169182081430151681', '0', '04', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('16', 'aSuXCEfz', '2023-08-12 14:19:16', '2023-08-12 14:19:16', '20230812141916154td8n9uoybui7i5', NULL, '6666000137506841', NULL, '0.01', NULL, NULL, '1', '2023-08-12 14:19:16', 'PT733169182115211839356', '0', '04', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('17', 'aSuXCEfz', '2023-08-12 14:20:42', '2023-08-12 14:20:42', '20230812142042303m9mdslcq7sk5c7', NULL, '6666000137506841', NULL, '0.01', NULL, NULL, '1', '2023-08-12 14:20:42', 'PT569169182123609949023', '0', '04', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('18', 'aSuXCEfz', '2023-08-14 18:56:02', '2023-08-14 18:56:04', '20230814185604266i1kz02f2qax3ol', '003500TOP1B230814185604P605ac139c2c00000', '6666000137506841', '6666000137445326', '0.01', NULL, NULL, '1', '2023-08-14 18:56:04', 'PT580169201055792357039', '1', '03', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('19', 'aSuXCEfz', '2023-08-14 18:56:47', '2023-08-14 18:56:48', '202308141856475345uhlrj23rwrqzr', '003500TOP1A230814185647P851ac139c3200000', '6666000137506841', '6666000137445326', '0.03', NULL, NULL, '1', '2023-08-14 18:56:48', 'PT889169201060410062894', '1', '03', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('20', 'aSuXCEfz', '2023-08-14 19:53:13', '2023-08-14 19:53:12', '20230814195312707ydg3zzva0pzd2c', NULL, '6666000137506841', NULL, '0.01', NULL, NULL, '1', '2023-08-14 19:53:12', 'PT892169201399036312491', '0', '04', NULL); INSERT INTO `eb_huifu_wallet_trade` (`id`, `uni_id`, `create_time`, `update_time`, `req_seq_id`, `hf_seq_id`, `expend_account_no`, `income_account_no`, `amount`, `good_desc`, `remark`, `trade_status`, `trans_finish_time`, `business_partner_seq`, `business_code`, `trade_type`, `error_msg`) VALUES ('21', 'aSuXCEfz', '2023-08-14 20:18:32', '2023-08-14 20:18:32', '20230814201832486qui88s96t1s4x2', NULL, '6666000137506841', NULL, '0.01', NULL, NULL, '1', '2023-08-14 20:18:32', 'PT813169201550989539284', '0', '04', NULL); -- ---------------------------- -- Table structure for eb_huifu_wallet_translog -- ---------------------------- -- DROP TABLE IF EXISTS `eb_huifu_wallet_translog`; CREATE TABLE `eb_huifu_wallet_translog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户提现记录主键ID', `uni_id` varchar(64) DEFAULT NULL COMMENT '用户uni_id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `trans_id` varchar(64) DEFAULT NULL COMMENT '出金交易流水编号', `trans_date` varchar(8) DEFAULT NULL COMMENT '交易请求日期', `card_no` varchar(64) DEFAULT NULL COMMENT '银行卡号(掩码)', `card_name` varchar(64) DEFAULT NULL COMMENT '银行户名', `bank_code` varchar(20) DEFAULT NULL COMMENT '银行编码', `trans_amt` varchar(20) DEFAULT NULL COMMENT '交易金额（元）', `fee_amt` varchar(20) DEFAULT NULL COMMENT '手续费（元）', `trans_type` varchar(20) DEFAULT NULL COMMENT '交易类型:SURROGATE-银行卡代发、ENCHASHMENT-取现', `remark` varchar(128) DEFAULT NULL COMMENT '备注', `trans_stat` varchar(2) DEFAULT NULL COMMENT '交易状态', `trans_desc` varchar(255) DEFAULT NULL COMMENT '交易描述', PRIMARY KEY (`id`) USING BTREE, KEY `index_com_wallet_translog_uni_id` (`uni_id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='企业钱包账户提现记录'; INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('23', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP1A230811210658P793ac139fed00000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '0.10', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('24', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP1B230811205231P508ac139d2300000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('25', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP3A230811204038P913ac139d2100000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('26', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP2B230811203747P042ac139d3100000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('27', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP2B230811200820P444ac139c0b00000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('28', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP3B230811200705P450ac139ffc00000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('29', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP2B230811200545P282ac139d3100000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('30', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP3A230811193157P388ac139d2100000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('31', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP2A230811193131P515ac139c0800000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); INSERT INTO `eb_huifu_wallet_translog` (`id`, `uni_id`, `create_time`, `update_time`, `trans_id`, `trans_date`, `card_no`, `card_name`, `bank_code`, `trans_amt`, `fee_amt`, `trans_type`, `remark`, `trans_stat`, `trans_desc`) VALUES ('32', 'aSuXCEfz', '2023-08-15 13:45:10', '2023-08-15 13:45:10', '003000TOP2A230811154325P140ac139ced00000', '20230811', '3700020509245218394', '陕西众合保安服务有限公司', '1020000', '1.00', '0.00', '取现', '', '成功', '交易成功'); -- ---------------------------- -- Records of eb_system_config -- ---------------------------- INSERT INTO `eb_system_config` (`id`, `name`, `title`, `form_id`, `value`, `status`, `create_time`, `update_time`, `form_name`) VALUES ('1268', 'front_pay_callback_url', 'front_pay_callback_url', '0', 'https://pay.mall.baibaodun.cn', '0', '2023-02-20 09:52:13', '2023-07-24 14:55:48', '支付回调前端地址(域名)'); -- ---------------------------- -- Table structure for eb_bank_config -- ---------------------------- -- DROP TABLE IF EXISTS `eb_bank_config`; CREATE TABLE `eb_bank_config` ( `branch_code` bigint(20) unsigned NOT NULL COMMENT '支行联行号', `branch_name` varchar(100) DEFAULT NULL COMMENT '支行名称', `bank_code` int(12) NOT NULL COMMENT '银行号', `bank_name` varchar(100) DEFAULT NULL COMMENT '银行名称', PRIMARY KEY (`branch_code`,`bank_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='银行配置表'; -- ---------------------------- -- Table structure for temp_huifu_wallet_reconciliation -- ---------------------------- -- DROP TABLE IF EXISTS `temp_huifu_wallet_reconciliation`; CREATE TABLE `temp_huifu_wallet_reconciliation` ( `trade_serial_no` varchar(64) NOT NULL COMMENT '交易流水号', `create_time` datetime NOT NULL COMMENT '创建时间', `merchant_no` varchar(64) DEFAULT NULL COMMENT '商户号', `request_serial_no` varchar(64) DEFAULT NULL COMMENT '请求流水号', `trade_date` varchar(10) DEFAULT NULL COMMENT '交易日期', `trade_amount` varchar(20) DEFAULT NULL COMMENT '交易金额', `trade_status` varchar(6) DEFAULT NULL COMMENT '交易状态', `bank_trade_type` varchar(6) DEFAULT NULL COMMENT '银行交易类型', `trade_start_time` varchar(20) DEFAULT NULL COMMENT '交易订单创建时间', `trade_end_time` varchar(20) DEFAULT NULL COMMENT '交易订单完成时间', `expend_account_no` varchar(30) DEFAULT NULL COMMENT '出账方账号', `expend_account_name` varchar(100) DEFAULT NULL COMMENT '出账方户名', `expend_bank_code` varchar(20) DEFAULT NULL COMMENT '出账方银行编码', `income_account_no` varchar(32) DEFAULT NULL COMMENT '入账方账号', `income_account_name` varchar(100) DEFAULT NULL COMMENT '入账方户名', `incomed_bank_code` varchar(20) DEFAULT NULL COMMENT '入账方银行编码', `income_cer_no` varchar(64) DEFAULT NULL COMMENT '入账方证件号', `merchant_retain` varchar(128) DEFAULT NULL COMMENT '商户保留域', `remark` varchar(255) DEFAULT NULL COMMENT '交易备注', `service_charge` varchar(128) DEFAULT NULL COMMENT '手续费', PRIMARY KEY (`trade_serial_no`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='企业钱包对账'; -- ---------------------------- -- Records of eb_schedule_job -- ---------------------------- INSERT INTO `eb_schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron_expression`, `status`, `remark`, `is_delete`, `create_time`) VALUES ('25', 'WalletTradeTask', 'tradeDetail', NULL, '0 30 4 * * ?', '0', '每天4:30获取账务明细', '0', '2023-08-15 16:51:33'); INSERT INTO `eb_schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron_expression`, `status`, `remark`, `is_delete`, `create_time`) VALUES ('27', 'WalletTradeTask', 'reconciliationDetail', NULL, '0 15 4 * * ?', '0', '每天4:30定时获取对账单信息', '0', '2023-08-15 16:57:26'); INSERT INTO `eb_schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron_expression`, `status`, `remark`, `is_delete`, `create_time`) VALUES ('28', 'WalletTradeTask', 'translogDetail', NULL, '0 0 */1 * * ?', '0', '每小时获取提现记录', '0', '2023-08-15 17:02:11'); INSERT INTO `eb_schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron_expression`, `status`, `remark`, `is_delete`, `create_time`) VALUES ('30', 'ResidualTask', 'residualDetail', NULL, '0 0/3 * * * ?', '0', '3分钟跑一次待处理的任务列表', '0', '2023-08-15 16:57:26'); -- ---------------------------- -- Table structure for eb_js_pay_trade -- ---------------------------- -- DROP TABLE IF EXISTS `eb_js_pay_trade`; CREATE TABLE `eb_js_pay_trade` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户交易记录主键ID', `uni_id` varchar(32) NOT NULL DEFAULT '' COMMENT '用户uni_id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `req_seq_id` varchar(32) DEFAULT NULL COMMENT '请求流水号', `hf_seq_id` varchar(64) DEFAULT NULL COMMENT '全局流水号', `income_account_no` varchar(32) DEFAULT NULL COMMENT '入账方商户号', `outcome_account_no` varchar(32) DEFAULT NULL COMMENT '出账方商户号', `in_uni_id` varchar(32) DEFAULT NULL COMMENT '入账方用户id（退款）', `amount` decimal(10,2) DEFAULT NULL COMMENT '金额', `good_desc` varchar(256) DEFAULT NULL COMMENT '商品描述', `remark` varchar(256) DEFAULT NULL COMMENT '备注', `trade_status` varchar(6) DEFAULT NULL COMMENT '交易状态', `trans_finish_time` timestamp NULL DEFAULT NULL COMMENT '交易完成时间', `business_partner_seq` varchar(60) DEFAULT NULL COMMENT '业务交易流水号', `old_business_partner_seq` varchar(60) DEFAULT NULL COMMENT '原业务交易流水号', `business_code` varchar(20) DEFAULT NULL COMMENT '业务编码', `trade_type` varchar(255) DEFAULT NULL COMMENT '校验类型', `error_msg` varchar(255) DEFAULT NULL COMMENT '失败原因', `wx_data` varchar(1000) DEFAULT NULL COMMENT '聚合正扫微信拓展参数集合JSON', `alipay_data` varchar(1000) DEFAULT NULL COMMENT '支付宝扩展参数集合', `pay_info` varchar(1000) DEFAULT NULL COMMENT 'js支付信息', `qr_code` varchar(500) DEFAULT NULL COMMENT '二维码链接', PRIMARY KEY (`id`) USING BTREE, KEY `index_js_pay_trade_user_id` (`uni_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='C端交易记录'; CREATE TABLE `eb_task_residual` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `method_name` varchar(255) DEFAULT NULL COMMENT '方法名', `annotation` varchar(255) DEFAULT NULL COMMENT '注释', `class_name` varchar(255) DEFAULT NULL COMMENT '类名', `param_num` int(10) DEFAULT NULL COMMENT '参数个数', `param_type_arr` varchar(255) DEFAULT NULL COMMENT '参数类型数组', `param_value_arr` text COMMENT '参数值数组', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `is_nightly_run` varchar(10) DEFAULT NULL COMMENT '是否夜间执行', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务残留表';