/* Navicat Premium Dump SQL Source Server : 119.91.140.133-腾讯云 Source Server Type : MySQL Source Server Version : 80036 (8.0.36) Source Host : 127.0.0.1:3306 Source Schema : java3000 Target Server Type : MySQL Target Server Version : 80036 (8.0.36) File Encoding : 65001 Date: 08/04/2025 14:14:30 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for gig_config -- ---------------------------- DROP TABLE IF EXISTS `gig_config`; CREATE TABLE `gig_config` ( `config_id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `ent_code` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '企业三合一码', `protocol` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '协议', `gateway_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '网关域名', `subject_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '结算主体名称', `subject_type` int NOT NULL COMMENT '结算主体', `subject_location` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '结算税源地', `subject_channel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `app_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主体id', `merchant_private_key` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '私钥', `public_key` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '公钥', `location_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '所属地id', `sign_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '签名算法类型', `opt_flag` int NOT NULL DEFAULT 1 COMMENT '启用标记', `def_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '默认标记', `end_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '端类型', `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `modified_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `is_sign` tinyint NULL DEFAULT 0 COMMENT '需要签约', `agreement_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '需要签约的协议', `agreement_template` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '协议对应的模板编号', `enterprise_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '企业在爱签的account', `platform_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '平台在爱签的account', `is_file_type` tinyint NULL DEFAULT 0 COMMENT '文件类型 0 是协议 1是报告', `reception_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接包方企业在爱签的account (报告才有)', PRIMARY KEY (`config_id`) USING BTREE, INDEX `gig_config_ent_code`(`ent_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '结算主体配置信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gig_config -- ---------------------------- INSERT INTO `gig_config` VALUES (1, '91430181MA4RJ12345', 'https', 'test.taxhelpor.com:8883', '税邦云', 1, 'CICC', NULL, 'yytetsczy01', '7d301043970be6b51fd6a89cc245c936d72ea4ac3560585136d5dd8af10e06cb', '/Users/jimmy/Develops/publickey.pem', NULL, NULL, 0, 0, '0', '2022-03-03 23:52:47', '2025-03-31 11:43:52', 0, 'http://yunpang.hejusuan.com:9000/temp/65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034256Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ee0677d7687b1a2bffe1398704a14d5d6e81a451cdf0b264a6a49d1be87e0317', 'TNDEB87E0A82034A94A7719A2D6594EFB4', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', 0, NULL); INSERT INTO `gig_config` VALUES (2, '91430181MA4RJ12345', 'http', 'test.api.yeelsk.com', '易联数科', 3, 'DEF', NULL, 'M2020012219022635800001', 'MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC0FiXUcy/KxtlXQ1dfEW3lNuf/C90erX4AdCmF/ItueriwtHf0t9T+yDZTy1pwBKmj1N1pQeY/TkgTs8tEzANmuh6gY7/sO+K6SPohtWYrVIKuW3SCQQ6epd0EV7y6Fg/k0Adp8+EkSGE7XzI9DX8hAN6cY06iqjyHZOqCtjBwyhs1CAu7z8fMg3qN+Ymc2UIbN/JVHOu32xarx9SlXhkQbXjMNpfK9Kx1TURBOe+38iDy5sRaAlIjz38FCEI8uti7CeDqS6cwYk9neLWu3iUYE6OgpLOmtNrdcRYXr+PrUpD+3sL4M/7nFml5mGHgEr8vgbXNQ8o/SzVndbu3IATfAgMBAAECggEAcUqhn+abAVlZb5FYzOD9Hr8M8iF3iQ4h/40UdksrOGSR/fB6qoRfxa0UqGB8043LXtrSM56Wh+rqYyKv1Ob3mM+r5sD6A1alSwYP/dbNoKK415GHWU4uMVYtFcdQXkz00MCieWBImffC24QG6eust4mBgibjWGf6Tj8JXRPao4kg4kiZIyTHRqqNIXyJUlC/AjPSO5uGymulS9zb51ohAwTUpeSdcxHTmYa/OSkwNvbA+E/Jgj+AaONoT/FAoIh5W+u3Sz0CilZjZu7/sFv4fOvK7Cy/oNygK+d37DgpvO+mFU7YsAd0wTo40c9Ov0IWj8ZBbHyoxS+Y2P0WTXtIyQKBgQD37WPFnoj6csmy5RD/2QOUPikAbeCASamtRUiGkOJaUJF/7XtRAwLkcgbtfBDtP3Acvj4mkC6fyLwM0fqIY4gnvygFyX2OphSuwZS0YYfZiMVx4W1sS+tWXHQnlFWqP+KVB7Q+cPSAKleNAajNb1O7X6nEAdMuEI/JcemQelDqAwKBgQC580SOXdDUnmUBtabYhHgaqwNbF02Xhb+C8rtJm6oFKtUs1J12wWRbHP9Win4vd9AJJEFiCW2NCTIy+ZcIfVNjyD7zEjlTBDvx/jbelx+WLtGQVQvm/wNn7Py77BuRetkOe04SXDFAoN9cJ5zR47rDP88xydy6y4M/Jliha5qw9QKBgQDiNIrqnNoXwDG9cniPJt64G/rm9Fl4Uz1n5SXl+T087/PBB9mSsa+q5Uri1WbQQCg3YXBtWPHhQZIqFE+Er2Nj+Go41X0kcO3AAMl/xtjfJoYXgHmI7L/c/N/R2OpMOpuuI+hVbFP4uClHczMjtSZteDv5pTyb8+ps/uz+sEsxJwKBgQCumpDLJaiLnVe27T0Hnguw7tet1wnSt5IGgan/Ch3x0DBvcg2RjzKOo4HXXx/xro03qEWEqtmlTvdGCjsZi6Sb01HYqEoPe7BWIKChDkJooPnCjzkn5FjsYwlF5ARW7IWYJYw/jTXqO6TAQantI+sgn3AMjkGnXKWWzIj4ubN9aQKBgCijhRiuXRNtwupFgPYblsVMX/a2T1+RtZN6B+gGTW/8OezcReehhPXPq3KPodoVdzca3Xoeglb6RvePQnFb7dhcxCpfswqTNTA3lgjmVHad5LoJeYu3rP4TbyhgOXcDOo4XAnjaw0ZJVnrLRBE7piUZlqCPVuOOclI6P1K88kDv', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA3gHtYsued03fJ/+KLfeLHCPVVMyZN2lQRNcspxs6PoVWaSaXgn5ptPCcYFXcxWspiEjpzc2gF1tLtbI5wczn8ZcKW8O+JRC8UCQjZ1Rtk2gkPvEmHPRQh2vh/bLVpvtx0FOpZqvTJHT/UawoWEpwnR2DMeDFc+S8+XcrHrfRgcc+lR5CCPCBnYR5MeoCOfDVNcD7Kp+3YOkgAs1RkRiO6iI/AfbvlnS0nVte6gptF9gfqNe3SJKvIKbIW6o6TyrvWfECamnnm38bPcY0NgydGPFnkhNmF04LFrESNxb6YAPOpXZJ50QfSiLpYmCBXPza1SzlxoFfGwIFWL95HwxrUwIDAQAB', NULL, 'AES', 0, 0, '0', '2022-03-10 11:07:30', '2025-03-31 11:43:52', 1, 'http://yunpang.hejusuan.com:9000/temp/65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034256Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ee0677d7687b1a2bffe1398704a14d5d6e81a451cdf0b264a6a49d1be87e0317', 'TNDEB87E0A82034A94A7719A2D6594EFB4', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', 0, NULL); INSERT INTO `gig_config` VALUES (3, '91430181MA4RJ12345', 'https', 'test.taxhelpor.com:8883', '税邦云', 1, 'CICC', NULL, 'yytetsczy01', '7d301043970be6b51fd6a89cc245c936d72ea4ac3560585136d5dd8af10e06cb', '/Users/jimmy/Develops/publickey.pem', NULL, NULL, 0, 0, '0', '2022-03-03 23:52:47', '2025-03-31 11:43:53', 1, 'http://yunpang.hejusuan.com:9000/temp/65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034256Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ee0677d7687b1a2bffe1398704a14d5d6e81a451cdf0b264a6a49d1be87e0317', 'TNDEB87E0A82034A94A7719A2D6594EFB4', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', 0, NULL); INSERT INTO `gig_config` VALUES (4, '91430181MA4RJ12345', 'http', 'test.api.yeelsk.com', '易联数科', 3, 'DEF', NULL, 'M2020012219022635800001', 'MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQC0FiXUcy/KxtlXQ1dfEW3lNuf/C90erX4AdCmF/ItueriwtHf0t9T+yDZTy1pwBKmj1N1pQeY/TkgTs8tEzANmuh6gY7/sO+K6SPohtWYrVIKuW3SCQQ6epd0EV7y6Fg/k0Adp8+EkSGE7XzI9DX8hAN6cY06iqjyHZOqCtjBwyhs1CAu7z8fMg3qN+Ymc2UIbN/JVHOu32xarx9SlXhkQbXjMNpfK9Kx1TURBOe+38iDy5sRaAlIjz38FCEI8uti7CeDqS6cwYk9neLWu3iUYE6OgpLOmtNrdcRYXr+PrUpD+3sL4M/7nFml5mGHgEr8vgbXNQ8o/SzVndbu3IATfAgMBAAECggEAcUqhn+abAVlZb5FYzOD9Hr8M8iF3iQ4h/40UdksrOGSR/fB6qoRfxa0UqGB8043LXtrSM56Wh+rqYyKv1Ob3mM+r5sD6A1alSwYP/dbNoKK415GHWU4uMVYtFcdQXkz00MCieWBImffC24QG6eust4mBgibjWGf6Tj8JXRPao4kg4kiZIyTHRqqNIXyJUlC/AjPSO5uGymulS9zb51ohAwTUpeSdcxHTmYa/OSkwNvbA+E/Jgj+AaONoT/FAoIh5W+u3Sz0CilZjZu7/sFv4fOvK7Cy/oNygK+d37DgpvO+mFU7YsAd0wTo40c9Ov0IWj8ZBbHyoxS+Y2P0WTXtIyQKBgQD37WPFnoj6csmy5RD/2QOUPikAbeCASamtRUiGkOJaUJF/7XtRAwLkcgbtfBDtP3Acvj4mkC6fyLwM0fqIY4gnvygFyX2OphSuwZS0YYfZiMVx4W1sS+tWXHQnlFWqP+KVB7Q+cPSAKleNAajNb1O7X6nEAdMuEI/JcemQelDqAwKBgQC580SOXdDUnmUBtabYhHgaqwNbF02Xhb+C8rtJm6oFKtUs1J12wWRbHP9Win4vd9AJJEFiCW2NCTIy+ZcIfVNjyD7zEjlTBDvx/jbelx+WLtGQVQvm/wNn7Py77BuRetkOe04SXDFAoN9cJ5zR47rDP88xydy6y4M/Jliha5qw9QKBgQDiNIrqnNoXwDG9cniPJt64G/rm9Fl4Uz1n5SXl+T087/PBB9mSsa+q5Uri1WbQQCg3YXBtWPHhQZIqFE+Er2Nj+Go41X0kcO3AAMl/xtjfJoYXgHmI7L/c/N/R2OpMOpuuI+hVbFP4uClHczMjtSZteDv5pTyb8+ps/uz+sEsxJwKBgQCumpDLJaiLnVe27T0Hnguw7tet1wnSt5IGgan/Ch3x0DBvcg2RjzKOo4HXXx/xro03qEWEqtmlTvdGCjsZi6Sb01HYqEoPe7BWIKChDkJooPnCjzkn5FjsYwlF5ARW7IWYJYw/jTXqO6TAQantI+sgn3AMjkGnXKWWzIj4ubN9aQKBgCijhRiuXRNtwupFgPYblsVMX/a2T1+RtZN6B+gGTW/8OezcReehhPXPq3KPodoVdzca3Xoeglb6RvePQnFb7dhcxCpfswqTNTA3lgjmVHad5LoJeYu3rP4TbyhgOXcDOo4XAnjaw0ZJVnrLRBE7piUZlqCPVuOOclI6P1K88kDv', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA3gHtYsued03fJ/+KLfeLHCPVVMyZN2lQRNcspxs6PoVWaSaXgn5ptPCcYFXcxWspiEjpzc2gF1tLtbI5wczn8ZcKW8O+JRC8UCQjZ1Rtk2gkPvEmHPRQh2vh/bLVpvtx0FOpZqvTJHT/UawoWEpwnR2DMeDFc+S8+XcrHrfRgcc+lR5CCPCBnYR5MeoCOfDVNcD7Kp+3YOkgAs1RkRiO6iI/AfbvlnS0nVte6gptF9gfqNe3SJKvIKbIW6o6TyrvWfECamnnm38bPcY0NgydGPFnkhNmF04LFrESNxb6YAPOpXZJ50QfSiLpYmCBXPza1SzlxoFfGwIFWL95HwxrUwIDAQAB', NULL, 'AES', 0, 0, '0', '2022-03-10 11:07:30', '2025-03-31 11:43:53', 1, 'http://yunpang.hejusuan.com:9000/temp/5e7e19d379ac445e9e9c264b614ac8ff-%E6%8E%A8%E5%B9%BF%E6%8A%A5%E5%91%8A%E6%A0%B7%E4%BE%8B%281%29.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034347Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=de763ca098ccb03c18a9e260b8dadb52487d2ef425843ec502a917dc6c92a2f2', 'TN5CCDD899ED704721959F5185F6445547', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', 1, 'ASIGNTC016713MA5G6RHPXX'); INSERT INTO `gig_config` VALUES (5, '91430181MA4RJ12345', 'https', 'whtax-qa-api.lanmaoly.com', '自由职家', 2, 'DEF', NULL, '532434', '9b538114e1214b7d96fa04ffa5c88709', 'd6533c690a93420096a9bed231f82bcc', '1046000', 'HMAC_SHA_256', 0, 0, '0', '2022-03-10 11:13:58', '2025-03-31 11:43:54', 1, 'http://yunpang.hejusuan.com:9000/temp/5e7e19d379ac445e9e9c264b614ac8ff-%E6%8E%A8%E5%B9%BF%E6%8A%A5%E5%91%8A%E6%A0%B7%E4%BE%8B%281%29.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034347Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=de763ca098ccb03c18a9e260b8dadb52487d2ef425843ec502a917dc6c92a2f2', 'TN5CCDD899ED704721959F5185F6445547', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', 1, 'ASIGNTC016713MA5G6RHPXX'); -- ---------------------------- -- Table structure for smart_contract -- ---------------------------- DROP TABLE IF EXISTS `smart_contract`; CREATE TABLE `smart_contract` ( `contract_id` bigint NOT NULL AUTO_INCREMENT COMMENT '协议唯一标识，自增主键', `config_id` bigint NOT NULL, `contract_no` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '唯一协议编号(如:SC_年月日+流水号)', `contract_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '协议标题（前端展示用）', `preview_url` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '签约协议预览地址', `contract_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '协议的文件地址', `contract_status` tinyint NOT NULL DEFAULT 1 COMMENT '协议状态:1-待签署 2-签署中 3-已完成 4-已终止', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '协议创建时间', `expire_time` datetime NOT NULL COMMENT '签署截止时间', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间', `user_id` bigint NOT NULL COMMENT '发起用户', `user_account` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '用户在爱签ID', `enterprise_account` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '企业在爱签ID', `platform_account` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '平台在爱签的ID', `complete_time` datetime NULL DEFAULT NULL COMMENT '完成时间', `sign_info` json NULL, PRIMARY KEY (`contract_id`) USING BTREE, UNIQUE INDEX `contract_no`(`contract_no`) USING BTREE, INDEX `idx_status`(`contract_status`) USING BTREE, INDEX `idx_expire`(`expire_time`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = '智能合约主表，集成签约方预置与状态跟踪' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of smart_contract -- ---------------------------- INSERT INTO `smart_contract` VALUES (5, 2, 'CONTRACT-20250401-04286', '易联数科', 'https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJQZTA8DUooGTTu0ZtFNrYv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GOcpEXe0Pqq35leMmjEHsRQ?expired=10800000', 'http://yunpang.hejusuan.com:9000/temp/65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034256Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ee0677d7687b1a2bffe1398704a14d5d6e81a451cdf0b264a6a49d1be87e0317', 2, '2025-04-01 14:26:55', '2025-05-01 14:27:00', '2025-04-01 14:26:59', 2, '15776556654', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', NULL, '{\"status\": 2, \"signUser\": [{\"name\": \"赵顺宇\", \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"21cb417701214ec291ad4b11d78b511c\", \"account\": \"15776556654\", \"signType\": 2, \"userType\": 2, \"signOrder\": 1, \"signStatus\": 2, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-01 14:26:58\"}, {\"name\": \"赵顺宇\", \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"5030337bbfc34af58d6e97a7bbb30eeb\", \"account\": \"ASIGNTC960498MA5G6RHPX9\", \"signType\": 2, \"userType\": 1, \"signOrder\": 1, \"signStatus\": 2, \"companyName\": \"aqtest深圳要易云科技服务有限公司CX\", \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-01 14:26:59\"}], \"contractNo\": \"CONTRACT-20250401-04286\", \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJQZTA8DUooGTTu0ZtFNrYv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GPhBultPzIR-BIfvq43xpmU?expired=10800000\", \"pageSizeMap\": {\"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902\": 11}, \"contractName\": \"易联数科\", \"validityTime\": \"2025-05-01\", \"contractFiles\": [], \"signFinishedTime\": \"2025-04-01 14:26:59\"}'); INSERT INTO `smart_contract` VALUES (6, 3, 'CONTRACT-20250403-02431', '税邦云', 'https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJRbmTCbBviax96loAfOSEv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GMmGaqj9lHdgXwVzBuOFgVc?expired=10800000', 'http://yunpang.hejusuan.com:9000/temp/65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250331%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250331T034256Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ee0677d7687b1a2bffe1398704a14d5d6e81a451cdf0b264a6a49d1be87e0317', 2, '2025-04-03 15:49:45', '2025-05-03 15:49:53', '2025-04-03 15:49:52', 2, '15776556654', 'ASIGNTC960498MA5G6RHPX9', 'ASIGNTC741598MA5G6RHPX5', NULL, '{\"remark\": null, \"status\": 2, \"signUser\": [{\"name\": \"赵顺宇\", \"email\": null, \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"21cb417701214ec291ad4b11d78b511c\", \"status\": null, \"account\": \"15776556654\", \"signUrl\": null, \"authType\": null, \"bankCard\": null, \"serialNo\": null, \"signMark\": null, \"signType\": 2, \"userType\": 2, \"signOrder\": 1, \"createTime\": null, \"creditCode\": null, \"pwdSignUrl\": null, \"signStatus\": 2, \"companyName\": null, \"portVersion\": null, \"identifyTime\": null, \"identifyType\": null, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-03 15:49:50\"}, {\"name\": \"赵顺宇\", \"email\": null, \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"5030337bbfc34af58d6e97a7bbb30eeb\", \"status\": null, \"account\": \"ASIGNTC960498MA5G6RHPX9\", \"signUrl\": null, \"authType\": null, \"bankCard\": null, \"serialNo\": null, \"signMark\": null, \"signType\": 2, \"userType\": 1, \"signOrder\": 1, \"createTime\": null, \"creditCode\": null, \"pwdSignUrl\": null, \"signStatus\": 2, \"companyName\": \"aqtest深圳要易云科技服务有限公司CX\", \"portVersion\": null, \"identifyTime\": null, \"identifyType\": null, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-03 15:49:51\"}], \"signOrder\": null, \"contractNo\": \"CONTRACT-20250403-02431\", \"preserveNo\": null, \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJRbmTCbBviax96loAfOSEv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GMlv9ZXLpoe1wHOwFHgWiXM?expired=10800000\", \"embeddedUrl\": null, \"initiateUrl\": null, \"pageSizeMap\": {\"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902\": 11}, \"contractName\": \"税邦云\", \"validityTime\": \"2025-05-03\", \"contractFiles\": [], \"noSenceSignUsers\": null, \"signFinishedTime\": \"2025-04-03 15:49:51\"}'); -- ---------------------------- -- Table structure for ums_ext_api_his -- ---------------------------- DROP TABLE IF EXISTS `ums_ext_api_his`; CREATE TABLE `ums_ext_api_his` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID', `ext_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '第三方接口ID', `user_id` bigint NOT NULL COMMENT '用户ID', `api_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '接口名称', `request_data` json NULL COMMENT '请求数据', `response_data` json NULL COMMENT '响应数据', `status` tinyint NULL DEFAULT 1 COMMENT '状态：0-失败，1-成功', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 94 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = '接口调用历史表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of ums_ext_api_his -- ---------------------------- INSERT INTO `ums_ext_api_his` VALUES (1, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750, \"data\": null, \"requestId\": null}', 1, '2025-03-24 16:02:24'); INSERT INTO `ums_ext_api_his` VALUES (2, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750, \"data\": null, \"requestId\": null}', 1, '2025-03-24 16:02:28'); INSERT INTO `ums_ext_api_his` VALUES (3, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750}', 1, '2025-03-25 11:06:11'); INSERT INTO `ums_ext_api_his` VALUES (4, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"WURXySW1\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLPEoyrFzQfPMrLAbji5kdW4&secretAccessKey=P4QcIeK5AfCh8t6B5v8H6nTsOZNQmWUuYl9FvhC4Uao&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSENxusWIcD0OMvTpCvQskyYAQpLuIvwYYtNeIvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovMDNiMTdmNzlhYTg2NGM0ODhmMzdiYzUwYjZkZmUyNmNCBFVzZXJSIDAzYjE3Zjc5YWE4NjRjNDg4ZjM3YmM1MGI2ZGZlMjZjWAI.iFTpSEzesiqOCid__cEJkJq69weVLpmPd-1ooA5XYdKjWZHn-TlwCpKzrLWdc5eBoxHXxe7VWBll1WnJM3XGHw&bytedToken=20250325110612C6BCE9C3E0ED75FD6534&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26337020481869976897631%3ForderNo%3DVE230125199701233111742871972466\", \"serialNo\": \"PA10320250325110612878383\"}', 1, '2025-03-25 11:06:12'); INSERT INTO `ums_ext_api_his` VALUES (5, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750}', 1, '2025-03-25 11:08:13'); INSERT INTO `ums_ext_api_his` VALUES (6, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"D5kQoKfb\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLOPYwMo5h9TYla4BA7Q12cZ&secretAccessKey=ORaNmgOuawwxZKxy3flBYi54MG6HTXYkKZtvWU4GX9o&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEMFEk4cN9UkFq5A95cDszBcQnryIvwYYrtiIvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZTQzZTdkZDVmYTBjNGE0OGJkZWUyYTIxZjdhMTMwNmVCBFVzZXJSIGU0M2U3ZGQ1ZmEwYzRhNDhiZGVlMmEyMWY3YTEzMDZlWAI.rOP__t-4O9RGatPx6b3GTxMqKSqC5AEzzrD28qwdJyxzZDACMN2NuD41AYUkKb6NpDWPvvLbXZ2V1WebBOtNQw&bytedToken=20250325110814E988BF1CE4C3E4FDBD5E&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26337142511322067853139%3ForderNo%3DVE230125199701233111742872094493\", \"serialNo\": \"PA10320250325110814828640\"}', 1, '2025-03-25 11:08:14'); INSERT INTO `ums_ext_api_his` VALUES (7, '213417306', 4, '个人运营商三要素比对', '{\"mobile\": \"18933274128\", \"authMode\": 1, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素认证\", \"result\": 0, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PA10120250325114348595022\", \"identifyUrl\": \"\"}}', 1, '2025-03-25 11:43:48'); INSERT INTO `ums_ext_api_his` VALUES (8, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"4kgNBumn\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLL4MPT7UecVxwstHCewH6G5&secretAccessKey=ODY5n5glWkMN7VXOrUTQZuQB7lRurgE1SvA6cfvJMrZ&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEFN2FaZ9WUkmg41ni0C_NJUQ9cyIvwYYhemIvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovNDFlOTg2YWZmNjE4NDEwNGI1NDgwOTEwYjc3NDEzM2ZCBFVzZXJSIDQxZTk4NmFmZjYxODQxMDRiNTQ4MDkxMGI3NzQxMzNmWAI.VbeuSEh8MGrv3JPkQPRUPnk5IFol57MeZzsg0bPC0MHhH4xdX8wlPu2Uxu5vHu2kIroF_KhLup-zxjWSXV97Vw&bytedToken=20250325114349F71D0E490105F205025A&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26339277347836330300062%3ForderNo%3DVE511322199205103651742874229331\", \"serialNo\": \"PA10320250325114350700493\"}', 1, '2025-03-25 11:43:49'); INSERT INTO `ums_ext_api_his` VALUES (9, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750}', 1, '2025-03-25 13:34:25'); INSERT INTO `ums_ext_api_his` VALUES (10, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人运营商三要素认证]信息核验失败，请检查信息是否正确\", \"code\": 100750}', 1, '2025-03-25 13:34:29'); INSERT INTO `ums_ext_api_his` VALUES (11, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 13:34:32'); INSERT INTO `ums_ext_api_his` VALUES (12, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 13:55:49'); INSERT INTO `ums_ext_api_his` VALUES (13, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:00:57'); INSERT INTO `ums_ext_api_his` VALUES (14, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"jGe8JFfC\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLP7QRjx50GjaZ97QYlSnnuU&secretAccessKey=uj4b9kQ8IXNCpj6J7CFfVwX1tklcDOao7MJalZlbIPB&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSENiDVrQwiUwZpSc2AFPi00oQmo2JvwYYqqmJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovMjZlMTNlMWZmNjQ0NDQ5YWJiYTExODIzMDUwMDBlMGJCBFVzZXJSIDI2ZTEzZTFmZjY0NDQ0OWFiYmExMTgyMzA1MDAwZTBiWAI.SX-VdIt8sJZphV94kGcisBLqyBOsh7S00RbY9Ep_kG0HyFe-uHJfFd0WL7CwFjhLpd7lefbKwUBmclNz2gg08w&bytedToken=20250325140058B3D1331EFA1394201FCF&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347506740505288800074%3ForderNo%3DVE230125199701233111742882458724\", \"serialNo\": \"PA10320250325140059050546\"}', 1, '2025-03-25 14:00:58'); INSERT INTO `ums_ext_api_his` VALUES (15, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:01:30'); INSERT INTO `ums_ext_api_his` VALUES (16, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"hgGrLXKM\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLKMFkPqS8Ktfl4c6tZ6qDRZ&secretAccessKey=eC6UTWajbFRseY378lmkACFfY7tLS7w36r09isYAvuE&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEDwWKGqwQEvejrWjpjTZSQEQu42JvwYYy6mJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovMDkyN2NlODA2ZTBhNDA4OWJjNTYyZTgxMmNlMmU1NDBCBFVzZXJSIDA5MjdjZTgwNmUwYTQwODliYzU2MmU4MTJjZTJlNTQwWAI.f18cdlu69q2C08IhqCInF8L6WmBg56q5j9EVqwbjEvtjIry89u_MOg9KZ4yYan45_N1uxmLG3pj0kvIJvqo4gg&bytedToken=20250325140131353550C944F51520C8CE&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347539220690015173029%3ForderNo%3DVE230125199701233111742882491213\", \"serialNo\": \"PA10320250325140131614993\"}', 1, '2025-03-25 14:01:31'); INSERT INTO `ums_ext_api_his` VALUES (17, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:01:59'); INSERT INTO `ums_ext_api_his` VALUES (18, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"1WVER8xd\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLN7EJEqYNcuMf0kJXhKO2hP&secretAccessKey=i9h3Xm2cSv4auNIUJ9mI5jXkh1238TbGzCSN1GpGWBB&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEJayEgZeSU7movHcrzm66GsQ2I2JvwYY6KmJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovNjI5OGYwYjQ3YWNiNGI5ODk0Yjg0NzE1MzFhNTEyMjdCBFVzZXJSIDYyOThmMGI0N2FjYjRiOTg5NGI4NDcxNTMxYTUxMjI3WAI.cEF9LQPFtOzfh2VUejmcRqZmiE7KMwUdOujpW7nyYemA4uSED-Tu3nrqG-ohA1Tm_MbiJO8V_XxtoqbPy6GpiQ&bytedToken=202503251402003018D5A2DDC5A41FFC81&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347568406401371537564%3ForderNo%3DVE230125199701233111742882520394\", \"serialNo\": \"PA10320250325140200823594\"}', 1, '2025-03-25 14:02:00'); INSERT INTO `ums_ext_api_his` VALUES (19, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:05:27'); INSERT INTO `ums_ext_api_his` VALUES (20, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"yid2aQpz\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLLCb4JmHLH4qZ5WrhuW6PVF&secretAccessKey=GADfKm2zXr5cQnuTHMe64Od4fLGLUkObYSmoR3tyT70&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEFfTfzSmp0TOu5CuQ3d83gUQqI-JvwYYuKuJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovOGU1ZmE4OWZiMjllNGFlNmFhY2YxZTI0OGE0MmUyZThCBFVzZXJSIDhlNWZhODlmYjI5ZTRhZTZhYWNmMWUyNDhhNDJlMmU4WAI.hOa1IVdXaZei0GJGM7z5wjkAL6pasmiKKdH2nztVWGfCKq8O8U1dxFofl0kzW0RS70KKHjz1Myhs7OfiHSon8Q&bytedToken=20250325140528E85C32AF598F572002B9&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347776415598587551778%3ForderNo%3DVE230125199701233111742882728401\", \"serialNo\": \"PA10320250325140528679496\"}', 1, '2025-03-25 14:05:28'); INSERT INTO `ums_ext_api_his` VALUES (21, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:06:56'); INSERT INTO `ums_ext_api_his` VALUES (22, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"BkOjAU5q\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLNKUdy63NqN6LmPRt1O7kRh&secretAccessKey=ZQE5uS1r1ORxpmmKbgZDn2FhVCLArxHyYjmUKayQMsB&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEJ25e-2aJUZTs8NF0-lUENUQgZCJvwYYkayJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovYjUyMmVhNzE3ZWY1NDUxNmE4NDlkYjc2ODg0Zjc2YmRCBFVzZXJSIGI1MjJlYTcxN2VmNTQ1MTZhODQ5ZGI3Njg4NGY3NmJkWAI.GwbxsIb4Uq23FoT7JNwrHC6BxMvSuTkUIcYnp6vdH-GfCKIvYP_xVfoLhSSqyh7Ihlei66FEh9jb0uf_pstPEQ&bytedToken=20250325140657C6BCE9C3E0ED7521F5B4&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347865148483662793470%3ForderNo%3DVE230125199701233111742882817135\", \"serialNo\": \"PA10320250325140657585129\"}', 1, '2025-03-25 14:06:56'); INSERT INTO `ums_ext_api_his` VALUES (23, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:07:19'); INSERT INTO `ums_ext_api_his` VALUES (24, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"7Jg764EF\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLNMpbN5ViNmKizNPOc7tJ2b&secretAccessKey=0qNlSDiMno8SGlS8n7iGaoOBRfkPJw1yWSaMKzEuJ6D&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEJ72rZ7qpkAOhgPNLp_5U2UQl5CJvwYYp6yJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZDdiMTI2NjQ2ZjU5NDJiOWFkYWQ5OTI3NGRmODlkZDJCBFVzZXJSIGQ3YjEyNjY0NmY1OTQyYjlhZGFkOTkyNzRkZjg5ZGQyWAI.l3Yi5QgZAtuWw2qnlZN-G69QxVDZQtXf0z7Fwov6LjByn8nPuNAzS2VlkOZIkbx_PnR-r1s_v50MK0K-M4P01g&bytedToken=2025032514072001FE92C9DB4C70252503&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26347887757354884546969%3ForderNo%3DVE230125199701233111742882839747\", \"serialNo\": \"PA10320250325140720117733\"}', 1, '2025-03-25 14:07:19'); INSERT INTO `ums_ext_api_his` VALUES (25, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:09:35'); INSERT INTO `ums_ext_api_his` VALUES (26, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"LoGcUkzH\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLK5Q0yf0rcUn584eqGg2aGR&secretAccessKey=ThVaCGmAEdRdZPggk5MMcIY57SiNGm0wKyz6vRNXx1i&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEDMqSO262UjlqTd4Nopt8BsQoJGJvwYYsK2JvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovOTE1ZTZjODY5YzNkNGYxNThmNzVlMGM5MzQ1NjEzODlCBFVzZXJSIDkxNWU2Yzg2OWMzZDRmMTU4Zjc1ZTBjOTM0NTYxMzg5WAI.sr9lf_WQQW5yVHuZ1iFPaSRpOSVGcENb7UC2ueHAxiK3it_n-yc5K1i_idmGIOiy1WiN5K_0jixOEhOQlhgXAQ&bytedToken=20250325140936B9F44133F2C675224130&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26348024525242485610214%3ForderNo%3DVE230125199701233111742882976504\", \"serialNo\": \"PA10320250325140936907180\"}', 1, '2025-03-25 14:09:36'); INSERT INTO `ums_ext_api_his` VALUES (27, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:10:18'); INSERT INTO `ums_ext_api_his` VALUES (28, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"MtgwnL0I\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLJHuVZJSWAnnezKOevTNdfT&secretAccessKey=fkamvpzn5W5yXfoWsU42CCr5EJIIV7gB6TTcDHq3nvk&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEBjtqLXNrkNil1UiUK8-vp8Qy5GJvwYY262JvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovNDVlNmNiNzA1ZDZjNDhhNDkxOTAzMDJkY2EwYTE0MDFCBFVzZXJSIDQ1ZTZjYjcwNWQ2YzQ4YTQ5MTkwMzAyZGNhMGExNDAxWAI.4xMANY48BBJvQX4jacgasUj-dWxL8X6URSL0-13KdbGjanQ6HxgvrUW05e88PUg2XmaJqPDK7GqSRzseRdtCKg&bytedToken=202503251410198C950C8DF342B5235296&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26348066931644388604069%3ForderNo%3DVE230125199701233111742883018919\", \"serialNo\": \"PA10320250325141019244538\"}', 1, '2025-03-25 14:10:18'); INSERT INTO `ums_ext_api_his` VALUES (29, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:10:27'); INSERT INTO `ums_ext_api_his` VALUES (30, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"Dz9R4YKQ\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLKunQq4JLECOWwEXPYigo7J&secretAccessKey=HVzf7fJk6jeL02dhauXklD87RDMyxnrzFP0Odyma3KH&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEE5kiyaQBUUXsHW7_Y-WQ30Q1JGJvwYY5K2JvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZTQ4MTc3NWRmZDVjNDJkODhiYTAxNDMwODM5NzE5MzVCBFVzZXJSIGU0ODE3NzVkZmQ1YzQyZDg4YmEwMTQzMDgzOTcxOTM1WAI.mVQqlce1I16pb0I85-G6FGAMWZe7ipD5mrRCdWh-Eah49vapABpE3Q4E3c5iFMWYlND9k2Ev0Kp2G68i3U6EqQ&bytedToken=202503251410283CBC104F37DC2C253427&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26348076510727791496998%3ForderNo%3DVE230125199701233111742883028491\", \"serialNo\": \"PA10320250325141028818845\"}', 1, '2025-03-25 14:10:28'); INSERT INTO `ums_ext_api_his` VALUES (31, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:23:45'); INSERT INTO `ums_ext_api_his` VALUES (32, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"iR9PMsn6\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLOTPeABKUaO0Wk81VgEF4qZ&secretAccessKey=kG8AGy1P0icbIIrVvERSRmcQkUYtDsee3nRrulKaWPJ&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEMNO6IVGCUnFmt8eEATnfDMQ8peJvwYYgrSJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZjBjYmE2NWNlZmEwNGZiZGJiMDVkMzg1MjI5YjZiZjlCBFVzZXJSIGYwY2JhNjVjZWZhMDRmYmRiYjA1ZDM4NTIyOWI2YmY5WAI.Y1Fas_nTNfRIyyxzovjRCG1UYt6lV_pQLLLJ_hKR3CH-XRMfCuzqKyy_QIOBd5yE4D07VyCAxcgkGmI1AOg8Ig&bytedToken=2025032514234650D6717EC9A05E238D76&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26348874263120111681870%3ForderNo%3DVE230125199701233111742883826250\", \"serialNo\": \"PA10320250325142346716182\"}', 1, '2025-03-25 14:23:46'); INSERT INTO `ums_ext_api_his` VALUES (33, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:24:26'); INSERT INTO `ums_ext_api_his` VALUES (34, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:25:16'); INSERT INTO `ums_ext_api_his` VALUES (35, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:25:34'); INSERT INTO `ums_ext_api_his` VALUES (36, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:25:42'); INSERT INTO `ums_ext_api_his` VALUES (37, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:26:18'); INSERT INTO `ums_ext_api_his` VALUES (38, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:27:22'); INSERT INTO `ums_ext_api_his` VALUES (39, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:27:32'); INSERT INTO `ums_ext_api_his` VALUES (40, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:27:41'); INSERT INTO `ums_ext_api_his` VALUES (41, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:03'); INSERT INTO `ums_ext_api_his` VALUES (42, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:13'); INSERT INTO `ums_ext_api_his` VALUES (43, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:25'); INSERT INTO `ums_ext_api_his` VALUES (44, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:39'); INSERT INTO `ums_ext_api_his` VALUES (45, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:43'); INSERT INTO `ums_ext_api_his` VALUES (46, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:46'); INSERT INTO `ums_ext_api_his` VALUES (47, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"19833831153\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]请勿重复调用\", \"code\": 101053}', 1, '2025-03-25 14:28:53'); INSERT INTO `ums_ext_api_his` VALUES (48, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"DeF5OPIi\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLL8pWGtKaFmqF4LaO2G7cUM&secretAccessKey=SlETDGAywmZGb7hPhblYoxV8UqMQdZLnGguygPVSbbw&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEFXUcyuSXU6ro3qHEhdjXHoQqp6JvwYYurqJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZDIyOWE2OTY0NDQ4NDg1ZWI0M2Y0NmIxNGM1MzA3NmVCBFVzZXJSIGQyMjlhNjk2NDQ0ODQ4NWViNDNmNDZiMTRjNTMwNzZlWAI.JJtwWPmj0VgiETPML0UxOWroxvo0EhvLU9hNSvTWGuRJIelN4BYHfXNCEOH2vKuhwAjqMoyy3vfUQtPyrb_D3g&bytedToken=20250325143730882FAACC9595D226C69E&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26349697908053715796835%3ForderNo%3DVE230125199701233111742884649888\", \"serialNo\": \"PA10320250325143730668665\"}', 1, '2025-03-25 14:37:29'); INSERT INTO `ums_ext_api_his` VALUES (49, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"8ftxDLom\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLM3ngjWduZiGVbQh2rsZUOz&secretAccessKey=mYIwxEaxc3QOKkL33bKxKuNcM88OyqdV7nga8SyAoSR&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEHQFdnTy3k24ph2bSp4myC0Qqp6JvwYYurqJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovN2FkZTVlYTIwZDNjNDkxM2JkOGFmOTU2NzgyYjI2MGVCBFVzZXJSIDdhZGU1ZWEyMGQzYzQ5MTNiZDhhZjk1Njc4MmIyNjBlWAI.xiOP7Ddb51GUXK5kJobSLyoGNQuQ_-lVTDuSqEKJZ7_da47kBvStrDTC_CeIN4qkc4k95nU4S6zuGt09UpD-jg&bytedToken=202503251437302CF8865444A25A24B77B&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26349698720363001662901%3ForderNo%3DVE230125199701233111742884650704\", \"serialNo\": \"PA10320250325143731061403\"}', 1, '2025-03-25 14:37:30'); INSERT INTO `ums_ext_api_his` VALUES (50, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"XYbIvSBX\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLMlW6ihZHrT1NSgixYclDae&secretAccessKey=KGNDM4SmG5ywlP2nCtazMiW3qPDb9nvFkV6UtuhwPr7&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEIswV2dQNE2Uv8Zfn7aTjHwQ5p6JvwYY9rqJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovMDgyNDk2OTllZjE3NDNlZDliYjhiM2JlN2YxZDYyNjFCBFVzZXJSIDA4MjQ5Njk5ZWYxNzQzZWQ5YmI4YjNiZTdmMWQ2MjYxWAI.5OComg1l0lJv45tdaYpVUSJZF0htVYtKsEydOMfNxcrrGkW9qRgTap--WAy5W1DNKDUXTZX-vCbFZXGPdmzIZQ&bytedToken=20250325143830C051C035F5E25A26DDE3&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26349758041718647357814%3ForderNo%3DVE230125199701233111742884710023\", \"serialNo\": \"PA10320250325143830352034\"}', 1, '2025-03-25 14:38:29'); INSERT INTO `ums_ext_api_his` VALUES (51, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"0EuFeqs7\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLKtJUicPxF863TGyocGwicX&secretAccessKey=LU3h8SEi1N1LELN0X7vmbFi4BIbiuNP5hdkKQGhbRD6&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEE2bXj6FKUvksIUti89XnvUQtKSJvwYYxMCJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovMTQ3YjdhMTcyOGMxNGQ0ZDlkMzA1N2I1ZTA4NzBjNTJCBFVzZXJSIDE0N2I3YTE3MjhjMTRkNGQ5ZDMwNTdiNWUwODcwYzUyWAI.mYLiI46gy3wVzsTIT1rDOUjGv22W7wWeIV7VfxxsfFc1PHeBl7XzdkdKQro59osVqk0NHdFdVhME7ZIst8iuyA&bytedToken=20250325145029F460BC31B0311D274D8D&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26350476850531956221920%3ForderNo%3DVE230125199701233111742885428837\", \"serialNo\": \"PA10320250325145029249741\"}', 1, '2025-03-25 14:50:28'); INSERT INTO `ums_ext_api_his` VALUES (52, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"WzgnuVW9\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7353184621079281680&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLMM7ck0HJLH29RPnybzxlOA&secretAccessKey=F6KamASy7pyliZNvVCtFZeUux5F9M85ZvPrBMpVCoiO&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEH27F3hGLE8urG9RkEsYX24Q6aaJvwYY-cKJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovYjE5MTUwY2RhNDJhNGFiMDgwNzNjNGFhNjU0NDU3OGZCBFVzZXJSIGIxOTE1MGNkYTQyYTRhYjA4MDczYzRhYTY1NDQ1NzhmWAI.vlhf9-ihHA7-3FgOyaQvl_6NEx1S3rIJ4lzgrnmsSlVghB2ZeQkzPDmGhYmUNVE_MgmSSqZR0JljueiRl82ITA&bytedToken=202503251455378199EC57D9C5BE2C6039&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26350785675740429618707%3ForderNo%3DVE230125199701233111742885737654\", \"serialNo\": \"PA10320250325145537958540\"}', 1, '2025-03-25 14:55:37'); INSERT INTO `ums_ext_api_his` VALUES (53, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"CFRqyxDh\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLJiUe43p09ljXewHAR8FmQ6&secretAccessKey=7tkJxj779kPw0ohwFWMYyW0mhIQrjob9Dwzt5lCP9nH&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSECcEE2Gf1EXPk_FyygraHLoQqKiJvwYYuMSJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZDQ5MzBiYzIzOGI5NDM1Mjk5MjQ1OTM5ZjRiM2NmNTRCBFVzZXJSIGQ0OTMwYmMyMzhiOTQzNTI5OTI0NTkzOWY0YjNjZjU0WAI.IBdC_ciXbEYoJPuhXpmbOsDDlYo9Mb7Ms2KPPBa6IO5P0ugRdKVZ7I6FouplOUl5Atf0KAgCZReZ9_qZ78q_PQ&bytedToken=202503251458487B4910485D6F8228F151&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26350976019265691040866%3ForderNo%3DVE511322199205103651742885928000\", \"serialNo\": \"PA10320250325145849184768\"}', 1, '2025-03-25 14:58:47'); INSERT INTO `ums_ext_api_his` VALUES (54, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"jsHwKSLZ\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLNWqaEwyctTijmec6Lwwinx&secretAccessKey=lQdCmuhY313KOGPweGbSs0UBHFARYFcz52JZcBC0O0N&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEKRFfyL0OkvYipwyH2oPXHkQuKiJvwYYyMSJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZjMxZTA3NzRjODAwNGRkOGJlYTk2MTBkN2I4YTE2YmZCBFVzZXJSIGYzMWUwNzc0YzgwMDRkZDhiZWE5NjEwZDdiOGExNmJmWAI.trCpFypxrcCx1UiOLBl-hT_tuv6d9pTAqgkIwsL2Ws0wMtI12XoHvGVXRUgn_6rJzjg-wEcc64zVJvAtVKIeAQ&bytedToken=20250325145904155BF2780F9941285E7A&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26350992503946288170333%3ForderNo%3DVE511322199205103651742885944485\", \"serialNo\": \"PA10320250325145905128377\"}', 1, '2025-03-25 14:59:04'); INSERT INTO `ums_ext_api_his` VALUES (55, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"m5pHuJfg\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLPhCKNSDhn8MG2EewmB500Q&secretAccessKey=8EA1EZFHcdCbhMLrY9El54J5d81NMvmcYNzU9qnv1Ur&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEOt4dPqJb0AmoxSgqnxrZiIQ066JvwYY48qJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovYmQyODllZjY2ZjZmNDY2MTliMTc0NDk1NjRjYjU0Y2JCBFVzZXJSIGJkMjg5ZWY2NmY2ZjQ2NjE5YjE3NDQ5NTY0Y2I1NGNiWAI.xb0GHkl5gWZ4d1qT0QJqGKi4DSTs73jqX60gywDbkWCP4pmyUVNEhESVnQ4ibWB0VB5HHDd4BJf7ouqNbCtMvQ&bytedToken=20250325151219C2D2DA97207045294A9A&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26351787400332484813804%3ForderNo%3DVE511322199205103651742886739383\", \"serialNo\": \"PA10320250325151220362882\"}', 1, '2025-03-25 15:12:19'); INSERT INTO `ums_ext_api_his` VALUES (56, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"hutqt5br\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLQ5HxATL2GWXX5XkgWY0eX5&secretAccessKey=4CuCA3PwSI8UUmaFo7R3cLyzApN64o7a8Tl1OAI4eME&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEPg8xnkinUuGkO5drif_1UMQ3q-JvwYY7suJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovYTU3YWU4NTYxZjFiNDkxYjg1NThiMDcyNjJjNTNjZGNCBFVzZXJSIGE1N2FlODU2MWYxYjQ5MWI4NTU4YjA3MjYyYzUzY2RjWAI.I5tyYH5B0HP4XPS_JY3l-kUiZPKAIA9RMSWasOURTDfRUyHSpbAsHGWOJ9zejYKDatjXK2_rHgVZeAYh-mDKKw&bytedToken=20250325151438C924070CED2DB72D02DC&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26351925823949945499565%3ForderNo%3DVE511322199205103651742886877802\", \"serialNo\": \"PA10320250325151438855531\"}', 1, '2025-03-25 15:14:37'); INSERT INTO `ums_ext_api_his` VALUES (57, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"CG7e5pCg\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLLf3C6VJjM02lnAWuoM7CX4&secretAccessKey=kpnFQOuuCi8Sk4kxWiFVaNXcViAx6sAeUPFQWdFdetg&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEGbnt5Yj5U0tpu_RiPMBdhoQ36-JvwYY78uJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZGRkMGQyYThjOGVjNGU5ZGE3NmI4MDZkOWVhMzMyNWNCBFVzZXJSIGRkZDBkMmE4YzhlYzRlOWRhNzZiODA2ZDllYTMzMjVjWAI.pQ5GLH7plhk9NjKfpRV6yw97RH19cer2vz0sXrteXC0JOsmYHGEdvXaLGpiSDWHAfsBIdy6wwnka-adPPYc3iQ&bytedToken=20250325151439FE84FAFBA6075F2E0491&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26351927212710290060578%3ForderNo%3DVE511322199205103651742886879198\", \"serialNo\": \"PA10320250325151440557288\"}', 1, '2025-03-25 15:14:39'); INSERT INTO `ums_ext_api_his` VALUES (58, '213417306', 4, '查询人脸核身结果', '{\"msg\": \"认证成功\", \"code\": 100000, \"bizId\": \"CG7e5pCg\", \"serialNo\": \"PA10320250325151440557288\"}', '{\"msg\": \"人脸认证成功\", \"status\": 2}', 1, '2025-03-25 15:15:03'); INSERT INTO `ums_ext_api_his` VALUES (59, '213417306', 4, '添加个人用户（V2）', '{\"mobile\": \"18933274128\", \"account\": \"18933274128\", \"signPwd\": \"18933274128\", \"scalling\": 0.75, \"serialNo\": \"PA10320250325151440557288\", \"creditType\": 1}', '{\"msg\": \"[test]用户已存在\", \"code\": 100021, \"data\": {\"idCard\": \"\", \"sealNo\": \"\", \"account\": \"18933274128\", \"sealUrl\": \"\", \"sealName\": \"\", \"userType\": null, \"isDefault\": null}}', 0, '2025-03-25 15:15:04'); INSERT INTO `ums_ext_api_his` VALUES (60, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"Q7zJp08w\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLQ7F6T6M7GA0IGEqwpU4zOI&secretAccessKey=VxhbgM5ZUMqfmxmH1YwwJ0bfnkYCUxObutT3TYTOz2w&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEPlF337jNE1AgV9oWd06l7YQ3LuJvwYY7NeJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovY2Q1MTg0MDFiMDBiNDc1Nzk3YTZhM2YzMDYxMDUyMjJCBFVzZXJSIGNkNTE4NDAxYjAwYjQ3NTc5N2E2YTNmMzA2MTA1MjIyWAI.Qgg4PpNjRPmElGbwjgvvHTF4-BHxU15yrczUSjUfbwY-XYNpeUkL-MMYEP-NY86z1zVMmfGgTUZXbWHRzFW3sQ&bytedToken=20250325154013C924070CED2DB731D992&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26353460855983465281947%3ForderNo%3DVE511322199205103651742888412837\", \"serialNo\": \"PA10320250325154013935805\"}', 1, '2025-03-25 15:40:12'); INSERT INTO `ums_ext_api_his` VALUES (61, '213417306', 4, '个人运营商三要素比对', '{\"mobile\": \"18933274128\", \"authMode\": 1, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素认证\", \"result\": 0, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PA10120250325154058041495\", \"identifyUrl\": \"\"}}', 1, '2025-03-25 15:40:57'); INSERT INTO `ums_ext_api_his` VALUES (62, '213417306', 4, '个人人脸活体认证', '{\"bizId\": \"NpNaNkdQ\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLKVhAGxM9smMA1HIHZcMyBc&secretAccessKey=cf35MaoiSvPTDTmDhWxN9LVjM4BdrFsdBdsK12TOSdS&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEEEXJ4YkfkvkvXLzHmcmBVAQxb2JvwYY1dmJvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZDg5ZGI3ZTZkZjcxNDQ3ZWJlYTgwYTc5OWE2NjY0ZjdCBFVzZXJSIGQ4OWRiN2U2ZGY3MTQ0N2ViZWE4MGE3OTlhNjY2NGY3WAI.WXhv7iNZAlqkFYFvNqnNZw6I_Nu7P7CvM6H8Ka4d3aHUDdKC1JfqbX6n3BR1B0Vnbl-mdiPIZdJreJC_F70c4g&bytedToken=202503251544062427AE1AE15BE732FD78&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26353693790638910262348%3ForderNo%3DVE511322199205103651742888645767\", \"serialNo\": \"PA10320250325154406722791\"}', 1, '2025-03-25 15:44:05'); INSERT INTO `ums_ext_api_his` VALUES (63, '213417306', 4, '个人运营商三要素比对', '{\"mobile\": \"18933274128\", \"authMode\": 1, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素认证\", \"result\": 0, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PA10120250325154429109895\", \"identifyUrl\": \"\"}}', 1, '2025-03-25 15:44:28'); INSERT INTO `ums_ext_api_his` VALUES (64, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"JBHhJLpX\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLOMQKs7Vr7lFXqpB4lwIrjj&secretAccessKey=ItlNhEVxgKHMuKI3jmFJiS9kpCt4T1ETHg7oHkLZ716&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEL-avxoKY0nqrdv6yJ9lKJcQzoOuvwYY3p-uvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZTg0OGJlZTlhNjE4NDRiNjhjMTdkMmZhMzNhYjBmYzRCBFVzZXJSIGU4NDhiZWU5YTYxODQ0YjY4YzE3ZDJmYTMzYWIwZmM0WAI.9DPK89KA_rNuYs1DCQnXTaVg-kCpht0eIaByUtDwabFdKIKZ6dU8RR4CJMPpaZSU27rPwCFB-o-gyPh9RpMTbQ&bytedToken=20250401140358D9F55B48C7F35B5D7F34&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26952485945527713490131%3ForderNo%3DVE230125199701233111743487437919\", \"serialNo\": \"PA10320250401140358484683\"}', 1, '2025-04-01 14:03:57'); INSERT INTO `ums_ext_api_his` VALUES (65, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素比对\", \"result\": 1, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PV20220250401140420757024\", \"identifyUrl\": \"\"}}', 1, '2025-04-01 14:04:20'); INSERT INTO `ums_ext_api_his` VALUES (66, '213417306', 2, '个人银行卡四要素比对', '{\"mobile\": \"15711007949\", \"authMode\": 1, \"bankCard\": \"6228480176117796365\", \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"[test]认证错误，[个人银行卡四要素比对]信息核验失败，请检查信息是否正确\", \"code\": 100750}', 0, '2025-04-01 14:05:21'); INSERT INTO `ums_ext_api_his` VALUES (67, '213417306', 2, '个人银行卡四要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"bankCard\": \"6228480176117796365\", \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"type\": \"个人银行卡四要素比对\", \"result\": 1, \"serialNo\": \"PV20420250401140535525521\"}', 1, '2025-04-01 14:05:35'); INSERT INTO `ums_ext_api_his` VALUES (68, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-05390\", \"contractName\": \"易联数科\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"signUser\": [], \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOheQWdr4hwK-YqJgysvSKvUIv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GKa1v-lh_xwLi2WDKktJvek?expired=10800000\", \"pageSizeMap\": {}, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}]}', 1, '2025-04-01 14:07:51'); INSERT INTO `ums_ext_api_his` VALUES (69, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-05390\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-05390\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"[test]签约用户不存在\", \"code\": 100084}', 0, '2025-04-01 14:07:53'); INSERT INTO `ums_ext_api_his` VALUES (70, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-07397\", \"contractName\": \"易联数科\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"signUser\": [], \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhaa060lpQvNn_WnK6wb8z70v7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GGsIXp2kl7i0WU25BQdmg3M?expired=10800000\", \"pageSizeMap\": {}, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}]}', 1, '2025-04-01 14:07:55'); INSERT INTO `ums_ext_api_his` VALUES (71, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-07397\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-07397\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"[test]签约用户不存在\", \"code\": 100084}', 0, '2025-04-01 14:07:56'); INSERT INTO `ums_ext_api_his` VALUES (72, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-07198\", \"contractName\": \"税邦云\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"signUser\": [], \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhdUVQ6-sSOYKdiNB6HVQOzgv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GIC-AIIdvvwUGp1m8bXUO7U?expired=10800000\", \"pageSizeMap\": {}, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}]}', 1, '2025-04-01 14:07:59'); INSERT INTO `ums_ext_api_his` VALUES (73, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-07198\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-07198\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"[test]签约用户不存在\", \"code\": 100084}', 0, '2025-04-01 14:08:01'); INSERT INTO `ums_ext_api_his` VALUES (74, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-03817\", \"contractName\": \"易联数科\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"signUser\": [], \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhVQKkXKSLfMjN_5FMyTrFwov7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GBoYHMLEkDSS8S6AZQCaX0w?expired=10800000\", \"pageSizeMap\": {}, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}]}', 1, '2025-04-01 14:22:49'); INSERT INTO `ums_ext_api_his` VALUES (75, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-03817\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-03817\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"[test]签约用户不存在\", \"code\": 100084}', 0, '2025-04-01 14:22:51'); INSERT INTO `ums_ext_api_his` VALUES (76, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"dkBQmdO5\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLOWEZJyL9Gy2AYKwiE1q5A2&secretAccessKey=4DJDMmlLDlBsx27c3h5oUBPEH9Gf0ATOcvG9suGE0v1&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEMTNqyH0l0LGjnPOJr7C7DIQwo2uvwYY0qmuvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovN2U4N2YzN2VlNzg5NDUwMzk0ZmU0NzI0ZjQ4ZjY2ZGRCBFVzZXJSIDdlODdmMzdlZTc4OTQ1MDM5NGZlNDcyNGY0OGY2NmRkWAI.ILu1-LQplc4Ooc6Y0c7FEIxtXd74KBHL-ReKarF32DqzM2FR6FqT1quKWzC8yJCGonccXIDzFMy_awEJS3N48Q&bytedToken=20250401142508C2E4901F4A44675FCD16&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26953754480629135017905%3ForderNo%3DVE230125199701233111743488706467\", \"serialNo\": \"PA10320250401142508981226\"}', 1, '2025-04-01 14:25:06'); INSERT INTO `ums_ext_api_his` VALUES (77, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"9ligBLPj\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLKoduwP0r1feFEcBZjhdVO2&secretAccessKey=CZLformw9UUaSwGpRqWE8DI9lSW51Spu9xU4l62xpBE&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEEshuNo_GkXroZteMfcMzWYQxI2uvwYY1KmuvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovNmM4NGFlNTE1NjkzNDc4MmI0NGUyYjAxOTUyYzgwNTRCBFVzZXJSIDZjODRhZTUxNTY5MzQ3ODJiNDRlMmIwMTk1MmM4MDU0WAI.B9I_c7ZFAJr92GbCYx-gXIQhTl1IpP9Yy61UIUihktS24HuDBVqy0sEoK7joAXyyk4Q27-HTW9rvPQueMmC_JA&bytedToken=2025040114250809A7CD69508DEE6061C0&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26953756347314044674108%3ForderNo%3DVE230125199701233111743488708326\", \"serialNo\": \"PA10320250401142508744669\"}', 1, '2025-04-01 14:25:08'); INSERT INTO `ums_ext_api_his` VALUES (78, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素比对\", \"result\": 1, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PV20220250401142526183308\", \"identifyUrl\": \"\"}}', 1, '2025-04-01 14:25:25'); INSERT INTO `ums_ext_api_his` VALUES (79, '213417306', 2, '个人银行卡四要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"bankCard\": \"6228480176117796365\", \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"type\": \"个人银行卡四要素比对\", \"result\": 1, \"serialNo\": \"PV20420250401142645133745\"}', 1, '2025-04-01 14:26:44'); INSERT INTO `ums_ext_api_his` VALUES (80, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-04286\", \"contractName\": \"易联数科\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"signUser\": [], \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJQZTA8DUooGTTu0ZtFNrYv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GOcpEXe0Pqq35leMmjEHsRQ?expired=10800000\", \"pageSizeMap\": {}, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}]}', 1, '2025-04-01 14:26:55'); INSERT INTO `ums_ext_api_his` VALUES (81, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-04286\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250401-04286\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"remark\": \"\", \"status\": null, \"signUser\": [], \"signOrder\": 1, \"contractNo\": \"CONTRACT-20250401-04286\", \"preserveNo\": \"\", \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJQZTA8DUooGTTu0ZtFNrYv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GHzFVpiJbs3KM_bf4oIgF1M?expired=10800000\", \"embeddedUrl\": \"\", \"initiateUrl\": \"\", \"pageSizeMap\": {}, \"contractName\": \"易联数科\", \"validityTime\": \"2025-05-01\", \"contractFiles\": [], \"noSenceSignUsers\": [], \"signFinishedTime\": \"\"}}', 1, '2025-04-01 14:26:56'); INSERT INTO `ums_ext_api_his` VALUES (82, '213417306', 2, '查询合同信息', '{\"contractNo\": \"CONTRACT-20250401-04286\"}', '{\"status\": 2, \"signUser\": [{\"name\": \"赵顺宇\", \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"21cb417701214ec291ad4b11d78b511c\", \"account\": \"15776556654\", \"signType\": 2, \"userType\": 2, \"signOrder\": 1, \"signStatus\": 2, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-01 14:26:58\"}, {\"name\": \"赵顺宇\", \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"5030337bbfc34af58d6e97a7bbb30eeb\", \"account\": \"ASIGNTC960498MA5G6RHPX9\", \"signType\": 2, \"userType\": 1, \"signOrder\": 1, \"signStatus\": 2, \"companyName\": \"aqtest深圳要易云科技服务有限公司CX\", \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-01 14:26:59\"}], \"contractNo\": \"CONTRACT-20250401-04286\", \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJQZTA8DUooGTTu0ZtFNrYv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GPhBultPzIR-BIfvq43xpmU?expired=10800000\", \"pageSizeMap\": {\"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902\": 11}, \"contractName\": \"易联数科\", \"validityTime\": \"2025-05-01\", \"contractFiles\": [], \"signFinishedTime\": \"2025-04-01 14:26:59\"}', 1, '2025-04-01 14:27:00'); INSERT INTO `ums_ext_api_his` VALUES (83, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"JJ8XnN4T\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLJpaJ1ECMwRG6jLk2jUJrBj&secretAccessKey=0no12WCaucz5unU4YpAfXQSYSSpwBuuBbz9Ko08Dwth&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSECrGIZFLQUYlqXUDu7vP89MQmZiuvwYYqbSuvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovOGQzOTM4ZWQ3MDM4NGQzMmEzNjRhNDc5YmRkYjdiNzZCBFVzZXJSIDhkMzkzOGVkNzAzODRkMzJhMzY0YTQ3OWJkZGI3Yjc2WAI.NZWsXMiwawEYvZAhu_s2NKnK925fsLfJ9mPqMiKBXHuPJfVSnIj3hSqIk3CCM2jqTyipZEwITuOzCOw2SdCa1Q&bytedToken=202504011447533F2919D8E89F7A64D963&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26955121115664817145834%3ForderNo%3DVE511322199205103651743490073096\", \"serialNo\": \"PA10320250401144754451895\"}', 1, '2025-04-01 14:47:52'); INSERT INTO `ums_ext_api_his` VALUES (84, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"18933274128\", \"authMode\": 1, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素比对\", \"result\": 1, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PV20220250401144834194651\", \"identifyUrl\": \"\"}}', 1, '2025-04-01 14:48:34'); INSERT INTO `ums_ext_api_his` VALUES (85, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"mD4GD2x6\", \"authMode\": 2, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLJdBgMrNYG2QokMBbzSLPXU&secretAccessKey=0RQ4BzAEhXEOtH4Y5rgKlARax8fqT75dm8W6eg8y09t&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSECQ0Pxz1mEsci_CWVIue8bgQ-5iuvwYYi7WuvwYg0a3V6QcoBDCKmawBOidBUVNaS0ovYTczNzY5ZDc2N2E4NGVlYmJmNmJmMDZlYzc3MWRkODlCBFVzZXJSIGE3Mzc2OWQ3NjdhODRlZWJiZjZiZjA2ZWM3NzFkZDg5WAI.Q-l8t3XQb9PH7_RIxi8m3DLQQ9iMGn5Sn34Cq5jl7EI2DAQrZiHVFHLun46iVUxfyBUBZs-QVr8odkvKqi6lVQ&bytedToken=20250401144931585E6C0B21CA0B664AE1&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F26955219307103810002425%3ForderNo%3DVE511322199205103651743490171314\", \"serialNo\": \"PA10320250401144931962394\"}', 1, '2025-04-01 14:49:31'); INSERT INTO `ums_ext_api_his` VALUES (86, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"18933274128\", \"authMode\": 1, \"idCardNo\": \"51132219920510365X\", \"realName\": \"曹青山\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素比对\", \"result\": 1, \"faceUrl\": \"\", \"process\": null, \"serialNo\": \"PV20220250401144952155182\", \"identifyUrl\": \"\"}}', 1, '2025-04-01 14:49:51'); INSERT INTO `ums_ext_api_his` VALUES (87, '213417306', 2, '个人银行卡四要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"bankCard\": \"6228480176117796365\", \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"type\": \"个人银行卡四要素比对\", \"result\": 1, \"serialNo\": \"PV20420250401145040900379\"}', 1, '2025-04-01 14:50:40'); INSERT INTO `ums_ext_api_his` VALUES (88, '213417306', 2, '个人人脸活体认证', '{\"bizId\": \"TbT7OgwR\", \"authMode\": 2, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1, \"showResult\": 1, \"faceAuthMode\": 4}', '{\"type\": \"个人活体人脸认证\", \"result\": 0, \"faceUrl\": \"https://face.asign.cn/hs?configId=7395035628096978982&accessKeyId=AKTP0VOuGDMQrAzl2J3kiFTLQJVL8c7KJY5Erq0WJTY071&secretAccessKey=fRr1Sr2letJShloa5PrnoCqeq9gQ5giU1qpClftZAzK&sessionToken=nCgdqdEROend3.ChsKBzNzX056d3cSEP_FZ-M3nEocqH3WjNtWHBMQ1Pq4vwYY5Ja5vwYg0a3V6QcoBDCKmawBOidBUVNaS0ovZDJhNWI0MzY3MjBjNGQzNGEzYTg0ZTM3MzBjYmJmZWNCBFVzZXJSIGQyYTViNDM2NzIwYzRkMzRhM2E4NGUzNzMwY2JiZmVjWAI.klpCTBy_zw_V_8SiL4Mlh1T5yw2_o73-TsMqAWlAI2904HFSYk3sHSnDyvkEtZjL0EfBw_I519Z3nMNtjVOKDg&bytedToken=202504031548365919377B166D70FEC6A8&redirectUrl=https%3A%2F%2Fprev.asign.cn%2Fauth%2Fface%2Fredirect%2F27131564002561309280047%3ForderNo%3DVE230125199701233111743666515978\", \"process\": null, \"serialNo\": \"PA10320250403154836466959\", \"identifyUrl\": null}', 1, '2025-04-03 15:48:35'); INSERT INTO `ums_ext_api_his` VALUES (89, '213417306', 2, '个人运营商三要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"type\": \"个人运营商三要素比对\", \"result\": 1, \"faceUrl\": null, \"process\": null, \"serialNo\": \"PV20220250403154854889522\", \"identifyUrl\": null}, \"requestId\": null}', 1, '2025-04-03 15:48:54'); INSERT INTO `ums_ext_api_his` VALUES (90, '213417306', 2, '个人银行卡四要素比对', '{\"mobile\": \"15776556654\", \"authMode\": 1, \"bankCard\": \"6228480176117796365\", \"idCardNo\": \"230125199701233111\", \"realName\": \"赵顺宇\", \"idCardType\": 1}', '{\"type\": \"个人银行卡四要素比对\", \"result\": 1, \"faceUrl\": null, \"process\": null, \"serialNo\": \"PV20420250403154936675859\", \"identifyUrl\": null}', 1, '2025-04-03 15:49:36'); INSERT INTO `ums_ext_api_his` VALUES (91, '213417306', 2, '创建待签署文件', '{\"signOrder\": 1, \"contractNo\": \"CONTRACT-20250403-02431\", \"contractName\": \"税邦云\", \"validityTime\": 30, \"contractFiles\": [{\"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-%E5%85%BC%E8%81%8C%E5%AD%A6%E6%9C%AF%E4%BF%A1%E6%81%AF%E6%B2%9F%E9%80%9A%E4%B8%93%E5%91%98%E4%B8%9A%E7%BB%A9%E6%8A%A5%E5%91%8A%2848703%29-20250228184902.docx\"}], \"downloadFileType\": 1}', '{\"remark\": null, \"status\": null, \"signUser\": [], \"signOrder\": null, \"contractNo\": null, \"preserveNo\": null, \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJRbmTCbBviax96loAfOSEv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GMmGaqj9lHdgXwVzBuOFgVc?expired=10800000\", \"embeddedUrl\": null, \"initiateUrl\": null, \"pageSizeMap\": {}, \"contractName\": null, \"validityTime\": null, \"contractFiles\": [{\"page\": 11, \"attachNo\": 1, \"fileName\": \"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902.docx\"}], \"noSenceSignUsers\": null, \"signFinishedTime\": null}', 1, '2025-04-03 15:49:44'); INSERT INTO `ums_ext_api_his` VALUES (92, '213417306', 2, '添加签署方', '{\"\": [{\"account\": \"15776556654\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250403-02431\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"乙方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}, {\"signKey\": \"乙方签署日期\", \"attachNo\": 1, \"signType\": 2, \"clipNumber\": 0, \"locationMode\": 3}]}, {\"account\": \"ASIGNTC960498MA5G6RHPX9\", \"asynSign\": 0, \"signType\": 2, \"waterMark\": 1, \"contractNo\": \"CONTRACT-20250403-02431\", \"validateType\": 1, \"customSignFlag\": 0, \"isNoticeComplete\": 1, \"signStrategyList\": [{\"signKey\": \"甲方签署区\", \"attachNo\": 1, \"clipNumber\": 0, \"locationMode\": 3}]}]}', '{\"msg\": \"成功\", \"code\": 100000, \"data\": {\"remark\": null, \"status\": null, \"signUser\": [], \"signOrder\": 1, \"contractNo\": \"CONTRACT-20250403-02431\", \"preserveNo\": null, \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJRbmTCbBviax96loAfOSEv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GA1wXavz7pPIq8iaFhntIMg?expired=10800000\", \"embeddedUrl\": null, \"initiateUrl\": null, \"pageSizeMap\": {}, \"contractName\": \"税邦云\", \"validityTime\": \"2025-05-03\", \"contractFiles\": [], \"noSenceSignUsers\": null, \"signFinishedTime\": null}, \"requestId\": null}', 1, '2025-04-03 15:49:46'); INSERT INTO `ums_ext_api_his` VALUES (93, '213417306', 2, '查询合同信息', '{\"contractNo\": \"CONTRACT-20250403-02431\"}', '{\"remark\": null, \"status\": 2, \"signUser\": [{\"name\": \"赵顺宇\", \"email\": null, \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"21cb417701214ec291ad4b11d78b511c\", \"status\": null, \"account\": \"15776556654\", \"signUrl\": null, \"authType\": null, \"bankCard\": null, \"serialNo\": null, \"signMark\": null, \"signType\": 2, \"userType\": 2, \"signOrder\": 1, \"createTime\": null, \"creditCode\": null, \"pwdSignUrl\": null, \"signStatus\": 2, \"companyName\": null, \"portVersion\": null, \"identifyTime\": null, \"identifyType\": null, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-03 15:49:50\"}, {\"name\": \"赵顺宇\", \"email\": null, \"idCard\": \"230125199701233111\", \"mobile\": \"15776556654\", \"sealNo\": \"5030337bbfc34af58d6e97a7bbb30eeb\", \"status\": null, \"account\": \"ASIGNTC960498MA5G6RHPX9\", \"signUrl\": null, \"authType\": null, \"bankCard\": null, \"serialNo\": null, \"signMark\": null, \"signType\": 2, \"userType\": 1, \"signOrder\": 1, \"createTime\": null, \"creditCode\": null, \"pwdSignUrl\": null, \"signStatus\": 2, \"companyName\": \"aqtest深圳要易云科技服务有限公司CX\", \"portVersion\": null, \"identifyTime\": null, \"identifyType\": null, \"validateType\": 1, \"contractViewHis\": [], \"signFinishedTime\": \"2025-04-03 15:49:51\"}], \"signOrder\": null, \"contractNo\": \"CONTRACT-20250403-02431\", \"preserveNo\": null, \"previewUrl\": \"https://pre.asign.cn/m/#/mobile/previewApiContract/QhUqHj669cOmXIPrJ7eOhXJRbmTCbBviax96loAfOSEv7ZoOPhbujSxfyttP0vDnT1nZzlTEfWKw_VtDrCr3GMlv9ZXLpoe1wHOwFHgWiXM?expired=10800000\", \"embeddedUrl\": null, \"initiateUrl\": null, \"pageSizeMap\": {\"65a0d5456bf74c02aff5c4a343c9ecce-兼职学术信息沟通专员业绩报告(48703)-20250228184902\": 11}, \"contractName\": \"税邦云\", \"validityTime\": \"2025-05-03\", \"contractFiles\": [], \"noSenceSignUsers\": null, \"signFinishedTime\": \"2025-04-03 15:49:51\"}', 1, '2025-04-03 15:49:52'); -- ---------------------------- -- Table structure for ums_ext_config -- ---------------------------- DROP TABLE IF EXISTS `ums_ext_config`; CREATE TABLE `ums_ext_config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID', `ext_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '第三方接口ID', `ext_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '第三方接口名称（如ums_ext_aiqian）', `ext_status_config` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT '状态列表配置', `ext_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'AES加密的Key', `ext_secret` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'AES加密的Secret', `create_by` bigint NULL DEFAULT NULL COMMENT '创建人ID', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人ID', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `del_flag` int NULL DEFAULT NULL, `lock_flag` int NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = '第三方接口配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of ums_ext_config -- ---------------------------- INSERT INTO `ums_ext_config` VALUES (1, '213417306', 'asign', NULL, 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAob2XMuGjRL4VrHrpQ/IFDbuXe1OmS3pfDNw4Tf1sXy2MW6dd+f0zY25UoFATo8eNQ/+7fZcEZYDKI3NrOGlWIPT/86ZaHpRutOmhubYgxrKZCMyrSy+xd3+M/3n4Ksyv+DHyTeneGTe4zBVF0wCASr8q/oJ562JwPQViM2MqFhEKvasx8PS+Er7/6uRVLlujz2oaCdajYAj105XUmwYTnL4hsHs4qh3DjCqO1XrqVIEbkGBzcwZz/i2aDr1bWBsFuLDksXHqXdXwVDnGGIKWsnhbeyfy6NXtceQ3L2fToPTHsYw6Ibw9L82iqH3/fup8WpVHvJaNJ2SeXA02ihPJLQIDAQAB', 'MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQChvZcy4aNEvhWseulD8gUNu5d7U6ZLel8M3DhN/WxfLYxbp135/TNjblSgUBOjx41D/7t9lwRlgMojc2s4aVYg9P/zploelG606aG5tiDGspkIzKtLL7F3f4z/efgqzK/4MfJN6d4ZN7jMFUXTAIBKvyr+gnnrYnA9BWIzYyoWEQq9qzHw9L4Svv/q5FUuW6PPahoJ1qNgCPXTldSbBhOcviGweziqHcOMKo7VeupUgRuQYHNzBnP+LZoOvVtYGwW4sOSxcepd1fBUOcYYgpayeFt7J/Lo1e1x5DcvZ9Og9MexjDohvD0vzaKoff9+6nxalUe8lo0nZJ5cDTaKE8ktAgMBAAECggEAEfx7a/UbqvFYh63DcwLe/P/3gId03r/lAhEbUdD01EDEcwzRrpMxu8TxNEKzbGsskntF5ll866y+zeJv8f4EzfVw4S+Gpg/rn8K7cWOHkZEa45efFOVg3uEYVPDDYD8S8o7bWz6+rB8+NbPH6AcOPUG1DkiENmDkCmUm3oAQlhNxgJWO0F7sDVR+9YOFFLTc/be7sgQvn7AJarF60tX0HGll07iyqKqthIa3FY/nt8EdFSYG5gplOVWB9dvGYi7QcKA9jWLuB37eo1Lg3zCyktYNgRJMA4TYdE8pZ6EQd8T+EBxKmbsxNuTtXRchgkqcxTM8jBSRiX7DKMbnU2WEAQKBgQDlfYkUWIaf8ra3AqXeR3y78NVWMEsH5oGwSnI5DkYWWr0CaQYrs8/jeYzYXyd2SVg+EXJetXS27vppkE1zXgpw7Q5g5Qm2va+MQBnWznm97xyLj7bBMOnzm+HVDw1C+9q33h1TT66PhYMI3JI70eKz/DIsFh7wYi+BxVtog09xDQKBgQC0bJDaya+3+BwV+UxsfxwbNB+IxrjK1E54BYZUTX7U/YaF8uzRVxCtzMbk9aix4LKr0XAL4uXtQxdA9Ipz/dD7GksvTD/ls14YsN//g94SPvsiAV4wG+5djc2iPTYHw4pCyluyn0SnIPFe/qA4zptYiInTdGiFg7i9542NCEhwoQKBgQDihVw2cf9IiDokQP/afTO5C0p5Dagx/ywKCCHhAZ7a1+vzIhmOL6nG/iaxOJNqJZFtiqkapP+0xgT1CBP7CVtDBisIJ2vELk3GIUugBSST/x5s/4lD/nUfGcH7HSVY9eJ5VUwa/O7wCbhCmf3aAB1GzWv0qk0Vt8Tu0hCdA+f5TQKBgFNtYA3K9NW8hEAk5pHEtNpfX7V/LjObuC0HYPXaX6tdD7cgfSDPgYbcCZwVe8vEetm4Hndgk7ECNN50NREtbFSv89QLDgDIz9na77jW4PjO5pDy0Pqt76qSx2Mdqr4sTOJVb9FIlBYzxWiHlM6vumVVvWVpjmsuXV5yk6GDEvwBAoGAZD1YxLvgt0D1NP6jqXlV1Z6DEYa4zmkAxK+lXrHNcBAgYaYsdOmV9HG0KTLF/6vjWA4ZsfLYfcI3pb5f1Bav0gWJ0mIuTeHv2CBM+JS3wmxS6D+5+pouLDz8eo9QTKAsHgUhIy4bv4s5nmUa2pz9ENCY+PEjN1P8QU3/3sCH7pA=', NULL, '2025-03-09 00:55:53', NULL, '2025-03-10 16:54:28', 0, 0); INSERT INTO `ums_ext_config` VALUES (4, '009609974', 'asign_', NULL, 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA5XSAwGpiRzgucELt2AmizGzKJsXdc6WdTZr9jEfeoKVvgEo+YRpDsW/vLzHLf7W4E7GkIiFVIdtzPSlWQBPBpkBRiSyx0e+MLiDd1LtjOjVxQ16rtTeygsQlBCGdCFr3KeB9UmMW3HRcXlc6gwJk5CkkgsEInYltKARerjXFdNfA16vGZ347I8nx+oSQByaV/RNeEko7sOEz9VZQasl5emu2jpV31xVQ2cbgi/NmwQOxaQ4PTeshdyU2Q5Umq9q/Ut4091uasu0UtgfzRbgtSAC/AZV2Bx5Jy0hs4I3SvIH7JL+PNAEJubavQMpaUXMSSzNTxYkPxjt1bNAIKRPZOwIDAQAB', 'MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQDldIDAamJHOC5wQu3YCaLMbMomxd1zpZ1Nmv2MR96gpW+ASj5hGkOxb+8vMct/tbgTsaQiIVUh23M9KVZAE8GmQFGJLLHR74wuIN3Uu2M6NXFDXqu1N7KCxCUEIZ0IWvcp4H1SYxbcdFxeVzqDAmTkKSSCwQidiW0oBF6uNcV018DXq8ZnfjsjyfH6hJAHJpX9E14SSjuw4TP1VlBqyXl6a7aOlXfXFVDZxuCL82bBA7FpDg9N6yF3JTZDlSar2r9S3jT3W5qy7RS2B/NFuC1IAL8BlXYHHknLSGzgjdK8gfskv480AQm5tq9AylpRcxJLM1PFiQ/GO3Vs0AgpE9k7AgMBAAECggEAAXeMNy628COg0GDtKlttagcsB7FuKAYgClX6VwJCnx5Ppy9SVMaZNjI0AkY8OdXMlnulQ/6Yj73ab8Kq5X/61fhFTS42+NOiPs1A/dIw4TdkQP0C9gakIofkgLFCUsJaIC9qPbOaetBXotbF7f5+7KKCtD9NscwmIYJdpJl9aLDRVkzS4L0yqbYSKvLSXc5gKZNqhRoIfMv4L8ifzKFJcEaCQgyJBtVqas1cSbK4oM52J1y2DpRrH7RSw0AhQplsgXO1O0f6H7DCzfrAQ4MEKzRz8+Av7gQ1obo8ey6Svh/6MC56E0rFfE2qQdJxk89V0FlzV5PbkLnc9n5tOUi9uQKBgQD3EIDUaO7lMocTs6z9hKGZai7Z5Bef9dLCA0hEYycS7EyXHSvaz883lKlA0GCbrfndkdtmsuzCbpqTSrFbPSgvjMcIFlIsqdlC7xm2aWbjRLjNFTC8TxqkSbG/h3PtDq38V/Gb+zPrEf95uu6nTdZU5rT5DWCV++JdCt+hfVUDtwKBgQDtwPWucWCn3nvDYbtGXWhKMp2VlR15nqwWcxY+lfCQXn9U3ksEq1tUZtr45lYbZrAJtuYHvYdpWE55r6NUdQAXfKSBM2Q33IvhNcoKmYy/y+nCEPd6qeBsuUSttBqN4e6v4wEdhURle6IX5fbzAw4ALpDfSNaEbnCApEw4acf+nQKBgFSNzFlllCTSlxHyEwkshBW6FlCx1DgFbFzDvM7S1EOQpWGuNR0Ms9FEymwJJJcDApmG2nyaTZb5PWOdU3dzRbaISnGFGhh5BIb4x2b7SaAMG+bsEqLPu8FwCyoOVGlT9c1/14tXfFw9654gkJ6nb+vcjSETJ/QMoVrQZtqgxyCfAoGAbi3k7PFnzIOjMTlCU2qIIRJxytcusKTitQiif2B2+kCAm7DkbQaILYX45i3AK7Sb0fSrh1zCuwQMYgIOG96Yq0m85o8NW4HeZQDLX7wm6N8zthasyXCeK2R0Oldjkurn9SSq6KZQuwLfbFnK5nU88MKjqoYTu41+n28ET4ReBVUCgYA0vCGDFMMlE6BWnghu46fhGkABPZrF1Pgf1BYelVwtv/PCSm7SLJbJw3uw2GzdYIXNvzmfLigDRwV4SQ0Z6jYmtiIvtqTdpTP2yC2p8JEwPOSuaXktIyI+d6DisjwfPESHK9d6QWQLilCMLQtqN4/2LPusRbTV8Cw0lPRRpACa8A==', NULL, '2025-03-09 00:55:53', NULL, '2025-03-10 16:54:30', 0, 0); -- ---------------------------- -- Table structure for ums_member -- ---------------------------- DROP TABLE IF EXISTS `ums_member`; CREATE TABLE `ums_member` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID（即member_id）', `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'phone', `is_three_auth` tinyint NULL DEFAULT 0 COMMENT '三要素认证 0-未认证 1-已认证', `is_four_auth` tinyint NULL DEFAULT 0 COMMENT '四要素认证 0-未认证 1-已认证', `is_ocr_auth` tinyint NULL DEFAULT 0 COMMENT 'OCR认证 0-未认证 1-已认证', `is_liveness_auth` tinyint NULL DEFAULT 0 COMMENT '活体认证 0-未认证 1-已认证', `is_esign_auth` tinyint NULL DEFAULT 0 COMMENT '电子签认证 0-未认证 1-已认证', `three_auth_info` json NULL COMMENT '三要素认证数据（姓名/身份证/手机号）', `four_auth_info` json NULL COMMENT '四要素认证数据（+银行卡号）', `ocr_info` json NULL COMMENT 'OCR识别数据（身份证正反面/有效期）', `liveness_info` json NULL COMMENT '活体检测数据（视频/分数）', `user_seal_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '生成默认印章编号', `certificate_info` json NULL COMMENT '证书', `esign_info` json NULL COMMENT '电子签数据（合同/签章位置）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标记 0-正常 1-已删除', `lock_flag` tinyint NULL DEFAULT 0 COMMENT '锁定标记 0-可编辑 1-只读', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_auth_status`(`is_three_auth` ASC, `is_four_auth` ASC, `is_esign_auth` ASC) USING BTREE, INDEX `idx_update`(`update_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '统一用户认证信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of ums_member -- ---------------------------- INSERT INTO `ums_member` VALUES (1, '18689869781', 1, 1, 0, 0, 0, '{\"end\": \"20390202\", \"sex\": \"男\", \"back\": \"http://127.0.0.1:9981/java3000/888b39421d1947259285012cc62998d6-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115133Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=543a7f496feee7483997505e2951d6a80186ba8d65155d5e70c5d2adfb613a3e\", \"born\": \"19920403\", \"begin\": \"20190202\", \"front\": \"http://127.0.0.1:9981/java3000/0bb0aad0e2cd4180ad4ccf61769d7cbb-%E6%AD%A3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115131Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=dc8d70fe45f450c60ba77a731385d5f1fe81d73bfa29a6520ffa4154a8b0bce2\", \"idcard\": \"460034199204034721\", \"nation\": \"汉\", \"address\": \"海南省陵水黎族自治县新村镇海英村委会新建路120号\", \"realname\": \"梁妙杏\", \"department\": \"陵水黎族自治县公安局\"}', '{\"phone\": \"18689869782\", \"idCard\": \"460034199204034721\", \"bankName\": \"中信银行\", \"realName\": \"梁妙杏\", \"cardNumber\": \"6217680915622257\"}', '{\"back\": \"http://127.0.0.1:9981/java3000/888b39421d1947259285012cc62998d6-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115133Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=543a7f496feee7483997505e2951d6a80186ba8d65155d5e70c5d2adfb613a3e\", \"front\": \"http://127.0.0.1:9981/java3000/0bb0aad0e2cd4180ad4ccf61769d7cbb-%E6%AD%A3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115131Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=dc8d70fe45f450c60ba77a731385d5f1fe81d73bfa29a6520ffa4154a8b0bce2\"}', NULL, NULL, '{\"otherFiles\": [\"http://127.0.0.1:9981/java3000/f8f6a6779d2d4297a544e1001520555c-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250311%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250311T092329Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1d72c11d98db99c15aaa8ae492d84ed915473c90687ba0f8aa89cfc17c352564\"], \"medicalFiles\": [\"http://127.0.0.1:9981/java3000/43619c922ade4841b123f73ead3c54e6-正.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu/20250310/us-east-1/s3/aws4_request&X-Amz-Date=20250310T094033Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1ae50ee493bb50a2125ee41ce429a5ba98361ffce434536cfbe2d5c294031a7c\", \"http://127.0.0.1:9981/java3000/3512a872846b466f965ff3241ab7d476-头像.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu/20250311/us-east-1/s3/aws4_request&X-Amz-Date=20250311T050604Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=4c640657e40325a1716022f767f40439eb30a38c1641ddfbe44aaf7f917697b1\"], \"recordNumber\": \"jsonxxx\"}', NULL, NULL, '2025-03-09 12:59:54', '12', '2025-03-12 16:37:42', 0, 0); INSERT INTO `ums_member` VALUES (2, '15776556654', 1, 1, 0, 1, 0, '{\"end\": \"20270220\", \"sex\": \"男\", \"back\": \"http://yunpang.hejusuan.com:9000/temp/fcd9ed5a57bb4aecab85a0e3d53a2b50-tmp_bf34c48f57a5cceb34d1d81db981d25e.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250403%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250403T074829Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=7f9a8189875321bd4f3f9a992aaa74b762c2c000461b86f91f85a68852a9a9d1\", \"born\": \"19970123\", \"begin\": \"20170220\", \"front\": \"http://yunpang.hejusuan.com:9000/temp/d6fd419ff5ea4532b0d2ab0b967bd191-tmp_f631cc22cbd35de8a41d3d05dde43a43.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250403%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250403T074816Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=756a80319dc2cbd9504ce727118e1d51ed1d3c7001aff6b53a488e07f2e9209a\", \"idcard\": \"230125199701233111\", \"nation\": \"汉\", \"address\": \"黑龙江省宾县居仁镇东升村赵六屯\", \"captcha\": null, \"realname\": \"赵顺宇\", \"serialNo\": null, \"department\": \"宾县公安局\"}', '{\"phone\": \"15776556654\", \"idCard\": \"230125199701233111\", \"bankName\": \"农行\", \"realName\": \"赵顺宇\", \"cardNumber\": \"6228480176117796365\"}', '{\"back\": \"http://yunpang.hejusuan.com:9000/temp/fcd9ed5a57bb4aecab85a0e3d53a2b50-tmp_bf34c48f57a5cceb34d1d81db981d25e.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250403%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250403T074829Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=7f9a8189875321bd4f3f9a992aaa74b762c2c000461b86f91f85a68852a9a9d1\", \"front\": \"http://yunpang.hejusuan.com:9000/temp/d6fd419ff5ea4532b0d2ab0b967bd191-tmp_f631cc22cbd35de8a41d3d05dde43a43.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250403%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250403T074816Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=756a80319dc2cbd9504ce727118e1d51ed1d3c7001aff6b53a488e07f2e9209a\"}', NULL, NULL, NULL, '{\"sealNo\": \"21cb417701214ec291ad4b11d78b511c\"}', NULL, '2025-03-11 17:11:50', NULL, '2025-04-03 15:21:13', 0, 0); INSERT INTO `ums_member` VALUES (3, '13307695558', 1, 1, 0, 0, 0, '{\"end\": \"20390202\", \"sex\": \"男\", \"back\": \"http://127.0.0.1:9981/java3000/888b39421d1947259285012cc62998d6-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115133Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=543a7f496feee7483997505e2951d6a80186ba8d65155d5e70c5d2adfb613a3e\", \"born\": \"19920403\", \"begin\": \"20190202\", \"front\": \"http://127.0.0.1:9981/java3000/0bb0aad0e2cd4180ad4ccf61769d7cbb-%E6%AD%A3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115131Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=dc8d70fe45f450c60ba77a731385d5f1fe81d73bfa29a6520ffa4154a8b0bce2\", \"idcard\": \"460034199204034721\", \"nation\": \"汉\", \"address\": \"海南省陵水黎族自治县新村镇海英村委会新建路120号\", \"realname\": \"梁妙杏\", \"department\": \"陵水黎族自治县公安局\"}', '{\"phone\": \"18689869782\", \"idCard\": \"460034199204034721\", \"bankName\": \"中信银行\", \"realName\": \"梁妙杏\", \"cardNumber\": \"6217680915622257\"}', '{\"back\": \"http://127.0.0.1:9981/java3000/888b39421d1947259285012cc62998d6-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115133Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=543a7f496feee7483997505e2951d6a80186ba8d65155d5e70c5d2adfb613a3e\", \"front\": \"http://127.0.0.1:9981/java3000/0bb0aad0e2cd4180ad4ccf61769d7cbb-%E6%AD%A3.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250310%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250310T115131Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=dc8d70fe45f450c60ba77a731385d5f1fe81d73bfa29a6520ffa4154a8b0bce2\"}', NULL, NULL, '{\"otherFiles\": [\"http://127.0.0.1:9981/java3000/f8f6a6779d2d4297a544e1001520555c-%E5%8F%8D.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250311%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250311T092329Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1d72c11d98db99c15aaa8ae492d84ed915473c90687ba0f8aa89cfc17c352564\"], \"medicalFiles\": [\"http://127.0.0.1:9981/java3000/43619c922ade4841b123f73ead3c54e6-正.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu/20250310/us-east-1/s3/aws4_request&X-Amz-Date=20250310T094033Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=1ae50ee493bb50a2125ee41ce429a5ba98361ffce434536cfbe2d5c294031a7c\", \"http://127.0.0.1:9981/java3000/3512a872846b466f965ff3241ab7d476-头像.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu/20250311/us-east-1/s3/aws4_request&X-Amz-Date=20250311T050604Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=4c640657e40325a1716022f767f40439eb30a38c1641ddfbe44aaf7f917697b1\"], \"recordNumber\": \"jsonxxx\"}', NULL, NULL, '2025-03-09 12:59:54', '12', '2025-03-12 16:39:41', 0, 0); INSERT INTO `ums_member` VALUES (5, '15776556654', 1, 1, 0, 1, 0, '{\"end\": \"20270220\", \"sex\": \"男\", \"back\": \"http://yunpang.hejusuan.com:9000/temp/caeddb900d14404294a6fd7c58f2f7c3-tmp_f2f91a0621c7716b5b03aed603200458.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250401%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250401T062458Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=df68668ebde3f92fbc5cab623df10be617bb8b18e05f84446a8cc4b8925541b1\", \"born\": \"19970123\", \"begin\": \"20170220\", \"front\": \"http://yunpang.hejusuan.com:9000/temp/51d3c2de5dcf469186202f4d2b9b2d0f-tmp_42776d3c5903d5607fa2aac1e663801d.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250401%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250401T062448Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=91faf4ec6233b08846095a4127b787b6ebfc5fa04b8794dce7ae55c29c6d60d2\", \"idcard\": \"230125199701233111\", \"nation\": \"汉\", \"address\": \"黑龙江省宾县居仁镇东升村赵六屯\", \"realname\": \"赵顺宇\", \"department\": \"宾县公安局\"}', '{\"phone\": \"15776556654\", \"idCard\": \"230125199701233111\", \"bankName\": \"农行\", \"realName\": \"赵顺宇\", \"cardNumber\": \"6228480176117796365\"}', '{\"back\": \"http://yunpang.hejusuan.com:9000/temp/caeddb900d14404294a6fd7c58f2f7c3-tmp_f2f91a0621c7716b5b03aed603200458.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250401%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250401T062458Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=df68668ebde3f92fbc5cab623df10be617bb8b18e05f84446a8cc4b8925541b1\", \"front\": \"http://yunpang.hejusuan.com:9000/temp/51d3c2de5dcf469186202f4d2b9b2d0f-tmp_42776d3c5903d5607fa2aac1e663801d.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=QPKdC5ZjfmkHmllDehTu%2F20250401%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20250401T062448Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=91faf4ec6233b08846095a4127b787b6ebfc5fa04b8794dce7ae55c29c6d60d2\"}', NULL, NULL, NULL, '{\"sealNo\": \"21cb417701214ec291ad4b11d78b511c\"}', NULL, '2025-03-11 17:11:50', NULL, '2025-04-01 14:23:25', 0, 0); SET FOREIGN_KEY_CHECKS = 1;