登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

zyq/spring-boot-activiti

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
xbk_work_order_task.sql 48.84 KB
一键复制 编辑 原始数据 按行查看 历史
hasee 提交于 2017-03-08 09:50 . init
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371
/*

Navicat MySQL Data Transfer



Source Server         : 192.168.7.2

Source Server Version : 50626

Source Host           : 192.168.7.2:3306

Source Database       : fivestar_finance_framework



Target Server Type    : MYSQL

Target Server Version : 50626

File Encoding         : 65001



Date: 2017-03-08 09:45:21

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for `xbk_work_order_task`

-- ----------------------------

DROP TABLE IF EXISTS `xbk_work_order_task`;

CREATE TABLE `xbk_work_order_task` (

  `personal_task_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户任务编号',

  `user_id` varchar(32) DEFAULT NULL COMMENT '用户编号',

  `task_title` varchar(32) DEFAULT NULL COMMENT '任务标题',

  `task_content` varchar(256) DEFAULT NULL COMMENT '任务内容(工单节点)',

  `task_status` char(1) DEFAULT NULL COMMENT '事宜状态：0：处理中;2:任务已完成',

  `create_time` datetime DEFAULT NULL COMMENT '创建时间',

  `dead_line` datetime DEFAULT NULL COMMENT '截止时间',

  `oper_time` datetime DEFAULT NULL COMMENT '处理时间',

  `process_key` varchar(64) DEFAULT NULL COMMENT '流程key',

  `task_key` varchar(64) DEFAULT NULL COMMENT '任务节点key',

  `process_instance_id` varchar(32) DEFAULT NULL COMMENT '流程实例编号',

  `task_id` varchar(32) DEFAULT NULL COMMENT '流程任务编号',

  `status` char(1) DEFAULT NULL COMMENT '状态：0 正常，1 删除',

  `reserveField1` varchar(255) DEFAULT NULL COMMENT '预留字段',

  `reserveField2` varchar(255) DEFAULT NULL COMMENT '预留字段',

  `reserveField3` varchar(255) DEFAULT NULL COMMENT '预留字段',

  PRIMARY KEY (`personal_task_id`),

  KEY `index_xbk_wot_user_id` (`user_id`),

  KEY `index_xbk_wot_processid` (`process_instance_id`),

  KEY `index_xbk_wot_task_id` (`task_id`)

) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=utf8 COMMENT='待办表';



-- ----------------------------

-- Records of xbk_work_order_task

-- ----------------------------

INSERT INTO `xbk_work_order_task` VALUES ('1183', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '2', '2016-12-28 17:09:44', null, '2017-01-03 11:21:54', 'credit_change_apply', 'outAuditor', '14', '18', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1184', 'zhaochen', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2016-12-28 17:09:44', null, null, 'credit_change_apply', 'outAuditor', '14', '18', '1', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1185', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更终审', '2', '2016-12-28 17:09:59', null, '2016-12-28 17:10:08', 'credit_change_apply', 'finalApprove', '14', '27', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1186', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '2', '2016-12-28 17:17:17', null, '2016-12-28 17:20:35', 'credit_change_apply', 'outAuditor', '34', '38', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1187', 'zhaochen', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2016-12-28 17:17:17', null, null, 'credit_change_apply', 'outAuditor', '34', '38', '1', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1188', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '2', '2016-12-28 17:18:54', null, '2016-12-28 17:21:28', 'credit_change_apply', 'outAuditor', '43', '47', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1189', 'zhaochen', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2016-12-28 17:18:54', null, null, 'credit_change_apply', 'outAuditor', '43', '47', '1', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1190', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更终审', '2', '2016-12-28 17:20:35', null, '2016-12-28 17:20:44', 'credit_change_apply', 'finalApprove', '34', '56', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1191', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更终审', '0', '2016-12-28 17:21:28', null, null, 'credit_change_apply', 'finalApprove', '43', '67', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1192', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '2', '2016-12-28 18:08:26', null, '2016-12-28 18:08:43', 'credit_change_apply', 'outAuditor', '69', '73', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1193', 'zhaochen', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2016-12-28 18:08:26', null, null, 'credit_change_apply', 'outAuditor', '69', '73', '1', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1194', 'admin', '河北省石家庄市Java干活啊贷后授信额度变更申请', '贷后授信额度变更终审', '2', '2016-12-28 18:08:43', null, '2016-12-28 18:10:02', 'credit_change_apply', 'finalApprove', '69', '81', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1195', 'admin', '江苏省南京市测试贷后授信额度变更申请', '贷后授信额度变更终审', '2', '2017-01-03 11:16:29', null, '2017-01-03 11:21:54', 'credit_change_apply', 'finalApprove', '14', '18', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1196', 'admin', '江苏省南京市测试贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-03 11:25:42', null, null, 'credit_change_apply', 'outAuditor', '12514', '12518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1197', 'zhaochen', '江苏省南京市测试贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-03 11:25:42', null, null, 'credit_change_apply', 'outAuditor', '12514', '12518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1198', 'admin', '江苏省南京市测试贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-03 11:35:19', null, null, 'credit_change_apply', 'outAuditor', '12522', '12526', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1199', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-03 15:33:20', null, '2017-01-03 15:36:07', 'xbk-loan-use', 'callCredit', '22514', '22518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1200', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-03 15:36:06', null, '2017-01-03 15:36:19', 'xbk-loan-use', 'cityManagerSurvey', '22514', '22525', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1201', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-03 15:36:19', null, '2017-01-03 15:36:35', 'xbk-loan-use', 'riskManagerApprove', '22514', '22531', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1202', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-03 15:36:35', null, '2017-01-03 15:36:46', 'xbk-loan-use', 'reRiskManagerApprove', '22514', '22537', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1203', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-03 15:36:46', null, '2017-01-03 15:36:54', 'xbk-loan-use', 'capitalApprove', '22514', '22543', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1204', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-03 15:36:54', null, '2017-01-03 15:37:01', 'xbk-loan-use', 'interControlApprove', '22514', '22549', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1205', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-03 15:37:01', null, '2017-01-04 10:26:45', 'xbk-loan-use', 'financeLoan', '22514', '22555', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1206', 'admin', '江苏省南京市null贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-04 09:52:26', null, null, 'credit_change_apply', 'outAuditor', '27514', '27518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1207', 'zhaochen', '江苏省南京市null贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-04 09:52:26', null, null, 'credit_change_apply', 'outAuditor', '27514', '27518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1208', 'admin', '江苏省南京市null贷后授信额度变更申请', '贷后授信额度变更外审调查', '2', '2017-01-04 10:08:21', null, '2017-03-07 16:08:05', 'credit_change_apply', 'outAuditor', '32501', '32505', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1209', 'zhaochen', '江苏省南京市null贷后授信额度变更申请', '贷后授信额度变更外审调查', '0', '2017-01-04 10:08:21', null, null, 'credit_change_apply', 'outAuditor', '32501', '32505', '1', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1210', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 13:46:11', null, '2017-01-04 13:46:55', 'xbk-loan-use', 'callCredit', '40001', '40005', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1211', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 13:46:55', null, '2017-01-04 13:47:13', 'xbk-loan-use', 'cityManagerSurvey', '40001', '40012', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1212', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 13:47:13', null, '2017-01-04 13:47:25', 'xbk-loan-use', 'riskManagerApprove', '40001', '40018', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1213', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 13:47:25', null, '2017-01-04 13:47:38', 'xbk-loan-use', 'reRiskManagerApprove', '40001', '40024', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1214', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 13:47:38', null, '2017-01-04 13:47:51', 'xbk-loan-use', 'capitalApprove', '40001', '40030', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1215', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 13:47:51', null, '2017-01-04 13:48:07', 'xbk-loan-use', 'interControlApprove', '40001', '40036', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1216', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 13:48:07', null, '2017-01-04 15:04:57', 'xbk-loan-use', 'financeLoan', '40001', '40042', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1217', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 14:11:48', null, '2017-01-04 14:12:09', 'xbk-loan-use', 'callCredit', '40056', '40060', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1218', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 14:12:09', null, '2017-01-04 14:12:17', 'xbk-loan-use', 'cityManagerSurvey', '40056', '40067', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1219', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 14:12:17', null, '2017-01-04 14:12:26', 'xbk-loan-use', 'riskManagerApprove', '40056', '40073', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1220', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 14:12:26', null, '2017-01-04 14:12:36', 'xbk-loan-use', 'reRiskManagerApprove', '40056', '40079', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1221', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 14:12:36', null, '2017-01-04 14:12:46', 'xbk-loan-use', 'capitalApprove', '40056', '40085', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1222', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 14:12:46', null, '2017-01-04 14:12:55', 'xbk-loan-use', 'interControlApprove', '40056', '40091', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1223', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 14:12:55', null, '2017-01-04 14:14:03', 'xbk-loan-use', 'financeLoan', '40056', '40097', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1224', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 15:20:27', null, '2017-01-04 15:20:38', 'xbk-loan-use', 'callCredit', '40113', '40117', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1225', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 15:20:38', null, '2017-01-04 15:20:46', 'xbk-loan-use', 'cityManagerSurvey', '40113', '40124', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1226', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 15:20:46', null, '2017-01-04 15:20:52', 'xbk-loan-use', 'riskManagerApprove', '40113', '40130', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1227', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 15:20:52', null, '2017-01-04 15:20:58', 'xbk-loan-use', 'reRiskManagerApprove', '40113', '40136', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1228', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 15:20:58', null, '2017-01-04 15:21:21', 'xbk-loan-use', 'capitalApprove', '40113', '40142', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1229', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 15:21:21', null, '2017-01-04 15:21:29', 'xbk-loan-use', 'interControlApprove', '40113', '40148', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1230', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 15:21:29', null, '2017-01-04 15:27:18', 'xbk-loan-use', 'financeLoan', '40113', '40154', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1231', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 15:42:53', null, '2017-01-04 15:43:03', 'xbk-loan-use', 'callCredit', '40177', '40181', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1232', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 15:43:03', null, '2017-01-04 15:43:10', 'xbk-loan-use', 'cityManagerSurvey', '40177', '40188', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1233', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 15:43:10', null, '2017-01-04 15:43:19', 'xbk-loan-use', 'riskManagerApprove', '40177', '40194', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1234', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 15:43:19', null, '2017-01-04 15:43:27', 'xbk-loan-use', 'reRiskManagerApprove', '40177', '40200', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1235', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 15:43:27', null, '2017-01-04 15:43:36', 'xbk-loan-use', 'capitalApprove', '40177', '40206', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1236', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 15:43:36', null, '2017-01-04 15:43:44', 'xbk-loan-use', 'interControlApprove', '40177', '40212', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1237', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 15:43:44', null, '2017-01-04 15:44:17', 'xbk-loan-use', 'financeLoan', '40177', '40218', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1238', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 15:54:51', null, '2017-01-04 15:55:15', 'xbk-loan-use', 'callCredit', '40229', '40233', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1239', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 15:55:15', null, '2017-01-04 15:55:23', 'xbk-loan-use', 'cityManagerSurvey', '40229', '40240', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1240', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 15:55:23', null, '2017-01-04 15:55:30', 'xbk-loan-use', 'riskManagerApprove', '40229', '40246', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1241', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 15:55:30', null, '2017-01-04 15:55:38', 'xbk-loan-use', 'reRiskManagerApprove', '40229', '40252', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1242', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 15:55:38', null, '2017-01-04 15:55:46', 'xbk-loan-use', 'capitalApprove', '40229', '40258', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1243', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 15:55:46', null, '2017-01-04 15:55:53', 'xbk-loan-use', 'interControlApprove', '40229', '40264', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1244', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 15:55:53', null, '2017-01-04 15:56:44', 'xbk-loan-use', 'financeLoan', '40229', '40270', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1245', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 16:07:33', null, '2017-01-04 16:07:47', 'xbk-loan-use', 'callCredit', '42501', '42505', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1246', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 16:07:47', null, '2017-01-04 16:07:54', 'xbk-loan-use', 'cityManagerSurvey', '42501', '42512', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1247', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 16:07:54', null, '2017-01-04 16:08:01', 'xbk-loan-use', 'riskManagerApprove', '42501', '42518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1248', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 16:08:01', null, '2017-01-04 16:08:08', 'xbk-loan-use', 'reRiskManagerApprove', '42501', '42524', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1249', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 16:08:08', null, '2017-01-04 16:08:16', 'xbk-loan-use', 'capitalApprove', '42501', '42530', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1250', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 16:08:16', null, '2017-01-04 16:08:23', 'xbk-loan-use', 'interControlApprove', '42501', '42536', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1251', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 16:08:23', null, '2017-01-04 16:08:57', 'xbk-loan-use', 'financeLoan', '42501', '42542', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1252', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 16:13:33', null, '2017-01-04 16:14:21', 'xbk-loan-use', 'callCredit', '45001', '45005', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1253', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 16:14:21', null, '2017-01-04 16:14:34', 'xbk-loan-use', 'cityManagerSurvey', '45001', '45012', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1254', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 16:14:34', null, '2017-01-04 16:14:46', 'xbk-loan-use', 'riskManagerApprove', '45001', '45018', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1255', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 16:14:46', null, '2017-01-04 16:14:57', 'xbk-loan-use', 'reRiskManagerApprove', '45001', '45024', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1256', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 16:14:57', null, '2017-01-04 16:15:09', 'xbk-loan-use', 'capitalApprove', '45001', '45030', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1257', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 16:15:09', null, '2017-01-04 16:15:21', 'xbk-loan-use', 'interControlApprove', '45001', '45036', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1258', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 16:15:21', null, '2017-01-04 16:19:40', 'xbk-loan-use', 'financeLoan', '45001', '45042', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1259', 'admin', '江苏省南京市张三用信申请', '用信电核', '2', '2017-01-04 17:03:58', null, '2017-01-04 17:04:18', 'xbk-loan-use', 'callCredit', '47501', '47505', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1260', 'admin', '江苏省南京市张三用信申请', '城市经理尽调', '2', '2017-01-04 17:04:18', null, '2017-01-04 17:04:25', 'xbk-loan-use', 'cityManagerSurvey', '47501', '47512', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1261', 'admin', '江苏省南京市张三用信申请', '风控初审', '2', '2017-01-04 17:04:25', null, '2017-01-04 17:04:34', 'xbk-loan-use', 'riskManagerApprove', '47501', '47518', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1262', 'admin', '江苏省南京市张三用信申请', '风控复审', '2', '2017-01-04 17:04:34', null, '2017-01-04 17:04:40', 'xbk-loan-use', 'reRiskManagerApprove', '47501', '47524', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1263', 'admin', '江苏省南京市张三用信申请', '资金专员审核', '2', '2017-01-04 17:04:40', null, '2017-01-04 17:04:48', 'xbk-loan-use', 'capitalApprove', '47501', '47530', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1264', 'admin', '江苏省南京市张三用信申请', '内控专员审核', '2', '2017-01-04 17:04:48', null, '2017-01-04 17:04:55', 'xbk-loan-use', 'interControlApprove', '47501', '47536', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1265', 'admin', '江苏省南京市张三用信申请', '财务放款', '2', '2017-01-04 17:04:55', null, '2017-01-04 17:06:25', 'xbk-loan-use', 'financeLoan', '47501', '47542', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1266', 'admin', '江苏省南京市陈鹏用信申请', '用信电核', '2', '2017-03-05 17:55:34', null, '2017-03-06 11:06:04', 'xbk-loan-use', 'callCredit', '85001', '85005', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1267', 'admin', '江苏省南京市陈鹏用信申请', '城市经理尽调', '2', '2017-03-06 11:06:04', null, '2017-03-07 17:54:42', 'xbk-loan-use', 'cityManagerSurvey', '85001', '92506', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1268', 'admin', '', '用信电核', '2', '2017-03-07 10:00:14', null, '2017-03-07 13:59:22', 'xbk-loan-use-person', 'callCredit', '97501', '97505', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1269', 'admin', '', '城市经理尽调', '2', '2017-03-07 13:59:21', null, '2017-03-07 13:59:51', 'xbk-loan-use-person', 'cityManagerSurvey', '97501', '100006', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1270', 'admin', '', '风控初审', '2', '2017-03-07 13:59:51', null, '2017-03-07 14:00:15', 'xbk-loan-use-person', 'riskManagerApprove', '97501', '100012', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1271', 'admin', '', '风控复审', '2', '2017-03-07 14:00:15', null, '2017-03-07 15:21:44', 'xbk-loan-use-person', 'reRiskManagerApprove', '97501', '100018', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1272', 'admin', '', '资金专员审核', '2', '2017-03-07 15:21:44', null, '2017-03-07 15:22:17', 'xbk-loan-use-person', 'capitalApprove', '97501', '100024', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1273', 'admin', '', '内控专员审核', '2', '2017-03-07 15:22:17', null, '2017-03-07 15:22:33', 'xbk-loan-use-person', 'interControlApprove', '97501', '100030', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1274', 'admin', '', '财务放款', '0', '2017-03-07 15:22:33', null, null, 'xbk-loan-use-person', 'financeLoan', '97501', '100036', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1275', 'admin', '江苏省南京市null贷后授信额度变更申请', '贷后授信额度变更终审', '0', '2017-03-07 16:08:05', null, null, 'credit_change_apply', 'finalApprove', '32501', '102521', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1276', 'admin', '江苏省南京市陈鹏用信申请', '风控初审', '2', '2017-03-07 17:54:42', null, '2017-03-07 17:54:58', 'xbk-loan-use', 'riskManagerApprove', '85001', '105021', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1277', 'admin', '江苏省南京市陈鹏用信申请', '风控复审', '2', '2017-03-07 17:54:58', null, '2017-03-07 17:55:14', 'xbk-loan-use', 'reRiskManagerApprove', '85001', '105027', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1278', 'admin', '江苏省南京市陈鹏用信申请', '资金专员审核', '2', '2017-03-07 17:55:14', null, '2017-03-07 17:55:30', 'xbk-loan-use', 'capitalApprove', '85001', '105033', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1279', 'admin', '江苏省南京市陈鹏用信申请', '内控专员审核', '2', '2017-03-07 17:55:30', null, '2017-03-07 17:55:46', 'xbk-loan-use', 'interControlApprove', '85001', '105039', '0', null, null, null);

INSERT INTO `xbk_work_order_task` VALUES ('1280', 'admin', '江苏省南京市陈鹏用信申请', '财务放款', '0', '2017-03-07 17:55:45', null, null, 'xbk-loan-use', 'financeLoan', '85001', '105045', '0', null, null, null);



-- ----------------------------

-- Table structure for `xbk_work_order_task_action`

-- ----------------------------

DROP TABLE IF EXISTS `xbk_work_order_task_action`;

CREATE TABLE `xbk_work_order_task_action` (

  `personal_tasks_id` int(11) NOT NULL COMMENT '任务编号',

  `code` varchar(32) DEFAULT NULL COMMENT '处理动作编码',

  `name` varchar(32) DEFAULT NULL COMMENT '动作名称',

  `value` varchar(32) DEFAULT NULL COMMENT '处理完成传入值',

  `document_json` varchar(512) DEFAULT NULL COMMENT '回调操作',

  `task_id` varchar(32) DEFAULT NULL COMMENT '流程任务编号',

  KEY `index_xbk_wota_task_id` (`task_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='待办任务可处理动作';



-- ----------------------------

-- Records of xbk_work_order_task_action

-- ----------------------------

INSERT INTO `xbk_work_order_task_action` VALUES ('1183', 'outAuditor', null, 'flow2', null, '18');

INSERT INTO `xbk_work_order_task_action` VALUES ('1184', 'outAuditor', null, 'flow2', null, '18');

INSERT INTO `xbk_work_order_task_action` VALUES ('1185', 'finalApprove', '拒绝', 'flow4', null, '27');

INSERT INTO `xbk_work_order_task_action` VALUES ('1185', 'finalApprove', '通过', 'flow5', null, '27');

INSERT INTO `xbk_work_order_task_action` VALUES ('1186', 'outAuditor', null, 'flow2', null, '38');

INSERT INTO `xbk_work_order_task_action` VALUES ('1187', 'outAuditor', null, 'flow2', null, '38');

INSERT INTO `xbk_work_order_task_action` VALUES ('1188', 'outAuditor', null, 'flow2', null, '47');

INSERT INTO `xbk_work_order_task_action` VALUES ('1189', 'outAuditor', null, 'flow2', null, '47');

INSERT INTO `xbk_work_order_task_action` VALUES ('1190', 'finalApprove', '拒绝', 'flow4', null, '56');

INSERT INTO `xbk_work_order_task_action` VALUES ('1190', 'finalApprove', '通过', 'flow5', null, '56');

INSERT INTO `xbk_work_order_task_action` VALUES ('1191', 'finalApprove', '拒绝', 'flow4', null, '67');

INSERT INTO `xbk_work_order_task_action` VALUES ('1191', 'finalApprove', '通过', 'flow5', null, '67');

INSERT INTO `xbk_work_order_task_action` VALUES ('1192', 'outAuditor', null, 'flow2', null, '73');

INSERT INTO `xbk_work_order_task_action` VALUES ('1193', 'outAuditor', null, 'flow2', null, '73');

INSERT INTO `xbk_work_order_task_action` VALUES ('1194', 'finalApprove', '拒绝', 'flow4', null, '81');

INSERT INTO `xbk_work_order_task_action` VALUES ('1194', 'finalApprove', '通过', 'flow5', null, '81');

INSERT INTO `xbk_work_order_task_action` VALUES ('1195', 'finalApprove', '拒绝', 'flow4', null, '18');

INSERT INTO `xbk_work_order_task_action` VALUES ('1195', 'finalApprove', '通过', 'flow5', null, '18');

INSERT INTO `xbk_work_order_task_action` VALUES ('1196', 'outAuditor', null, 'flow2', null, '12518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1197', 'outAuditor', null, 'flow2', null, '12518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1198', 'outAuditor', null, 'flow2', null, '12526');

INSERT INTO `xbk_work_order_task_action` VALUES ('1199', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '22518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1199', 'callCredit', '拒绝', 'flow21', null, '22518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1200', 'cityManagerSurvey', '通过', 'flow10', null, '22525');

INSERT INTO `xbk_work_order_task_action` VALUES ('1200', 'cityManagerSurvey', '拒绝', 'flow22', null, '22525');

INSERT INTO `xbk_work_order_task_action` VALUES ('1201', 'riskManagerApprove', '通过', 'flow13', null, '22531');

INSERT INTO `xbk_work_order_task_action` VALUES ('1201', 'riskManagerApprove', '拒绝', 'flow26', null, '22531');

INSERT INTO `xbk_work_order_task_action` VALUES ('1202', 'reRiskManagerApprove', '通过', 'flow15', null, '22537');

INSERT INTO `xbk_work_order_task_action` VALUES ('1202', 'reRiskManagerApprove', '拒绝', 'flow27', null, '22537');

INSERT INTO `xbk_work_order_task_action` VALUES ('1203', 'capitalApprove', '通过', 'flow17', null, '22543');

INSERT INTO `xbk_work_order_task_action` VALUES ('1203', 'capitalApprove', '拒绝', 'flow25', null, '22543');

INSERT INTO `xbk_work_order_task_action` VALUES ('1204', 'interControlApprove', '通过', 'flow19', null, '22549');

INSERT INTO `xbk_work_order_task_action` VALUES ('1204', 'interControlApprove', '拒绝', 'flow24', null, '22549');

INSERT INTO `xbk_work_order_task_action` VALUES ('1205', 'financeLoan', '拒绝', 'flow29', null, '22555');

INSERT INTO `xbk_work_order_task_action` VALUES ('1205', 'financeLoan', '通过', 'flow30', null, '22555');

INSERT INTO `xbk_work_order_task_action` VALUES ('1206', 'outAuditor', null, 'flow2', null, '27518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1207', 'outAuditor', null, 'flow2', null, '27518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1208', 'outAuditor', null, 'flow2', null, '32505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1209', 'outAuditor', null, 'flow2', null, '32505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1210', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '40005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1210', 'callCredit', '拒绝', 'flow21', null, '40005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1211', 'cityManagerSurvey', '通过', 'flow10', null, '40012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1211', 'cityManagerSurvey', '拒绝', 'flow22', null, '40012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1212', 'riskManagerApprove', '通过', 'flow13', null, '40018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1212', 'riskManagerApprove', '拒绝', 'flow26', null, '40018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1213', 'reRiskManagerApprove', '通过', 'flow15', null, '40024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1213', 'reRiskManagerApprove', '拒绝', 'flow27', null, '40024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1214', 'capitalApprove', '通过', 'flow17', null, '40030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1214', 'capitalApprove', '拒绝', 'flow25', null, '40030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1215', 'interControlApprove', '通过', 'flow19', null, '40036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1215', 'interControlApprove', '拒绝', 'flow24', null, '40036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1216', 'financeLoan', '拒绝', 'flow29', null, '40042');

INSERT INTO `xbk_work_order_task_action` VALUES ('1216', 'financeLoan', '通过', 'flow30', null, '40042');

INSERT INTO `xbk_work_order_task_action` VALUES ('1217', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '40060');

INSERT INTO `xbk_work_order_task_action` VALUES ('1217', 'callCredit', '拒绝', 'flow21', null, '40060');

INSERT INTO `xbk_work_order_task_action` VALUES ('1218', 'cityManagerSurvey', '通过', 'flow10', null, '40067');

INSERT INTO `xbk_work_order_task_action` VALUES ('1218', 'cityManagerSurvey', '拒绝', 'flow22', null, '40067');

INSERT INTO `xbk_work_order_task_action` VALUES ('1219', 'riskManagerApprove', '通过', 'flow13', null, '40073');

INSERT INTO `xbk_work_order_task_action` VALUES ('1219', 'riskManagerApprove', '拒绝', 'flow26', null, '40073');

INSERT INTO `xbk_work_order_task_action` VALUES ('1220', 'reRiskManagerApprove', '通过', 'flow15', null, '40079');

INSERT INTO `xbk_work_order_task_action` VALUES ('1220', 'reRiskManagerApprove', '拒绝', 'flow27', null, '40079');

INSERT INTO `xbk_work_order_task_action` VALUES ('1221', 'capitalApprove', '通过', 'flow17', null, '40085');

INSERT INTO `xbk_work_order_task_action` VALUES ('1221', 'capitalApprove', '拒绝', 'flow25', null, '40085');

INSERT INTO `xbk_work_order_task_action` VALUES ('1222', 'interControlApprove', '通过', 'flow19', null, '40091');

INSERT INTO `xbk_work_order_task_action` VALUES ('1222', 'interControlApprove', '拒绝', 'flow24', null, '40091');

INSERT INTO `xbk_work_order_task_action` VALUES ('1223', 'financeLoan', '拒绝', 'flow29', null, '40097');

INSERT INTO `xbk_work_order_task_action` VALUES ('1223', 'financeLoan', '通过', 'flow30', null, '40097');

INSERT INTO `xbk_work_order_task_action` VALUES ('1224', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '40117');

INSERT INTO `xbk_work_order_task_action` VALUES ('1224', 'callCredit', '拒绝', 'flow21', null, '40117');

INSERT INTO `xbk_work_order_task_action` VALUES ('1225', 'cityManagerSurvey', '通过', 'flow10', null, '40124');

INSERT INTO `xbk_work_order_task_action` VALUES ('1225', 'cityManagerSurvey', '拒绝', 'flow22', null, '40124');

INSERT INTO `xbk_work_order_task_action` VALUES ('1226', 'riskManagerApprove', '通过', 'flow13', null, '40130');

INSERT INTO `xbk_work_order_task_action` VALUES ('1226', 'riskManagerApprove', '拒绝', 'flow26', null, '40130');

INSERT INTO `xbk_work_order_task_action` VALUES ('1227', 'reRiskManagerApprove', '通过', 'flow15', null, '40136');

INSERT INTO `xbk_work_order_task_action` VALUES ('1227', 'reRiskManagerApprove', '拒绝', 'flow27', null, '40136');

INSERT INTO `xbk_work_order_task_action` VALUES ('1228', 'capitalApprove', '通过', 'flow17', null, '40142');

INSERT INTO `xbk_work_order_task_action` VALUES ('1228', 'capitalApprove', '拒绝', 'flow25', null, '40142');

INSERT INTO `xbk_work_order_task_action` VALUES ('1229', 'interControlApprove', '通过', 'flow19', null, '40148');

INSERT INTO `xbk_work_order_task_action` VALUES ('1229', 'interControlApprove', '拒绝', 'flow24', null, '40148');

INSERT INTO `xbk_work_order_task_action` VALUES ('1230', 'financeLoan', '拒绝', 'flow29', null, '40154');

INSERT INTO `xbk_work_order_task_action` VALUES ('1230', 'financeLoan', '通过', 'flow30', null, '40154');

INSERT INTO `xbk_work_order_task_action` VALUES ('1231', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '40181');

INSERT INTO `xbk_work_order_task_action` VALUES ('1231', 'callCredit', '拒绝', 'flow21', null, '40181');

INSERT INTO `xbk_work_order_task_action` VALUES ('1232', 'cityManagerSurvey', '通过', 'flow10', null, '40188');

INSERT INTO `xbk_work_order_task_action` VALUES ('1232', 'cityManagerSurvey', '拒绝', 'flow22', null, '40188');

INSERT INTO `xbk_work_order_task_action` VALUES ('1233', 'riskManagerApprove', '通过', 'flow13', null, '40194');

INSERT INTO `xbk_work_order_task_action` VALUES ('1233', 'riskManagerApprove', '拒绝', 'flow26', null, '40194');

INSERT INTO `xbk_work_order_task_action` VALUES ('1234', 'reRiskManagerApprove', '通过', 'flow15', null, '40200');

INSERT INTO `xbk_work_order_task_action` VALUES ('1234', 'reRiskManagerApprove', '拒绝', 'flow27', null, '40200');

INSERT INTO `xbk_work_order_task_action` VALUES ('1235', 'capitalApprove', '通过', 'flow17', null, '40206');

INSERT INTO `xbk_work_order_task_action` VALUES ('1235', 'capitalApprove', '拒绝', 'flow25', null, '40206');

INSERT INTO `xbk_work_order_task_action` VALUES ('1236', 'interControlApprove', '通过', 'flow19', null, '40212');

INSERT INTO `xbk_work_order_task_action` VALUES ('1236', 'interControlApprove', '拒绝', 'flow24', null, '40212');

INSERT INTO `xbk_work_order_task_action` VALUES ('1237', 'financeLoan', '拒绝', 'flow29', null, '40218');

INSERT INTO `xbk_work_order_task_action` VALUES ('1237', 'financeLoan', '通过', 'flow30', null, '40218');

INSERT INTO `xbk_work_order_task_action` VALUES ('1238', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '40233');

INSERT INTO `xbk_work_order_task_action` VALUES ('1238', 'callCredit', '拒绝', 'flow21', null, '40233');

INSERT INTO `xbk_work_order_task_action` VALUES ('1239', 'cityManagerSurvey', '通过', 'flow10', null, '40240');

INSERT INTO `xbk_work_order_task_action` VALUES ('1239', 'cityManagerSurvey', '拒绝', 'flow22', null, '40240');

INSERT INTO `xbk_work_order_task_action` VALUES ('1240', 'riskManagerApprove', '通过', 'flow13', null, '40246');

INSERT INTO `xbk_work_order_task_action` VALUES ('1240', 'riskManagerApprove', '拒绝', 'flow26', null, '40246');

INSERT INTO `xbk_work_order_task_action` VALUES ('1241', 'reRiskManagerApprove', '通过', 'flow15', null, '40252');

INSERT INTO `xbk_work_order_task_action` VALUES ('1241', 'reRiskManagerApprove', '拒绝', 'flow27', null, '40252');

INSERT INTO `xbk_work_order_task_action` VALUES ('1242', 'capitalApprove', '通过', 'flow17', null, '40258');

INSERT INTO `xbk_work_order_task_action` VALUES ('1242', 'capitalApprove', '拒绝', 'flow25', null, '40258');

INSERT INTO `xbk_work_order_task_action` VALUES ('1243', 'interControlApprove', '通过', 'flow19', null, '40264');

INSERT INTO `xbk_work_order_task_action` VALUES ('1243', 'interControlApprove', '拒绝', 'flow24', null, '40264');

INSERT INTO `xbk_work_order_task_action` VALUES ('1244', 'financeLoan', '拒绝', 'flow29', null, '40270');

INSERT INTO `xbk_work_order_task_action` VALUES ('1244', 'financeLoan', '通过', 'flow30', null, '40270');

INSERT INTO `xbk_work_order_task_action` VALUES ('1245', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '42505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1245', 'callCredit', '拒绝', 'flow21', null, '42505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1246', 'cityManagerSurvey', '通过', 'flow10', null, '42512');

INSERT INTO `xbk_work_order_task_action` VALUES ('1246', 'cityManagerSurvey', '拒绝', 'flow22', null, '42512');

INSERT INTO `xbk_work_order_task_action` VALUES ('1247', 'riskManagerApprove', '通过', 'flow13', null, '42518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1247', 'riskManagerApprove', '拒绝', 'flow26', null, '42518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1248', 'reRiskManagerApprove', '通过', 'flow15', null, '42524');

INSERT INTO `xbk_work_order_task_action` VALUES ('1248', 'reRiskManagerApprove', '拒绝', 'flow27', null, '42524');

INSERT INTO `xbk_work_order_task_action` VALUES ('1249', 'capitalApprove', '通过', 'flow17', null, '42530');

INSERT INTO `xbk_work_order_task_action` VALUES ('1249', 'capitalApprove', '拒绝', 'flow25', null, '42530');

INSERT INTO `xbk_work_order_task_action` VALUES ('1250', 'interControlApprove', '通过', 'flow19', null, '42536');

INSERT INTO `xbk_work_order_task_action` VALUES ('1250', 'interControlApprove', '拒绝', 'flow24', null, '42536');

INSERT INTO `xbk_work_order_task_action` VALUES ('1251', 'financeLoan', '拒绝', 'flow29', null, '42542');

INSERT INTO `xbk_work_order_task_action` VALUES ('1251', 'financeLoan', '通过', 'flow30', null, '42542');

INSERT INTO `xbk_work_order_task_action` VALUES ('1252', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '45005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1252', 'callCredit', '拒绝', 'flow21', null, '45005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1253', 'cityManagerSurvey', '通过', 'flow10', null, '45012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1253', 'cityManagerSurvey', '拒绝', 'flow22', null, '45012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1254', 'riskManagerApprove', '通过', 'flow13', null, '45018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1254', 'riskManagerApprove', '拒绝', 'flow26', null, '45018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1255', 'reRiskManagerApprove', '通过', 'flow15', null, '45024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1255', 'reRiskManagerApprove', '拒绝', 'flow27', null, '45024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1256', 'capitalApprove', '通过', 'flow17', null, '45030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1256', 'capitalApprove', '拒绝', 'flow25', null, '45030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1257', 'interControlApprove', '通过', 'flow19', null, '45036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1257', 'interControlApprove', '拒绝', 'flow24', null, '45036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1258', 'financeLoan', '拒绝', 'flow29', null, '45042');

INSERT INTO `xbk_work_order_task_action` VALUES ('1258', 'financeLoan', '通过', 'flow30', null, '45042');

INSERT INTO `xbk_work_order_task_action` VALUES ('1259', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '47505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1259', 'callCredit', '拒绝', 'flow21', null, '47505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1260', 'cityManagerSurvey', '通过', 'flow10', null, '47512');

INSERT INTO `xbk_work_order_task_action` VALUES ('1260', 'cityManagerSurvey', '拒绝', 'flow22', null, '47512');

INSERT INTO `xbk_work_order_task_action` VALUES ('1261', 'riskManagerApprove', '通过', 'flow13', null, '47518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1261', 'riskManagerApprove', '拒绝', 'flow26', null, '47518');

INSERT INTO `xbk_work_order_task_action` VALUES ('1262', 'reRiskManagerApprove', '通过', 'flow15', null, '47524');

INSERT INTO `xbk_work_order_task_action` VALUES ('1262', 'reRiskManagerApprove', '拒绝', 'flow27', null, '47524');

INSERT INTO `xbk_work_order_task_action` VALUES ('1263', 'capitalApprove', '通过', 'flow17', null, '47530');

INSERT INTO `xbk_work_order_task_action` VALUES ('1263', 'capitalApprove', '拒绝', 'flow25', null, '47530');

INSERT INTO `xbk_work_order_task_action` VALUES ('1264', 'interControlApprove', '通过', 'flow19', null, '47536');

INSERT INTO `xbk_work_order_task_action` VALUES ('1264', 'interControlApprove', '拒绝', 'flow24', null, '47536');

INSERT INTO `xbk_work_order_task_action` VALUES ('1265', 'financeLoan', '拒绝', 'flow29', null, '47542');

INSERT INTO `xbk_work_order_task_action` VALUES ('1265', 'financeLoan', '通过', 'flow30', null, '47542');

INSERT INTO `xbk_work_order_task_action` VALUES ('1266', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '85005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1266', 'callCredit', '拒绝', 'flow21', null, '85005');

INSERT INTO `xbk_work_order_task_action` VALUES ('1267', 'cityManagerSurvey', '通过', 'flow10', null, '92506');

INSERT INTO `xbk_work_order_task_action` VALUES ('1267', 'cityManagerSurvey', '拒绝', 'flow22', null, '92506');

INSERT INTO `xbk_work_order_task_action` VALUES ('1268', 'callCredit', '通过', 'flow4', 'applyAmt<30000', '97505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1268', 'callCredit', '拒绝', 'flow21', null, '97505');

INSERT INTO `xbk_work_order_task_action` VALUES ('1269', 'cityManagerSurvey', '通过', 'flow10', null, '100006');

INSERT INTO `xbk_work_order_task_action` VALUES ('1269', 'cityManagerSurvey', '拒绝', 'flow22', null, '100006');

INSERT INTO `xbk_work_order_task_action` VALUES ('1270', 'riskManagerApprove', '通过', 'flow13', null, '100012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1270', 'riskManagerApprove', '拒绝', 'flow26', null, '100012');

INSERT INTO `xbk_work_order_task_action` VALUES ('1271', 'reRiskManagerApprove', '通过', 'flow15', null, '100018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1271', 'reRiskManagerApprove', '拒绝', 'flow27', null, '100018');

INSERT INTO `xbk_work_order_task_action` VALUES ('1272', 'capitalApprove', '通过', 'flow17', null, '100024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1272', 'capitalApprove', '拒绝', 'flow25', null, '100024');

INSERT INTO `xbk_work_order_task_action` VALUES ('1273', 'interControlApprove', '通过', 'flow19', null, '100030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1273', 'interControlApprove', '拒绝', 'flow24', null, '100030');

INSERT INTO `xbk_work_order_task_action` VALUES ('1274', 'financeLoan', '拒绝', 'flow29', null, '100036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1274', 'financeLoan', '通过', 'flow30', null, '100036');

INSERT INTO `xbk_work_order_task_action` VALUES ('1275', 'finalApprove', '拒绝', 'flow4', null, '102521');

INSERT INTO `xbk_work_order_task_action` VALUES ('1275', 'finalApprove', '通过', 'flow5', null, '102521');

INSERT INTO `xbk_work_order_task_action` VALUES ('1276', 'riskManagerApprove', '通过', 'flow13', null, '105021');

INSERT INTO `xbk_work_order_task_action` VALUES ('1276', 'riskManagerApprove', '拒绝', 'flow26', null, '105021');

INSERT INTO `xbk_work_order_task_action` VALUES ('1277', 'reRiskManagerApprove', '通过', 'flow15', null, '105027');

INSERT INTO `xbk_work_order_task_action` VALUES ('1277', 'reRiskManagerApprove', '拒绝', 'flow27', null, '105027');

INSERT INTO `xbk_work_order_task_action` VALUES ('1278', 'capitalApprove', '通过', 'flow17', null, '105033');

INSERT INTO `xbk_work_order_task_action` VALUES ('1278', 'capitalApprove', '拒绝', 'flow25', null, '105033');

INSERT INTO `xbk_work_order_task_action` VALUES ('1279', 'interControlApprove', '通过', 'flow19', null, '105039');

INSERT INTO `xbk_work_order_task_action` VALUES ('1279', 'interControlApprove', '拒绝', 'flow24', null, '105039');

INSERT INTO `xbk_work_order_task_action` VALUES ('1280', 'financeLoan', '拒绝', 'flow29', null, '105045');

INSERT INTO `xbk_work_order_task_action` VALUES ('1280', 'financeLoan', '通过', 'flow30', null, '105045');



-- ----------------------------

-- Table structure for `xbk_work_order_task_form`

-- ----------------------------

DROP TABLE IF EXISTS `xbk_work_order_task_form`;

CREATE TABLE `xbk_work_order_task_form` (

  `processInstanceId` varchar(64) DEFAULT NULL COMMENT '流程编号',

  `taskId` varchar(64) DEFAULT NULL COMMENT '流程任务编号',

  `id` varchar(64) DEFAULT NULL COMMENT '属性ID',

  `name` varchar(64) DEFAULT NULL COMMENT '属性名称',

  `label` varchar(64) DEFAULT NULL COMMENT '展示的lable',

  `value` varchar(64) DEFAULT NULL,

  `inputValue` varchar(128) DEFAULT NULL COMMENT '审批过程输入的数据',

  `createtime` datetime DEFAULT NULL COMMENT '创建时间',

  `inputer` varchar(64) DEFAULT NULL COMMENT '审批人',

  `bussnessKey` varchar(32) DEFAULT NULL COMMENT '业务编号',

  `required` varchar(8) DEFAULT NULL COMMENT '是否必输[可选]',

  `rule` varchar(128) DEFAULT NULL COMMENT '输入规则校验[可选]',

  `message` varchar(128) DEFAULT NULL COMMENT '错误提示信息[可选]',

  `tableName` varchar(128) DEFAULT NULL COMMENT '表名[可选]',

  `fieldName` varchar(128) DEFAULT NULL COMMENT '字段名[可选]',

  `pkField` varchar(128) DEFAULT NULL COMMENT '主键[可选]'

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='动态表单';



-- ----------------------------

-- Records of xbk_work_order_task_form

-- ----------------------------
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/zyqjava/spring-boot-activiti.git
git@gitee.com:zyqjava/spring-boot-activiti.git
zyqjava
spring-boot-activiti
spring-boot-activiti
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部