【无标题】

于 2023-11-13 18:17:52 发布
阅读量68 收藏
点赞数
文章标签： android
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_47185320/article/details/134383399
版权 
/*
 Navicat Premium Data Transfer

 Source Server         : electronic
 Source Server Type    : MySQL
 Source Server Version : 50742
 Source Host           : 192.168.10.60:30308
 Source Schema         : tencent_sign

 Target Server Type    : MySQL
 Target Server Version : 50742
 File Encoding         : 65001

 Date: 13/11/2023 18:07:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_contractcancel
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractcancel`;
CREATE TABLE `tb_contractcancel`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转交的合同流程ID',
  `Cost` int(11) NULL DEFAULT NULL COMMENT '此合同流程返还的合同份额, 注意: 此字段为负数表示返回额度',
  `CostChannel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '此合同流程消耗对应计费版本, 现在的计费版本有企业版,在线签约,战略签约,群闪签,单方签章等, 一般为企业版',
  `IsResell` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IsResell',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同撤销扣费返还通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractcancel
-- ----------------------------

-- ----------------------------
-- Table structure for tb_contractdeduction_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractdeduction_notify`;
CREATE TABLE `tb_contractdeduction_notify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发起此合同的第三方平台子客企业员工的唯一标识',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转交的合同流程ID',
  `Cost` int(11) NULL DEFAULT NULL COMMENT '此合同流程消耗的合同份额, 固定为1',
  `CostChannel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '此合同流程消耗对应计费版本, 现在的计费版本有企业版,在线签约,战略签约,群闪签,单方签章等, 一般为企业版',
  `IsResell` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '此合同流程消耗是否是分销场景下的消费',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同发起扣费通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractdeduction_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_contractreview_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractreview_notify`;
CREATE TABLE `tb_contractreview_notify`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行对应审核动作的第三方平台子客企业员工的唯一标识',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核的合同流程ID',
  `DocumentId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核的合同流程的PDF文档的编号ID',
  `FlowName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核的合同流程的名称',
  `Operate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核动作;CreateFlowReviewStart：提交发起审核\r\nCreateFlowReviewPass：发起审核通过\r\nCreateFlowReviewReject：发起审核拒绝',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同审核通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractreview_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_contractstatuschange_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractstatuschange_notify`;
CREATE TABLE `tb_contractstatuschange_notify`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `CustomerData` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建签署流程时候传递的CustomerData参数',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的合同流程ID',
  `FlowName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的合同流程的名称',
  `FlowType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的合同流程的类别分类',
  `FlowStatus` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同状态',
  `FlowMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当合同流程状态为合同拒签, 合同撤回等状态时，此字段为拒签或撤销原因，其他状态时此字段为空值',
  `CreateOn` int(50) NULL DEFAULT NULL COMMENT '合同流程的创建时间戳',
  `Deadline` int(50) NULL DEFAULT NULL COMMENT '签署流程的签署截止时间',
  `OccurTime` int(50) NULL DEFAULT NULL COMMENT '此回调触发的时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同状态变动通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractstatuschange_notify
-- ----------------------------
INSERT INTO `tb_contractstatuschange_notify` VALUES (1, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (2, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (3, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (4, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (5, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (6, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (7, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (8, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (9, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (10, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);
INSERT INTO `tb_contractstatuschange_notify` VALUES (11, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', 'org_dianziqian', 'data', 'yDwFdUUckpsveo27UEQPEVo14KnASuGI', '2023年采购西红柿50吨合同', '采购合同', 'REJECT', '张三因为合同中的价格问题不满意而拒绝合同', 1563968167, 1563968167, 1563968167);

-- ----------------------------
-- Table structure for tb_contractstatuschange_notify_ccinfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractstatuschange_notify_ccinfo`;
CREATE TABLE `tb_contractstatuschange_notify_ccinfo`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `tb_contractstatuschange_notify_id` bigint(11) NULL DEFAULT NULL COMMENT 'tb_contractstatuschange_notify_id是针对tb_contractstatuschange_notify表的外键',
  `Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被抄送人手机号',
  `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被抄送人姓名',
  `CcType` int(11) NULL DEFAULT NULL COMMENT '被抄送人类型 0--个人. 1--员工',
  `CcPermission` int(11) NULL DEFAULT NULL COMMENT '被抄送人权限 0--可查看 1--可查看也可下载',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_contractstatuschange_notify_id`(`tb_contractstatuschange_notify_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同(流程)关注方信息列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractstatuschange_notify_ccinfo
-- ----------------------------

-- ----------------------------
-- Table structure for tb_contractstatuschange_notify_flowapproverinfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractstatuschange_notify_flowapproverinfo`;
CREATE TABLE `tb_contractstatuschange_notify_flowapproverinfo`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `tb_contractstatuschange_notify_id` bigint(11) NULL DEFAULT NULL COMMENT 'tb_contractstatuschange_notify_id是针对tb_contractstatuschange_notify表的外键',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业员工的唯一标识',
  `ProxyOrganizationName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业的名称',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业的唯一标识',
  `PhoneNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人的手机号',
  `SignOrder` int(11) NULL DEFAULT NULL COMMENT '签署人的签署顺序',
  `RecipientId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人的参与角色ID',
  `ApproveName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人的名字',
  `ApproveStatus` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人的状态',
  `ApproveMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人状态的简单描述',
  `ApproveTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人签署此合同的时间',
  `CaSign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应签署人签署此合同的证书信息, 此功能为白名单功能, 使用前请联系对接的客户经理沟通。',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_contractstatuschange_notify_id`(`tb_contractstatuschange_notify_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同(流程)签署人信息列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractstatuschange_notify_flowapproverinfo
-- ----------------------------
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (7, 8, 'n9527', '典子谦示例企业', 'org_dianziqian', '13200000000', 1, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', '典子谦', 'ACCEPT', '已签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (8, 8, '', '', '', '18888888888', 2, 'yDRS4UUgygqdcj56UuO4zjExBQcOiB68', '张三', 'PENDING', '待签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (9, 9, 'n9527', '典子谦示例企业', 'org_dianziqian', '13200000000', 1, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', '典子谦', 'ACCEPT', '已签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (10, 9, '', '', '', '18888888888', 2, 'yDRS4UUgygqdcj56UuO4zjExBQcOiB68', '张三', 'PENDING', '待签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (11, 10, 'n9527', '典子谦示例企业', 'org_dianziqian', '13200000000', 1, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', '典子谦', 'ACCEPT', '已签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (12, 10, '', '', '', '18888888888', 2, 'yDRS4UUgygqdcj56UuO4zjExBQcOiB68', '张三', 'PENDING', '待签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (13, 11, 'n9527', '典子谦示例企业', 'org_dianziqian', '13200000000', 1, 'yDwFkUUckpstzjhfUugNAWf1KibXqS26', '典子谦', 'ACCEPT', '已签署', '1563968167', '');
INSERT INTO `tb_contractstatuschange_notify_flowapproverinfo` VALUES (14, 11, '', '', '', '18888888888', 2, 'yDRS4UUgygqdcj56UuO4zjExBQcOiB68', '张三', 'PENDING', '待签署', '1563968167', '');

-- ----------------------------
-- Table structure for tb_contractstatuschange_notify_flowgroupmessage
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractstatuschange_notify_flowgroupmessage`;
CREATE TABLE `tb_contractstatuschange_notify_flowgroupmessage`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `tb_contractstatuschange_notify_id` bigint(11) NULL DEFAULT NULL COMMENT 'tb_contractstatuschange_notify_id是针对tb_contractstatuschange_notify表的外键',
  `FlowGroupId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同组的ID',
  `FlowGroupName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同组的名称',
  `CreateOn` bigint(11) NULL DEFAULT NULL COMMENT '合同组的创建时间戳',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_contractstatuschange_notify_id`(`tb_contractstatuschange_notify_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同组的信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractstatuschange_notify_flowgroupmessage
-- ----------------------------
INSERT INTO `tb_contractstatuschange_notify_flowgroupmessage` VALUES (1, 10, 'yDRS4UUgygqdcj2tUuO4zjEEFuP35Swc', '2023年蔬菜采购合作组', 1563968167329);
INSERT INTO `tb_contractstatuschange_notify_flowgroupmessage` VALUES (2, 11, 'yDRS4UUgygqdcj2tUuO4zjEEFuP35Swc', '2023年蔬菜采购合作组', 1563968167329);

-- ----------------------------
-- Table structure for tb_contractstatuschange_notify_flowgroupmessage_flowsinfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_contractstatuschange_notify_flowgroupmessage_flowsinfo`;
CREATE TABLE `tb_contractstatuschange_notify_flowgroupmessage_flowsinfo`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `tb_contractstatuschange_notify_FlowGroupMessage_id` bigint(11) NULL DEFAULT NULL COMMENT 'tb_contractstatuschange_notify_FlowGroupMessage_id是tb_contractstatuschange_notify_FlowGroupMessage的外键',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合同组里边流程的ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_contractstatuschange_notify_FlowGroupMessage_id`(`tb_contractstatuschange_notify_FlowGroupMessage_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合同组中每个合同流程的信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_contractstatuschange_notify_flowgroupmessage_flowsinfo
-- ----------------------------
INSERT INTO `tb_contractstatuschange_notify_flowgroupmessage_flowsinfo` VALUES (5, 2, 'yDwFdUUckpsveo27UEQPEVo14KnASuGI');
INSERT INTO `tb_contractstatuschange_notify_flowgroupmessage_flowsinfo` VALUES (6, 2, 'yDRSRUUgygj6qnwfUuO4zjEwc193c2hH');

-- ----------------------------
-- Table structure for tb_documentsynthesized_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_documentsynthesized_notify`;
CREATE TABLE `tb_documentsynthesized_notify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `TaskId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '合成任务Id',
  `DocumentFileStatus` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '处理状态;一般是成功-SUCCESS',
  `ResourceUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'PDF文档资源链接',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文档合成完成后回调通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_documentsynthesized_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_AuthorizedUsersInfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_AuthorizedUsersInfo`;
CREATE TABLE `tb_org_AuthorizedUsersInfo`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `OpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被授予此印章权限的第三方平台子客企业员工的唯一标识',
  `tb_org_stamprelatedId` bigint(11) NULL DEFAULT NULL COMMENT 'tb_org_stamprelated 表的主键',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_org_stamprelatedId`(`tb_org_stamprelatedId`) USING BTREE,
  CONSTRAINT `tb_org_AuthorizedUsersInfo_ibfk_1` FOREIGN KEY (`tb_org_stamprelatedId`) REFERENCES `tb_org_stamprelated` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '印章创建、删除、停用、启用、授权/解除授权回调表的关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_AuthorizedUsersInfo
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_auditresult
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_auditresult`;
CREATE TABLE `tb_org_auditresult`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `OperateSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否审核通过，1为是，0为否',
  `CertifyReason` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '如果审核不通过, 此字段表示不通过的原因',
  `OperateTime` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核的时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '授权书审核结果' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_auditresult
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_authorizationmanager
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_authorizationmanager`;
CREATE TABLE `tb_org_authorizationmanager`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权的第三方平台子客企业员工的唯一标识',
  `FirstAuth` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否首次授权,1为是，0为否',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '经办人授权通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_authorizationmanager
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_basicinfomodify
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_basicinfomodify`;
CREATE TABLE `tb_org_basicinfomodify`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `OrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `OrganizationName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的名字',
  `LegalName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的法人姓名',
  `Region` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的企业原地区',
  `Address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的企业原详细地区',
  `Operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进行变动的企业员工的名字',
  `OperateTime` int(255) NULL DEFAULT NULL COMMENT '进行变动的Unix时间戳',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业基础信息修改通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_basicinfomodify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_businesscancellation
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_businesscancellation`;
CREATE TABLE `tb_org_businesscancellation`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `OrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `OrganizationName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原的名字',
  `OperatorName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进行注销的企业员工的名字',
  `CloseTime` int(255) NULL DEFAULT NULL COMMENT '注销的时间的Unix时间戳',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业注销通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_businesscancellation
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_joinenterprise
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_joinenterprise`;
CREATE TABLE `tb_org_joinenterprise`  (
  `id` bigint(11) NULL DEFAULT NULL COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加入企业的第三方平台子客企业员工的唯一标识'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工加入企业通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_joinenterprise
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_notify`;
CREATE TABLE `tb_org_notify`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用id',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方组织id',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方操作人id',
  `AuthSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权结果;1为是 0为否',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1719964434443870218 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '平台企业授权电子签通知表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_notify
-- ----------------------------
INSERT INTO `tb_org_notify` VALUES (1, '11', '武汉', '1111', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870212, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870213, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870214, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870215, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870216, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');
INSERT INTO `tb_org_notify` VALUES (1719964434443870217, 'yDwiCUUg58vqznUn30LGB4hojoDHRrL1', 'yDR4GUUsjb9foUxVAqccfdSddBNYD8PzB', 'yDR4GUUsjb9AqccxS', '1');

-- ----------------------------
-- Table structure for tb_org_opensign
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_opensign`;
CREATE TABLE `tb_org_opensign`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开通服务的第三方平台子客企业员工的唯一标识',
  `ProxyAppId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子企业的ProxyAppId, 现在还没有地方使用此ProxyAppId, 可忽略',
  `OpenSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否开通,1为是，0为否',
  `OrganizationName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子企业的企业名字',
  `USCC` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子企业的企业社会统一信用代码',
  `LegalName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子企业的法人的姓名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业开通电子签服务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_opensign
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_organizationchangebaseinfodetail
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_organizationchangebaseinfodetail`;
CREATE TABLE `tb_org_organizationchangebaseinfodetail`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `OrganizationNameNew` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业新的名字',
  `LegalNameNew` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业新的法人姓名',
  `RegionNew` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的企业新的地区',
  `AddressNew` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业原来的企业新的详细地区',
  `tb_org_basicinfomodifyId` bigint(11) NULL DEFAULT NULL COMMENT '企业基础信息修改通知表的主键',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `tb_org_basicinfomodifyId`(`tb_org_basicinfomodifyId`) USING BTREE,
  CONSTRAINT `tb_org_organizationchangebaseinfodetail_ibfk_1` FOREIGN KEY (`tb_org_basicinfomodifyId`) REFERENCES `tb_org_basicinfomodify` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '新的企业信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_organizationchangebaseinfodetail
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_overpipechange
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_overpipechange`;
CREATE TABLE `tb_org_overpipechange`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ChangeToUserOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新的超管的企业的第三方平台子客企业员工的唯一标识',
  `ChangeToUserName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新的超管的名字',
  `ChangeToUserMobile` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新的超管的手机号',
  `OldAdminOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老的超管的企业的第三方平台子客企业员工的唯一标识',
  `OldAdminName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老的超管的名字',
  `OldAdminMobile` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '老的超管的手机号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '超管变更通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_overpipechange
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_reviewresultscallback
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_reviewresultscallback`;
CREATE TABLE `tb_org_reviewresultscallback`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `OrgName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业的名字',
  `OpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业员工的唯一标识',
  `AuditSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否审核通过,1为是，0为否',
  `FailReason` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '如果审核不通过, 此字段为不通过的原因',
  `OperateTime` int(255) NULL DEFAULT NULL COMMENT '进行审核时间的Unix时间戳',
  `OperatorUserId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作人在电子签的userId',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业收录申请审核结果回调' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_reviewresultscallback
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_rolechange
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_rolechange`;
CREATE TABLE `tb_org_rolechange`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被变动角色的员工的第三方平台子客企业员工的唯一标识',
  `BeforeRoleNames` json NULL COMMENT '老的角色的名字列表',
  `AfterRoleNames` json NULL COMMENT '新的角色的名字列表',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工变更角色通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_rolechange
-- ----------------------------
INSERT INTO `tb_org_rolechange` VALUES (1, 'yDxbWUyKQDxgXVUuO4zjEB8mxCcDjAyF', 'org_dianziqian', 'n1357', '[\"普通经办员\", \"业务管理员\"]', '[\"普通经办员\"]');

-- ----------------------------
-- Table structure for tb_org_sealauditresult
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_sealauditresult`;
CREATE TABLE `tb_org_sealauditresult`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `SealId` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的印章ID，为32位字符串',
  `SealName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的印章的名称',
  `SealType` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的印章类型, 类型的值为下面: OFFICIAL:企业公章 CONTRACT:企业合同专用章 ORGANIZATION_SEAL:客户本地上传的企业印章 LEGAL_PERSON_SEAL:客户本地上传的法人印章 FINANCE:财务专用章 PERSONNEL:人事专用章',
  `ReviewStatus` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子签平台审核的结果, 结果的值: PASS:审核通过 REJECT:审核驳回',
  `ReviewReason` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核驳回时, 此字段表示驳回的原因',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '印章审核结果通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_sealauditresult
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_stamprelated
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_stamprelated`;
CREATE TABLE `tb_org_stamprelated`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行对应印章动作的第三方平台子客企业员工的唯一标识',
  `AuthorizedOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1. 如果印章授权给员工的行为, 此处为被授权员工的OpenId 2. 如果是取消某员工的印章授权, 此处为被取消授权员工的OpenId 3. 其他印章行为没有此字段',
  `SealId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的印章ID，为32位字符串',
  `SealType` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应的印章类型, 类型的值为下面: OFFICIAL:企业公章 CONTRACT:企业合同专用章 ORGANIZATION_SEAL:客户本地上传的企业印章 LEGAL_PERSON_SEAL:客户本地上传的法人印章 FINANCE:财务专用章 PERSONNEL:人事专用章',
  `Operate` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '印章行为, 可以参考上面的 会出现的印章Operate行为',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '印章创建、删除、停用、启用、授权/解除授权回调' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_stamprelated
-- ----------------------------
INSERT INTO `tb_org_stamprelated` VALUES (10, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (11, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (12, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (13, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (14, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (15, 'yDw7aUUggcwlkmUE3j0uLyNljphArPGW', 'tess', 'n9522', NULL, 'yDSL5UUg2hmlkjUh7NMEvbInLLQpuqjw', 'OFFICIAL', 'Enable');
INSERT INTO `tb_org_stamprelated` VALUES (16, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (17, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (18, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Invalid');
INSERT INTO `tb_org_stamprelated` VALUES (19, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (20, 'yDw7aUUggcwlkmUE3j0uLyNljphArPGW', 'tess', 'n9522', NULL, 'yDSL5UUg2hmlkjUh7NMEvbInLLQpuqjw', 'OFFICIAL', 'Enable');
INSERT INTO `tb_org_stamprelated` VALUES (21, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Invalid');
INSERT INTO `tb_org_stamprelated` VALUES (22, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (23, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (24, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Invalid');
INSERT INTO `tb_org_stamprelated` VALUES (25, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (26, 'yDSL5UUg2ltsxrUTQQ1W8Fy36yPZo2hS', 'tess', 'n9522', NULL, 'yDSL5UUg28du4aUElFY9m1gcfZCJY6xO', 'CONTRACT', 'Valid');
INSERT INTO `tb_org_stamprelated` VALUES (27, 'yDw7aUUggcwlkmUE3j0uLyNljphArPGW', 'tess', 'n9522', NULL, 'yDSL5UUg2hmlkjUh7NMEvbInLLQpuqjw', 'OFFICIAL', 'Enable');

-- ----------------------------
-- Table structure for tb_org_templateaddition
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_templateaddition`;
CREATE TABLE `tb_org_templateaddition`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '如果第三方子企业员工签署, 此字段为第三方子企业员工的唯一标识',
  `TemplateId` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板ID，为32位字符串',
  `TemplateName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板名称',
  `CreateTime` int(255) NULL DEFAULT NULL COMMENT '此模板的创建时间,格式为Unix标准时间戳（秒）',
  `ChannelTemplateId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '若为领用模板，此字段为对应第三方平台模板id',
  `ChannelTemplateName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '若为领用模板，此字段为对应第三方平台模板名称',
  `SaveType` int(255) NULL DEFAULT NULL COMMENT '模板是否自动设置为子客模板，0-需要子客手动领取的模板，1-自动设置子客模板',
  `TemplateVersion` int(255) NULL DEFAULT NULL COMMENT '模板版本号。默认为空时，初始版本为yyyyMMdd000。全数字字符',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板新增通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_templateaddition
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_templatedeletion
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_templatedeletion`;
CREATE TABLE `tb_org_templatedeletion`  (
  `id` bigint(11) NULL DEFAULT NULL COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '如果第三方子企业员工签署, 此字段为第三方子企业员工的唯一标识',
  `TemplateId` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板ID，为32位字符串',
  `TemplateName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板名称',
  `DeleteTime` int(255) NULL DEFAULT NULL COMMENT '此模板的删除时间,格式为Unix标准时间戳（秒）'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板删除通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_templatedeletion
-- ----------------------------

-- ----------------------------
-- Table structure for tb_org_templatemodification
-- ----------------------------
DROP TABLE IF EXISTS `tb_org_templatemodification`;
CREATE TABLE `tb_org_templatemodification`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识，定义Agent中的ProxyOrganizationOpenId一样, 可以参考Agent结构体',
  `ProxyOperatorOpenId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '如果第三方子企业员工签署, 此字段为第三方子企业员工的唯一标识',
  `TemplateId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板ID，为32位字符串',
  `TemplateName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板名称',
  `UpdateTime` int(255) NULL DEFAULT NULL COMMENT '此模板的修改时间,格式为Unix标准时间戳（秒）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模板修改通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_org_templatemodification
-- ----------------------------

-- ----------------------------
-- Table structure for tb_orgauthorizesdownload_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_orgauthorizesdownload_notify`;
CREATE TABLE `tb_orgauthorizesdownload_notify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业员工的唯一标识',
  `AuthSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '认证结果;开通完成固定为true',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合作企业授权下载合同通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_orgauthorizesdownload_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_orgcancellationauthorization_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_orgcancellationauthorization_notify`;
CREATE TABLE `tb_orgcancellationauthorization_notify`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业员工的唯一标识',
  `AuthSuccess` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '处理结果;取消完成固定为false',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '合作企业取消授权下载合同通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_orgcancellationauthorization_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_signContractfailure_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_signContractfailure_notify`;
CREATE TABLE `tb_signContractfailure_notify`  (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方子企业员工的唯一标识',
  `TemplateId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板ID',
  `QrCodeId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '触发回调的模板ID',
  `FlowName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签署二维码生成的合同名称',
  `CreateResult` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建结果，固定为失败-false;固定为失败-false',
  `Reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败原因;一般是 合同份额为0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '签署二维码发起合同失败通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_signContractfailure_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_silentsign_notify
-- ----------------------------
DROP TABLE IF EXISTS `tb_silentsign_notify`;
CREATE TABLE `tb_silentsign_notify`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `AuthorizationApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `AuthorizationOrganizationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权子客企业的企业ID',
  `AuthorizationOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权子客企业的唯一标识',
  `AuthorizedOrganizationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被授权子客企业的企业ID',
  `AuthorizedOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '被授权子客企业的唯一标识',
  `AuthorizedStatus` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权状态',
  `OperateTime` int(11) NULL DEFAULT NULL COMMENT '授权状态变更时间戳',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '他方静默签授权通知' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_silentsign_notify
-- ----------------------------

-- ----------------------------
-- Table structure for tb_transfersigntask
-- ----------------------------
DROP TABLE IF EXISTS `tb_transfersigntask`;
CREATE TABLE `tb_transfersigntask`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ApplicationId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方应用的应用编号',
  `ProxyOrganizationOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台子客企业的唯一标识',
  `ProxyOperatorOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转交此合同的第三方平台子客企业员工的唯一标识',
  `FlowId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转交的合同流程ID',
  `ForwardedOpenId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接收此合同的第三方平台子客企业员工的唯一标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '转交签署任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_transfersigntask
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;

qq_47185320
关注
mysql8导出5的sql_Mysql 8.0版本导出的sql文件在Mysql 5.5中运行出错
weixin_30675619的博客
02-02 801
出现错误[err] 1064 - you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near '(0) null default current_timestamp(0) on update ...
c#实现无标题栏窗口的拖动
09-05
本篇文章将详细讲解如何在C#中实现这种无标题栏窗口的拖动以及其他基本操作。 首先，为了实现无标题栏窗口的拖动，我们需要处理窗体的鼠标事件。窗体的`FormBorderStyle`属性应设置为`None`，这会去除窗体的边框和...
springboot简单之整合（三）
ku_xin的博客
04-21 552
一、目录 1.数据库表user.sql文件 /* Navicat Premium Data Transfer Source Server : vmroot Source Server Type : MySQL Source Server Version : 80013 Source Host : 127.0.0.1:3306 Sour...
MySql练习题_1
最新发布
weixin_45362928的博客
06-23 137
【代码】MySql练习题_1。
查询入门
x_xiaoge的专栏
04-13 404
数据库创建代码执行
AsBefore麦小兜
04-05 256
/* Navicat MySQL Data Transfer Source Server : 192.168.244.128 Source Server Version : 50732 Source Host : 192.168.244.128:3306 Source Database : rebuild_3d_user_db Target Server Type : MYSQL Target Server Version : 50732 File.
Qt无标题窗口
05-21
在本文中，我们将深入探讨如何使用Qt框架创建一个无标题窗口，这在界面设计和自定义标题栏美化中非常有用。我们将关注`framelesswidget.cpp`、`main.cpp`、`framelesswidget.h`等核心文件，理解它们在实现无标题窗口...
C#创建无标题栏窗体
03-16
摘要:C#源码,菜单窗体,无标题栏窗体　C#创建无标题栏窗体源码，实际上是动态显示或隐藏窗体的标题栏，当隐藏的时候就类似窗体没有了标题栏，当显示标题栏的时候，鼠标按住标题栏即可拖动窗体，以前记得网友需要此...
Delphi实现拖动按钮移动无标题栏窗口
05-11
摘要:Delphi源码,界面编程,窗体拖动,无标题栏 无标题栏的窗体的拖动功能实现，Delphi添加一个可拖动窗体的按钮，通过对此按钮的控制可移动窗体，实现按住标题栏移动窗口的功能，无标题栏也就不能显示最大化、最小化...
VC去掉'无标题'字样的方法.zip
11-21
在使用Visual C++进行编程时，我们经常会在创建新的窗口或者对话框时默认看到标题栏显示为“无标题”。这可能会对用户界面的美观性和专业性造成一定的影响。本资料包提供了一种方法来帮助开发者去掉这个“无标题”...
11.zipSource Server : changgou Source Server Type : MySQL Source Se
11-14
Source Server : changgou Source Server Type : MySQL Source Server Version : 50726 Source Host : 192.168.159.134:3306 Source Schema : changgou_all Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001
从sql里面读取数据至dataset，很不错的例子
07-31
从sql里面读取数据至dataset，很不错的例子
SpringBook搭建的简单增删改查，前端使用的Layui
qq_50966209的博客
11-12 1394
SpringBook搭建的简单增删改查，前端使用的Layui 数据库 用户数据 Navicat MySQL Data Transfer Source Server : MySol Source Server Version : 50728 Source Host : localhost:3306 Source Database : 123 Target Server Type : MYSQL Target Server Version : 50728
navicat mysql
cn_wk的专栏
09-27 1556
/* Navicat MySQL Data Transfer -- Navicat MySQL数据转换信息 Source Server : localhost_3307 -- 源服务器 Source Server Version : 50022 -- 源服务器版本 Source H
JAVA工程启动时自动创建数据库、数据表
热门推荐
爱码少年 00fly.online 的博客
11-08 1万+
很多时候，我们会有这样的需求： 1. 系统首次部署时，自动创建数据库、表 2. 执行单元测试时，数据库、表维持初始化状态方便测试。
springboot整合spring security
txyllyyj的博客
11-18 848
导入sql /* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80011 Source Host : localhost:3306 Source Schema : securitydemo Target Server Type : MySQL Targe
php数据库函数设计,php基础-函数创建数据库创建
weixin_39963080的博客
03-19 228
/*NavicatMySQLDataTransferSourceServer:本地SourceServerVersion:50553SourceHost:localhost:3306SourceDatabase:luhengTargetServerType:MYSQLTargetServerVersi...
创建自己的Source Server
int_tulip的专栏
03-29 2095
https://msdn.microsoft.com/en-us/library/ms680641
MYSQL必知必会使用数据
et2967627664的博客
06-24 685
MYSQL必知必会使用数据 student表 /* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50729 Source Host : localhost:3306 Source Database : mysqltest Target Server Type : MYSQL Target Server Version : 50729 File En
Visual C++移除无标题窗口字样的技巧
资源摘要信息:"VC去掉'无标题'字样的方法.zip" 在使用Visual C++（简称VC++）进行Windows应用程序开发时，有时会发现新建的窗口默认标题栏显示为“无标题”，这通常是因为窗口的标题没有被正确设置。本压缩包提供的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值