comment_column_bpm.sql
109 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
ALTER TABLE `bpm_agent_condition` CHANGE `SETTING_ID_` `SETTING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '设定ID';
ALTER TABLE `bpm_agent_condition` CHANGE `CONDITION_DESC_` `CONDITION_DESC_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '条件描述';
ALTER TABLE `bpm_agent_condition` CHANGE `CONDITION_` `CONDITION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '条件';
ALTER TABLE `bpm_agent_condition` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人ID';
ALTER TABLE `bpm_agent_condition` CHANGE `AGENT_NAME_` `AGENT_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人';
ALTER TABLE `bpm_agent_def` CHANGE `SETTING_ID_` `SETTING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '设定ID';
ALTER TABLE `bpm_agent_def` CHANGE `FLOW_KEY_` `FLOW_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY';
ALTER TABLE `bpm_agent_def` CHANGE `FLOW_NAME_` `FLOW_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义名称';
ALTER TABLE `bpm_agent_def` CHANGE `NODE_ID_` `NODE_ID_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点定义ID(为空的情况,如果指定ID,那么代理只在这些ID的任务生效)';
ALTER TABLE `bpm_agent_def` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_agent_setting` CHANGE `SUBJECT_` `SUBJECT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '标题';
ALTER TABLE `bpm_agent_setting` CHANGE `AUTH_ID_` `AUTH_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '授权人ID';
ALTER TABLE `bpm_agent_setting` CHANGE `AUTH_NAME_` `AUTH_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '授权人姓名';
ALTER TABLE `bpm_agent_setting` CHANGE `IS_ENABLED_` `IS_ENABLED_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否有效';
ALTER TABLE `bpm_agent_setting` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人ID';
ALTER TABLE `bpm_agent_setting` CHANGE `AGENT_` `AGENT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人';
ALTER TABLE `bpm_agent_setting` CHANGE `FLOW_KEY_` `FLOW_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY';
ALTER TABLE `bpm_agent_setting` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '代理类型(1,全权代理,2,部分代理,3.条件代理)';
ALTER TABLE `bpm_agent_setting` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_agent_setting` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID';
ALTER TABLE `bpm_agent_setting` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_agent_setting` CHANGE `TENANT_ID_` `TENANT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '租户id';
ALTER TABLE `bpm_approval_item` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户ID';
ALTER TABLE `bpm_approval_item` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义KEY';
ALTER TABLE `bpm_approval_item` CHANGE `DEF_NAME_` `DEF_NAME_` char(10) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义名称';
ALTER TABLE `bpm_approval_item` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程分类ID';
ALTER TABLE `bpm_approval_item` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '常用语类型
默认为1=全局
2=流程分类
3=流程
4=个人的常用语';
ALTER TABLE `bpm_approval_item` CHANGE `EXPRESSION_` `EXPRESSION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '常用语 多个项用回车分开';
ALTER TABLE `bpm_approval_item` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_approval_item` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人所属组织ID';
ALTER TABLE `bpm_approval_item` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_approval_org` CHANGE `APPROVAL_ID_` `APPROVAL_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '常用语';
ALTER TABLE `bpm_approval_org` CHANGE `POST_ID_` `POST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '岗位';
ALTER TABLE `bpm_approval_org` CHANGE `ROLE_ID_` `ROLE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '角色';
ALTER TABLE `bpm_approval_org` CHANGE `DEPARTMENT_ID_` `DEPARTMENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '部门';
ALTER TABLE `bpm_attention` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id';
ALTER TABLE `bpm_attention` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户id';
ALTER TABLE `bpm_attention` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户名称';
ALTER TABLE `bpm_bus_link` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_bus_link` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_bus_link` CHANGE `BUSINESSKEY_` `BUSINESSKEY_` bigint(20) null DEFAULT null COMMENT '业务键';
ALTER TABLE `bpm_bus_link` CHANGE `BUSINESSKEY_STR_` `BUSINESSKEY_STR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务键字符型';
ALTER TABLE `bpm_bus_link` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码';
ALTER TABLE `bpm_bus_link` CHANGE `FORM_IDENTIFY_` `FORM_IDENTIFY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '表单标识';
ALTER TABLE `bpm_bus_link` CHANGE `START_ID_` `START_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人';
ALTER TABLE `bpm_bus_link` CHANGE `STARTOR_` `STARTOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人';
ALTER TABLE `bpm_bus_link` CHANGE `START_GROUP_ID_` `START_GROUP_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起组织ID';
ALTER TABLE `bpm_bus_link` CHANGE `START_GROUP_` `START_GROUP_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起组织';
ALTER TABLE `bpm_bus_link` CHANGE `IS_MAIN_` `IS_MAIN_` smallint(6) null DEFAULT null COMMENT '主记录';
ALTER TABLE `bpm_bus_link` CHANGE `BO_DEF_CODE_` `BO_DEF_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bodefcode数据';
ALTER TABLE `bpm_bus_link` CHANGE `SAVE_MODE_` `SAVE_MODE_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '保存模式 (boObject,database)';
ALTER TABLE `bpm_call_log` CHANGE `SUBJECT_` `SUBJECT_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT ' 流程标题';
ALTER TABLE `bpm_call_log` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT ' 流程定义ID';
ALTER TABLE `bpm_call_log` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key';
ALTER TABLE `bpm_call_log` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_call_log` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '0' COMMENT '父流程实例ID';
ALTER TABLE `bpm_call_log` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_call_log` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key';
ALTER TABLE `bpm_call_log` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_call_log` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用人员ID';
ALTER TABLE `bpm_call_log` CHANGE `EVENT_TYPE_` `EVENT_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '事件类型';
ALTER TABLE `bpm_call_log` CHANGE `URL_` `URL_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用地址';
ALTER TABLE `bpm_call_log` CHANGE `DESC_` `DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接口描述';
ALTER TABLE `bpm_call_log` CHANGE `INVOKE_MODE_` `INVOKE_MODE_` int(11) null DEFAULT null COMMENT '接口调用模式:0:同步,1:异步';
ALTER TABLE `bpm_call_log` CHANGE `IS_SUCCESS_` `IS_SUCCESS_` smallint(6) null DEFAULT '0' COMMENT '是否调用成功';
ALTER TABLE `bpm_call_log` CHANGE `RESPONSE_` `RESPONSE_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用结果';
ALTER TABLE `bpm_call_log` CHANGE `PARAMS_` `PARAMS_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求参数';
ALTER TABLE `bpm_call_log` CHANGE `HEADER_` `HEADER_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '请求头';
ALTER TABLE `bpm_call_log` CHANGE `RETRY_COUNT_` `RETRY_COUNT_` int(11) null DEFAULT null COMMENT '重试次数';
ALTER TABLE `bpm_check_opinion` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_check_opinion` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID';
ALTER TABLE `bpm_check_opinion` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_check_opinion` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_check_opinion` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key';
ALTER TABLE `bpm_check_opinion` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_check_opinion` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌';
ALTER TABLE `bpm_check_opinion` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串';
ALTER TABLE `bpm_check_opinion` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串';
ALTER TABLE `bpm_check_opinion` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID';
ALTER TABLE `bpm_check_opinion` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名';
ALTER TABLE `bpm_check_opinion` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID';
ALTER TABLE `bpm_check_opinion` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径';
ALTER TABLE `bpm_check_opinion` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见';
ALTER TABLE `bpm_check_opinion` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '审批状态。start=发起流程;awaiting_check=待审批;agree=同意;against=反对;return=驳回;abandon=弃权;retrieve=追回';
ALTER TABLE `bpm_check_opinion` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID';
ALTER TABLE `bpm_check_opinion` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名';
ALTER TABLE `bpm_check_opinion` CHANGE `FILES_` `FILES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件';
ALTER TABLE `bpm_check_opinion` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预';
ALTER TABLE `bpm_check_opinion` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删,1已删除,0未删除';
ALTER TABLE `bpm_check_opinion` CHANGE `IS_READ_` `IS_READ_` int(11) NOT NULL DEFAULT '0' COMMENT '0:待阅,1:已阅';
ALTER TABLE `bpm_check_opinion` CHANGE `AGENT_LEADER_ID_` `AGENT_LEADER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被代理的领导人id';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5';
ALTER TABLE `bpm_check_opinion` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6';
ALTER TABLE `bpm_check_opinion` CHANGE `Z_FILES_` `Z_FILES_` varchar(1000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '正文附件';
ALTER TABLE `bpm_check_opinion` CHANGE `PARENT_TASK_ID_` `PARENT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务id';
ALTER TABLE `bpm_check_opinion` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务类型';
ALTER TABLE `bpm_check_opinion` CHANGE `SKIP_TYPE_` `SKIP_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '跳过类型 启动跳过 审批跳过 执行人为空跳过 相同执行人跳过';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '审批状态。start=发起流程;create=任务创建;agree=同意;against=反对;return=驳回;abandon=弃权;retrieve=追回';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `DUR_MS_` `DUR_MS_` bigint(20) null DEFAULT null COMMENT '持续时间(ms)';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `Z_FILES_` `Z_FILES_` varchar(1000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '正文附件';
ALTER TABLE `bpm_check_opinion_hi` CHANGE `PARENT_TASK_ID_` `PARENT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务id';
ALTER TABLE `bpm_commu_receiver` CHANGE `COMMU_ID_` `COMMU_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '通知ID';
ALTER TABLE `bpm_commu_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID';
ALTER TABLE `bpm_commu_receiver` CHANGE `RECEIVER` `RECEIVER` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人';
ALTER TABLE `bpm_commu_receiver` CHANGE `STATUS_` `STATUS_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '状态';
ALTER TABLE `bpm_commu_receiver` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '反馈意见';
ALTER TABLE `bpm_cpto_receiver` CHANGE `CPTO_ID_` `CPTO_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联ID';
ALTER TABLE `bpm_cpto_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID';
ALTER TABLE `bpm_cpto_receiver` CHANGE `RECEIVER_` `RECEIVER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人';
ALTER TABLE `bpm_cpto_receiver` CHANGE `IS_READ_` `IS_READ_` smallint(6) null DEFAULT null COMMENT '已读';
ALTER TABLE `bpm_custom_signdata` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务类型(并签,顺签,并批)';
ALTER TABLE `bpm_custom_signdata` CHANGE `STATUS_` `STATUS_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批中,完成,二次并签,被撤回,撤回审批中,撤回无待办';
ALTER TABLE `bpm_custom_signdata` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父id';
ALTER TABLE `bpm_custom_signdata` CHANGE `PATH_` `PATH_` varchar(3000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径';
ALTER TABLE `bpm_custom_signdata` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例id';
ALTER TABLE `bpm_custom_signdata` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id';
ALTER TABLE `bpm_custom_signdata` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id';
ALTER TABLE `bpm_def_act` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID';
ALTER TABLE `bpm_def_act` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权流程KEY';
ALTER TABLE `bpm_def_act` CHANGE `DEF_NAME_` `DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权流程名称';
ALTER TABLE `bpm_def_act` CHANGE `RIGHT_CONTENT_` `RIGHT_CONTENT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权内容';
ALTER TABLE `bpm_def_auth_type` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID';
ALTER TABLE `bpm_def_auth_type` CHANGE `AUTHORIZE_TYPE_` `AUTHORIZE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权类型定义(management)、启动(start)、实例(instance)和任务(task)';
ALTER TABLE `bpm_def_authorize` CHANGE `AUTHORIZE_DESC_` `AUTHORIZE_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权说明';
ALTER TABLE `bpm_def_authorize` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_def_authorize` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_def_data` CHANGE `BPMN_XML_` `BPMN_XML_` longtext character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义XML';
ALTER TABLE `bpm_def_user` CHANGE `AUTHORIZE_ID_` `AUTHORIZE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程授权主表ID';
ALTER TABLE `bpm_def_user` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象ID';
ALTER TABLE `bpm_def_user` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象名称';
ALTER TABLE `bpm_def_user` CHANGE `RIGHT_TYPE_` `RIGHT_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象类型(角色,用户,岗位等)';
ALTER TABLE `bpm_definition` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_definition` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称';
ALTER TABLE `bpm_definition` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义KEY';
ALTER TABLE `bpm_definition` CHANGE `DESC_` `DESC_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程描述';
ALTER TABLE `bpm_definition` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID';
ALTER TABLE `bpm_definition` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态。草稿、发布、禁用';
ALTER TABLE `bpm_definition` CHANGE `TEST_STATUS_` `TEST_STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '测试状态';
ALTER TABLE `bpm_definition` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN - 流程定义ID';
ALTER TABLE `bpm_definition` CHANGE `BPMN_DEPLOY_ID_` `BPMN_DEPLOY_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN - 流程发布ID';
ALTER TABLE `bpm_definition` CHANGE `VERSION_` `VERSION_` int(11) null DEFAULT null COMMENT '版本 - 当前版本号';
ALTER TABLE `bpm_definition` CHANGE `MAIN_DEF_ID_` `MAIN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '版本 - 主版本流程ID';
ALTER TABLE `bpm_definition` CHANGE `IS_MAIN_` `IS_MAIN_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '版本 - 是否主版本';
ALTER TABLE `bpm_definition` CHANGE `REASON_` `REASON_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '版本 - 变更理由';
ALTER TABLE `bpm_definition` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_definition` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID';
ALTER TABLE `bpm_definition` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_definition` CHANGE `DESIGNER_` `DESIGNER_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '设计器类型';
ALTER TABLE `bpm_definition` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机表单';
ALTER TABLE `bpm_definition` CHANGE `REV_` `REV_` int(11) NOT NULL DEFAULT '1' COMMENT '关联锁';
ALTER TABLE `bpm_definition` CHANGE `SHOW_URGENT_STATE_` `SHOW_URGENT_STATE_` int(11) null DEFAULT null COMMENT '是否显示紧急状态';
ALTER TABLE `bpm_definition` CHANGE `IS_READ_REVOKE` `IS_READ_REVOKE` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '传阅已阅是否允许撤回';
ALTER TABLE `bpm_definition` CHANGE `URGENT_MAIL_TEL` `URGENT_MAIL_TEL` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '人工催办内容邮件模板';
ALTER TABLE `bpm_definition` CHANGE `URGENT_SMS_TEL` `URGENT_SMS_TEL` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '人工催办内容短信模板';
ALTER TABLE `bpm_definition` CHANGE `SHOW_MODIFY_RECORD_` `SHOW_MODIFY_RECORD_` int(11) null DEFAULT null COMMENT '是否显示表单留痕';
ALTER TABLE `bpm_deputy` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '被代理人id';
ALTER TABLE `bpm_deputy` CHANGE `USER_NAME_` `USER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被代理人姓名';
ALTER TABLE `bpm_deputy` CHANGE `AGENT_ID_` `AGENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '代理人id';
ALTER TABLE `bpm_deputy` CHANGE `AGENT_NAME_` `AGENT_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '代理人姓名';
ALTER TABLE `bpm_deputy` CHANGE `IS_MAIL_` `IS_MAIL_` int(11) null DEFAULT '1' COMMENT '是否接收邮件(1:接收,0:不接收)';
ALTER TABLE `bpm_deputy` CHANGE `IS_USABLE_` `IS_USABLE_` int(11) null DEFAULT '1' COMMENT '是否可用(1:启用,0:禁用)';
ALTER TABLE `bpm_exe_stack` CHANGE `PRCO_DEF_ID_` `PRCO_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_exe_stack` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID';
ALTER TABLE `bpm_exe_stack` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名';
ALTER TABLE `bpm_exe_stack` CHANGE `IS_MULITI_TASK_` `IS_MULITI_TASK_` smallint(6) NOT NULL COMMENT '多实例任务
1=是
0=否';
ALTER TABLE `bpm_exe_stack` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父ID';
ALTER TABLE `bpm_exe_stack` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_exe_stack` CHANGE `NODE_PATH_` `NODE_PATH_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点路径
格式如:
0.1.2.
其中2则为本行记录的主键值';
ALTER TABLE `bpm_exe_stack` CHANGE `DEPTH_` `DEPTH_` smallint(6) null DEFAULT null COMMENT '节点层';
ALTER TABLE `bpm_exe_stack` CHANGE `TASK_TOKEN_` `TASK_TOKEN_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是针对分发任务时,携带的令牌,方便查找其父任务堆栈';
ALTER TABLE `bpm_exe_stack` CHANGE `NODE_TYPE_` `NODE_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点类型';
ALTER TABLE `bpm_exe_stack` CHANGE `TARGET_NODE_` `TARGET_NODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '驳回时返回节点';
ALTER TABLE `bpm_exe_stack` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预执行';
ALTER TABLE `bpm_exe_stack_executor` CHANGE `STACK_ID_` `STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '堆栈ID';
ALTER TABLE `bpm_exe_stack_executor` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_exe_stack_executor` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人';
ALTER TABLE `bpm_exe_stack_executor` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态(0,初始,1,完成,2,取消)';
ALTER TABLE `bpm_exe_stack_his` CHANGE `PRCO_DEF_ID_` `PRCO_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID';
ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名';
ALTER TABLE `bpm_exe_stack_his` CHANGE `IS_MULITI_TASK_` `IS_MULITI_TASK_` smallint(6) NOT NULL COMMENT '多实例任务
1=是
0=否';
ALTER TABLE `bpm_exe_stack_his` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父ID';
ALTER TABLE `bpm_exe_stack_his` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_PATH_` `NODE_PATH_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点路径
格式如:
0.1.2.
其中2则为本行记录的主键值';
ALTER TABLE `bpm_exe_stack_his` CHANGE `DEPTH_` `DEPTH_` smallint(6) null DEFAULT null COMMENT '节点层';
ALTER TABLE `bpm_exe_stack_his` CHANGE `TASK_TOKEN_` `TASK_TOKEN_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是针对分发任务时,携带的令牌,方便查找其父任务堆栈';
ALTER TABLE `bpm_exe_stack_his` CHANGE `NODE_TYPE_` `NODE_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点类型';
ALTER TABLE `bpm_exe_stack_his` CHANGE `TARGET_NODE_` `TARGET_NODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '驳回时返回节点';
ALTER TABLE `bpm_exe_stack_his` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预执行';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `RELATION_ID_` `RELATION_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关系ID';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_STACK_ID_` `FROM_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自堆栈ID';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_STACK_ID_` `TO_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达堆栈ID';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_NODE_ID_` `FROM_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自节点';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_NODE_ID_` `TO_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达节点';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `RELATION_STATE_` `RELATION_STATE_` smallint(6) NOT NULL DEFAULT '1' COMMENT '关系状态:1正常,0回收作废';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `FROM_NODE_TYPE_` `FROM_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自的节点类型';
ALTER TABLE `bpm_exe_stack_relation` CHANGE `TO_NODE_TYPE_` `TO_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达的节点类型';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `RELATION_ID_` `RELATION_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关系ID';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_STACK_ID_` `FROM_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自堆栈ID';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_STACK_ID_` `TO_STACK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达堆栈ID';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_NODE_ID_` `FROM_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自节点';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_NODE_ID_` `TO_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达节点';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `RELATION_STATE_` `RELATION_STATE_` smallint(6) NOT NULL DEFAULT '1' COMMENT '关系状态:1正常,0回收作废';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `FROM_NODE_TYPE_` `FROM_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '来自的节点类型';
ALTER TABLE `bpm_exe_stack_relation_his` CHANGE `TO_NODE_TYPE_` `TO_NODE_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '到达的节点类型';
ALTER TABLE `bpm_form_modify_record` CHANGE `REF_ID_` `REF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '外键(表单记录主键)';
ALTER TABLE `bpm_form_modify_record` CHANGE `DATA_` `DATA_` longtext character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单数据';
ALTER TABLE `bpm_hr_script` CHANGE `ALIAS_NAME_` `ALIAS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的别名';
ALTER TABLE `bpm_hr_script` CHANGE `ALIAS_DESC_` `ALIAS_DESC_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的描叙';
ALTER TABLE `bpm_hr_script` CHANGE `CLASS_NAME_` `CLASS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的路径';
ALTER TABLE `bpm_hr_script` CHANGE `CLASS_INS_NAME_` `CLASS_INS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的对象名';
ALTER TABLE `bpm_hr_script` CHANGE `METHOD_NAME_` `METHOD_NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法名';
ALTER TABLE `bpm_hr_script` CHANGE `METHOD_DESC_` `METHOD_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法的描叙';
ALTER TABLE `bpm_hr_script` CHANGE `RETURN_TYPE_` `RETURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法返回类型';
ALTER TABLE `bpm_hr_script` CHANGE `ARGUMENT_` `ARGUMENT_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法相关设置';
ALTER TABLE `bpm_hr_script` CHANGE `ENABLE_` `ENABLE_` smallint(6) NOT NULL COMMENT '是否有效,有效 1,无效 0';
ALTER TABLE `bpm_hr_script` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '脚本类型,条件脚本 1,别名脚本 2,人员脚本 3';
ALTER TABLE `bpm_inst_form` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义id';
ALTER TABLE `bpm_inst_form` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id';
ALTER TABLE `bpm_inst_form` CHANGE `FORM_VALUE_` `FORM_VALUE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单 inner 记录id frame 记录formValue';
ALTER TABLE `bpm_inst_form` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id';
ALTER TABLE `bpm_inst_form` CHANGE `FORM_TYPE_` `FORM_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单类型 pc mobile';
ALTER TABLE `bpm_inst_form` CHANGE `FORM_CATEGORY_` `FORM_CATEGORY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'url表单 frame 在线表单 inner';
ALTER TABLE `bpm_interpose_recored` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_interpose_recored` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_interpose_recored` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_interpose_recored` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_interpose_recored` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID';
ALTER TABLE `bpm_interpose_recored` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名';
ALTER TABLE `bpm_interpose_recored` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '干预动作';
ALTER TABLE `bpm_interpose_recored` CHANGE `DUR_MS_` `DUR_MS_` int(11) null DEFAULT null COMMENT '持续时间(ms)';
ALTER TABLE `bpm_meetingroom` CHANGE `NAME_` `NAME_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室名称';
ALTER TABLE `bpm_meetingroom` CHANGE `NEED_PENDING_` `NEED_PENDING_` smallint(6) null DEFAULT null COMMENT '是否需要审批';
ALTER TABLE `bpm_meetingroom` CHANGE `PENDING_USER_ID_` `PENDING_USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人ID';
ALTER TABLE `bpm_meetingroom` CHANGE `PENDING_USER_NAME_` `PENDING_USER_NAME_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人';
ALTER TABLE `bpm_meetingroom` CHANGE `SUPPORT_SERVICE_` `SUPPORT_SERVICE_` varchar(500) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '支持的服务';
ALTER TABLE `bpm_meetingroom` CHANGE `LOCATION_` `LOCATION_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室地址';
ALTER TABLE `bpm_meetingroom` CHANGE `CAPACITY_` `CAPACITY_` int(11) null DEFAULT null COMMENT '会议室容量';
ALTER TABLE `bpm_meetingroom` CHANGE `MEMO_` `MEMO_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议室备注';
ALTER TABLE `bpm_meetingroom_appointment` CHANGE `MEETING_ID_` `MEETING_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议id';
ALTER TABLE `bpm_meetingroom_appointment` CHANGE `MEETING_NAME_` `MEETING_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会议名称';
ALTER TABLE `bpm_meetingroom_appointment` CHANGE `HOSTESS_NAME_` `HOSTESS_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主持人姓名';
ALTER TABLE `bpm_meetingroom_appointment` CHANGE `APPOINTMENT_STATUS_` `APPOINTMENT_STATUS_` int(11) null DEFAULT null COMMENT '预约状态';
ALTER TABLE `bpm_message_type` CHANGE `CLASSIFICATION_CODE_` `CLASSIFICATION_CODE_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类名称';
ALTER TABLE `bpm_message_type` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_message_type` CHANGE `IS_PENDING_` `IS_PENDING_` smallint(6) null DEFAULT null COMMENT '是否需要审批';
ALTER TABLE `bpm_message_type` CHANGE `PENDING_USER_ID_` `PENDING_USER_ID_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人id';
ALTER TABLE `bpm_message_type` CHANGE `PENDING_USER_NAME_` `PENDING_USER_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人姓名';
ALTER TABLE `bpm_multi_script` CHANGE `ALIAS_NAME_` `ALIAS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的别名';
ALTER TABLE `bpm_multi_script` CHANGE `ALIAS_DESC_` `ALIAS_DESC_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本的描叙';
ALTER TABLE `bpm_multi_script` CHANGE `CLASS_NAME_` `CLASS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的路径';
ALTER TABLE `bpm_multi_script` CHANGE `CLASS_INS_NAME_` `CLASS_INS_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用类的对象名';
ALTER TABLE `bpm_multi_script` CHANGE `METHOD_NAME_` `METHOD_NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法名';
ALTER TABLE `bpm_multi_script` CHANGE `METHOD_DESC_` `METHOD_DESC_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用的方法的描叙';
ALTER TABLE `bpm_multi_script` CHANGE `RETURN_TYPE_` `RETURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法返回类型';
ALTER TABLE `bpm_multi_script` CHANGE `ARGUMENT_` `ARGUMENT_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '方法相关设置';
ALTER TABLE `bpm_multi_script` CHANGE `ENABLE_` `ENABLE_` smallint(6) NOT NULL COMMENT '是否有效,有效 1,无效 0';
ALTER TABLE `bpm_multi_script` CHANGE `TYPE_` `TYPE_` smallint(6) null DEFAULT null COMMENT '脚本类型,条件脚本 1,别名脚本 2,人员脚本 3';
ALTER TABLE `bpm_often_flow` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义KEY';
ALTER TABLE `bpm_often_flow` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '所属人id。-1为所有人都有权限';
ALTER TABLE `bpm_often_flow` CHANGE `ORDER_` `ORDER_` smallint(6) null DEFAULT null COMMENT '排序号';
ALTER TABLE `bpm_pro_bo` CHANGE `PROCESS_ID_` `PROCESS_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程ID';
ALTER TABLE `bpm_pro_bo` CHANGE `PROCESS_KEY_` `PROCESS_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程KEY';
ALTER TABLE `bpm_pro_bo` CHANGE `BO_CODE_` `BO_CODE_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务对象CODE';
ALTER TABLE `bpm_pro_bo` CHANGE `BO_NAME_` `BO_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务对象名称';
ALTER TABLE `bpm_pro_bo` CHANGE `CREATOR_ID_` `CREATOR_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_pro_cpto` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_pro_cpto` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'ACT实例ID';
ALTER TABLE `bpm_pro_cpto` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID';
ALTER TABLE `bpm_pro_cpto` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '意见';
ALTER TABLE `bpm_pro_cpto` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例标题';
ALTER TABLE `bpm_pro_cpto` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '抄送类型(copyto抄送,trans转发)';
ALTER TABLE `bpm_pro_cpto` CHANGE `STARTOR_ID_` `STARTOR_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程发起人';
ALTER TABLE `bpm_pro_cpto` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程分类';
ALTER TABLE `bpm_pro_cpto` CHANGE `STARTOR_` `STARTOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_pro_inst` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例标题';
ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_pro_inst` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程定义ID';
ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key';
ALTER TABLE `bpm_pro_inst` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称';
ALTER TABLE `bpm_pro_inst` CHANGE `BIZ_KEY_` `BIZ_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务主键';
ALTER TABLE `bpm_pro_inst` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码';
ALTER TABLE `bpm_pro_inst` CHANGE `FORM_KEY_` `FORM_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '绑定的表单主键';
ALTER TABLE `bpm_pro_inst` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例状态';
ALTER TABLE `bpm_pro_inst` CHANGE `DURATION_` `DURATION_` bigint(20) null DEFAULT null COMMENT '持续时间(ms)';
ALTER TABLE `bpm_pro_inst` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID';
ALTER TABLE `bpm_pro_inst` CHANGE `RESULT_TYPE_` `RESULT_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程结束后的最终审批结果,agree=同意;refuse=拒绝';
ALTER TABLE `bpm_pro_inst` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程实例ID';
ALTER TABLE `bpm_pro_inst` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_pro_inst` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID';
ALTER TABLE `bpm_pro_inst` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_pro_inst` CHANGE `IS_FORMMAL_` `IS_FORMMAL_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否正式数据';
ALTER TABLE `bpm_pro_inst` CHANGE `PARENT_INST_ID_` `PARENT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父实例Id';
ALTER TABLE `bpm_pro_inst` CHANGE `IS_FORBIDDEN_` `IS_FORBIDDEN_` smallint(6) null DEFAULT null COMMENT '禁止';
ALTER TABLE `bpm_pro_inst` CHANGE `DATA_MODE_` `DATA_MODE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务数据存储模式。
pk:主键
bo:业务对象';
ALTER TABLE `bpm_pro_inst` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_pro_inst` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机端';
ALTER TABLE `bpm_pro_inst` CHANGE `SUPER_NODE_ID_` `SUPER_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '子流程节点的ID';
ALTER TABLE `bpm_pro_inst` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删,1已删除,0未删除';
ALTER TABLE `bpm_pro_inst` CHANGE `URGENT_STATE_` `URGENT_STATE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '紧急状态';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例标题';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN流程定义ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义Key';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程名称';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `BIZ_KEY_` `BIZ_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联数据业务主键';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `SYS_CODE_` `SYS_CODE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '业务系统编码';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `FORM_KEY_` `FORM_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '绑定的表单主键';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '实例状态';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `DURATION_` `DURATION_` bigint(20) null DEFAULT null COMMENT '持续时间';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `RESULT_TYPE_` `RESULT_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程结束后的最终审批结果,agree=同意;refuse=拒绝';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'BPMN流程实例ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `IS_FORMMAL_` `IS_FORMMAL_` char(1) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '是否正式数据 0非正式,1正式';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `PARENT_INST_ID_` `PARENT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父实例Id';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `CREATOR_` `CREATOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机端';
ALTER TABLE `bpm_pro_inst_hi` CHANGE `SUPER_NODE_ID_` `SUPER_NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '子流程节点ID';
ALTER TABLE `bpm_pro_status` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_pro_status` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'ACT流程定义ID';
ALTER TABLE `bpm_pro_status` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID';
ALTER TABLE `bpm_pro_status` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_pro_status` CHANGE `STATUS_` `STATUS_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态';
ALTER TABLE `bpm_pro_status` CHANGE `LAST_USERID_` `LAST_USERID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '最后更新人';
ALTER TABLE `bpm_pro_status_hi` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_pro_status_hi` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT 'ACT流程定义ID';
ALTER TABLE `bpm_pro_status_hi` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '节点ID';
ALTER TABLE `bpm_pro_status_hi` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_pro_status_hi` CHANGE `STATUS_` `STATUS_` varchar(50) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '状态';
ALTER TABLE `bpm_pro_status_hi` CHANGE `LAST_USERID_` `LAST_USERID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '最后更新人';
ALTER TABLE `bpm_read_record` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_read_record` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID';
ALTER TABLE `bpm_read_record` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_read_record` CHANGE `TASK_ID_` `TASK_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_read_record` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key';
ALTER TABLE `bpm_read_record` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_read_record` CHANGE `READER_` `READER_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '阅读人ID';
ALTER TABLE `bpm_read_record` CHANGE `READER_NAME_` `READER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '阅读人名';
ALTER TABLE `bpm_read_record` CHANGE `ORG_ID_` `ORG_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织id';
ALTER TABLE `bpm_read_record` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织名称';
ALTER TABLE `bpm_reminder_history` CHANGE `INST_ID_` `INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_reminder_history` CHANGE `ISNT_NAME_` `ISNT_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例标题';
ALTER TABLE `bpm_reminder_history` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_reminder_history` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID';
ALTER TABLE `bpm_reminder_history` CHANGE `EXECUTE_DATE_` `EXECUTE_DATE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行时间';
ALTER TABLE `bpm_reminder_history` CHANGE `REMIND_TYPE_` `REMIND_TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行类型';
ALTER TABLE `bpm_reminder_history` CHANGE `USER_ID_` `USER_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '说明';
ALTER TABLE `bpm_report_act` CHANGE `REPORT_ID_` `REPORT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表主表ID';
ALTER TABLE `bpm_report_act` CHANGE `BPM_DEF_ID_` `BPM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_report_act` CHANGE `REPORT_NAME_` `REPORT_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表名称';
ALTER TABLE `bpm_report_act` CHANGE `DIMENSION_ID_` `DIMENSION_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织维度id';
ALTER TABLE `bpm_report_act` CHANGE `GRADE_` `GRADE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计级别';
ALTER TABLE `bpm_report_act` CHANGE `PARAMS_` `PARAMS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计参数';
ALTER TABLE `bpm_report_act` CHANGE `RIGHT_CONTENT_` `RIGHT_CONTENT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权内容(报表类型显示)';
ALTER TABLE `bpm_report_act` CHANGE `IS_DEFAULT_` `IS_DEFAULT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '默认显示视图(1:柱状图,2:饼图)';
ALTER TABLE `bpm_report_act` CHANGE `X_AXIS_` `X_AXIS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'x轴数据';
ALTER TABLE `bpm_report_act` CHANGE `Y_AXIS_` `Y_AXIS_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'y轴数据';
ALTER TABLE `bpm_report_act` CHANGE `PORP_` `PORP_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '统计参数';
ALTER TABLE `bpm_report_list` CHANGE `NAME_` `NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表主表名称';
ALTER TABLE `bpm_report_list` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_report_list` CHANGE `CREATE_NAME_` `CREATE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人名称';
ALTER TABLE `bpm_report_list` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者所属组织ID';
ALTER TABLE `bpm_report_list` CHANGE `CREATE_ORG_NAME_` `CREATE_ORG_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织名称';
ALTER TABLE `bpm_report_list` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '是否发布(1:是,2否)';
ALTER TABLE `bpm_report_user` CHANGE `REPORT_ID_` `REPORT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '报表授权主表ID';
ALTER TABLE `bpm_report_user` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象ID';
ALTER TABLE `bpm_report_user` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象名称';
ALTER TABLE `bpm_report_user` CHANGE `RIGHT_TYPE_` `RIGHT_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '授权对象类型(角色,用户,岗位等)';
ALTER TABLE `bpm_report_user` CHANGE `AUTH_ORG_` `AUTH_ORG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主组织ID';
ALTER TABLE `bpm_report_user` CHANGE `AUTH_ORG_NAME_` `AUTH_ORG_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '主组织名称';
ALTER TABLE `bpm_script` CHANGE `NAME_` `NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本名称';
ALTER TABLE `bpm_script` CHANGE `SCRIPT_` `SCRIPT_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本';
ALTER TABLE `bpm_script` CHANGE `CATEGORY_` `CATEGORY_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '脚本分类';
ALTER TABLE `bpm_script` CHANGE `MEMO_` `MEMO_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '备注';
ALTER TABLE `bpm_script` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_script` CHANGE `CREATE_ORG_ID_` `CREATE_ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人所属组织ID';
ALTER TABLE `bpm_script` CHANGE `UPDATE_BY_` `UPDATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更新人ID';
ALTER TABLE `bpm_secretary_manage` CHANGE `LEADER_ID_` `LEADER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '领导id';
ALTER TABLE `bpm_secretary_manage` CHANGE `LEADER_NAME_` `LEADER_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '领导姓名';
ALTER TABLE `bpm_secretary_manage` CHANGE `SECRETARY_ID_` `SECRETARY_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '秘书id';
ALTER TABLE `bpm_secretary_manage` CHANGE `SECRETARY_NAME_` `SECRETARY_NAME_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '秘书姓名';
ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_TYPE_` `SHARE_TYPE_` varchar(2) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享类型,1流程分类。2,流程定义';
ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_KEY_` `SHARE_KEY_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享的key';
ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_NAME_` `SHARE_NAME_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享对象的名称';
ALTER TABLE `bpm_secretary_manage` CHANGE `ENABLED_` `ENABLED_` varchar(2) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT '1' COMMENT '是否有效';
ALTER TABLE `bpm_secretary_manage` CHANGE `SHARE_RIGHT_` `SHARE_RIGHT_` varchar(10) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '共享权限类型';
ALTER TABLE `bpm_selector_def` CHANGE `NAME_` `NAME_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '名称';
ALTER TABLE `bpm_selector_def` CHANGE `ALIAS_` `ALIAS_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '别名';
ALTER TABLE `bpm_selector_def` CHANGE `GROUP_FIELD_` `GROUP_FIELD_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组合字段';
ALTER TABLE `bpm_selector_def` CHANGE `BUTTONS_` `BUTTONS_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '按钮定义';
ALTER TABLE `bpm_selector_def` CHANGE `IS_CUSTOM_` `IS_CUSTOM_` smallint(6) null DEFAULT null COMMENT '系统预定义';
ALTER TABLE `bpm_selector_def` CHANGE `FLAG_` `FLAG_` smallint(6) null DEFAULT '0' COMMENT '标记是否系统默认';
ALTER TABLE `bpm_selector_def` CHANGE `METHOD_` `METHOD_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '选择器对应的js方法名称';
ALTER TABLE `bpm_selector_def` CHANGE `CONF_KEY_` `CONF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '已选数据参数的传递key';
ALTER TABLE `bpm_task` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称';
ALTER TABLE `bpm_task` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题';
ALTER TABLE `bpm_task` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID';
ALTER TABLE `bpm_task` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联的任务ID';
ALTER TABLE `bpm_task` CHANGE `EXEC_ID_` `EXEC_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 节点执行ID';
ALTER TABLE `bpm_task` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID';
ALTER TABLE `bpm_task` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程定义ID';
ALTER TABLE `bpm_task` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程业务主键';
ALTER TABLE `bpm_task` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程名称';
ALTER TABLE `bpm_task` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID';
ALTER TABLE `bpm_task` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID';
ALTER TABLE `bpm_task` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务状态';
ALTER TABLE `bpm_task` CHANGE `PRIORITY_` `PRIORITY_` int(11) null DEFAULT null COMMENT '任务优先级';
ALTER TABLE `bpm_task` CHANGE `SUSPEND_STATE_` `SUSPEND_STATE_` smallint(6) null DEFAULT '0' COMMENT '是否挂起(0正常,1挂起)';
ALTER TABLE `bpm_task` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务ID';
ALTER TABLE `bpm_task` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bpmn实例ID';
ALTER TABLE `bpm_task` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN定义ID';
ALTER TABLE `bpm_task` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类ID';
ALTER TABLE `bpm_task` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机';
ALTER TABLE `bpm_task` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删,1已删除,0未删除';
ALTER TABLE `bpm_task` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1';
ALTER TABLE `bpm_task` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2';
ALTER TABLE `bpm_task` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3';
ALTER TABLE `bpm_task` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4';
ALTER TABLE `bpm_task` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5';
ALTER TABLE `bpm_task` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6';
ALTER TABLE `bpm_task_candidate` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_candidate` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '候选人类型';
ALTER TABLE `bpm_task_candidate` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID';
ALTER TABLE `bpm_task_candidate` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例';
ALTER TABLE `bpm_task_commu` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_task_commu` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_task_commu` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID';
ALTER TABLE `bpm_task_commu` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_commu` CHANGE `SENDER_ID_` `SENDER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发送沟通人ID';
ALTER TABLE `bpm_task_commu` CHANGE `SENDER` `SENDER` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发送沟通人';
ALTER TABLE `bpm_task_commu` CHANGE `OPINION_` `OPINION_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '意见';
ALTER TABLE `bpm_task_due_time` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父id';
ALTER TABLE `bpm_task_due_time` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id';
ALTER TABLE `bpm_task_due_time` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id';
ALTER TABLE `bpm_task_due_time` CHANGE `DATE_TYPE_` `DATE_TYPE_` varchar(32) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '时间类型 工作日 worktime 日历日 caltime';
ALTER TABLE `bpm_task_due_time` CHANGE `DUE_TIME_` `DUE_TIME_` int(11) null DEFAULT null COMMENT '任务时间 (分钟)';
ALTER TABLE `bpm_task_due_time` CHANGE `ADD_DUE_TIME_` `ADD_DUE_TIME_` int(11) null DEFAULT null COMMENT '延迟时间';
ALTER TABLE `bpm_task_due_time` CHANGE `REMAINING_TIME_` `REMAINING_TIME_` int(11) null DEFAULT null COMMENT '任务剩余时间(分钟)';
ALTER TABLE `bpm_task_due_time` CHANGE `STATUS_` `STATUS_` int(11) null DEFAULT null COMMENT '状态 是否延期申请过 1申请过 0没延迟过';
ALTER TABLE `bpm_task_due_time` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人ID';
ALTER TABLE `bpm_task_due_time` CHANGE `USER_NAME_` `USER_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批人姓名';
ALTER TABLE `bpm_task_due_time` CHANGE `REMARK_` `REMARK_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '说明';
ALTER TABLE `bpm_task_due_time` CHANGE `FILE_ID_` `FILE_ID_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件';
ALTER TABLE `bpm_task_due_time` CHANGE `IS_NEW_` `IS_NEW_` int(11) null DEFAULT null COMMENT '是否新的延迟 1 是 0 否 ';
ALTER TABLE `bpm_task_follow` CHANGE `ID` `ID` varchar(255) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '主键';
ALTER TABLE `bpm_task_follow` CHANGE `TASK_ID` `TASK_ID` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务id';
ALTER TABLE `bpm_task_follow` CHANGE `CREATOR_ID_` `CREATOR_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建者ID';
ALTER TABLE `bpm_task_follow` CHANGE `PRO_INST_` `PRO_INST_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例id';
ALTER TABLE `bpm_task_notice` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称';
ALTER TABLE `bpm_task_notice` CHANGE `SUBJECT_` `SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题';
ALTER TABLE `bpm_task_notice` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID';
ALTER TABLE `bpm_task_notice` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联的任务ID';
ALTER TABLE `bpm_task_notice` CHANGE `EXEC_ID_` `EXEC_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 节点执行ID';
ALTER TABLE `bpm_task_notice` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID';
ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程定义ID';
ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_KEY_` `PROC_DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程业务主键';
ALTER TABLE `bpm_task_notice` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 流程名称';
ALTER TABLE `bpm_task_notice` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID';
ALTER TABLE `bpm_task_notice` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID';
ALTER TABLE `bpm_task_notice` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务状态';
ALTER TABLE `bpm_task_notice` CHANGE `PRIORITY_` `PRIORITY_` int(11) null DEFAULT null COMMENT '任务优先级';
ALTER TABLE `bpm_task_notice` CHANGE `SUSPEND_STATE_` `SUSPEND_STATE_` smallint(6) null DEFAULT '0' COMMENT '是否挂起(0正常,1挂起)';
ALTER TABLE `bpm_task_notice` CHANGE `PARENT_ID_` `PARENT_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父任务ID';
ALTER TABLE `bpm_task_notice` CHANGE `BPMN_INST_ID_` `BPMN_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'bpmn实例ID';
ALTER TABLE `bpm_task_notice` CHANGE `BPMN_DEF_ID_` `BPMN_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'BPMN定义ID';
ALTER TABLE `bpm_task_notice` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '分类ID';
ALTER TABLE `bpm_task_notice` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '支持手机';
ALTER TABLE `bpm_task_notice` CHANGE `IS_DELE_` `IS_DELE_` int(11) NOT NULL DEFAULT '0' COMMENT '是否已删,1已删除,0未删除';
ALTER TABLE `bpm_task_notice` CHANGE `IS_READ_` `IS_READ_` int(11) NOT NULL DEFAULT '0' COMMENT '传阅的任务是否已阅 0:待阅,1:已阅';
ALTER TABLE `bpm_task_notice` CHANGE `IS_REVOKE_` `IS_REVOKE_` int(11) NOT NULL DEFAULT '0' COMMENT '传阅的任务是否撤回 0:否,1:是';
ALTER TABLE `bpm_task_notice` CHANGE `PROP1_` `PROP1_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性1';
ALTER TABLE `bpm_task_notice` CHANGE `PROP2_` `PROP2_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性2';
ALTER TABLE `bpm_task_notice` CHANGE `PROP3_` `PROP3_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性3';
ALTER TABLE `bpm_task_notice` CHANGE `PROP4_` `PROP4_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性4';
ALTER TABLE `bpm_task_notice` CHANGE `PROP5_` `PROP5_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性5';
ALTER TABLE `bpm_task_notice` CHANGE `PROP6_` `PROP6_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '扩展属性6';
ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_DEF_ID_` `PROC_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程定义ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `SUP_INST_ID_` `SUP_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '父流程实例ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '流程实例ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_KEY_` `TASK_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务定义Key';
ALTER TABLE `bpm_task_notice_done` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_task_notice_done` CHANGE `TOKEN_` `TOKEN_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务令牌';
ALTER TABLE `bpm_task_notice_done` CHANGE `QUALFIEDS_` `QUALFIEDS_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户ID串';
ALTER TABLE `bpm_task_notice_done` CHANGE `QUALFIED_NAMES_` `QUALFIED_NAMES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有审批资格用户名称串';
ALTER TABLE `bpm_task_notice_done` CHANGE `AUDITOR_` `AUDITOR_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `AUDITOR_NAME_` `AUDITOR_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人名';
ALTER TABLE `bpm_task_notice_done` CHANGE `ORG_ID_` `ORG_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `ORG_PATH_` `ORG_PATH_` varchar(600) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '组织全路径';
ALTER TABLE `bpm_task_notice_done` CHANGE `OPINION_` `OPINION_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批意见';
ALTER TABLE `bpm_task_notice_done` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '知会任务已办状态';
ALTER TABLE `bpm_task_notice_done` CHANGE `FORM_DEF_ID_` `FORM_DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单定义ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `FORM_NAME_` `FORM_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单名';
ALTER TABLE `bpm_task_notice_done` CHANGE `DUR_MS_` `DUR_MS_` int(11) null DEFAULT null COMMENT '持续时间(ms)';
ALTER TABLE `bpm_task_notice_done` CHANGE `FILES_` `FILES_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '附件';
ALTER TABLE `bpm_task_notice_done` CHANGE `INTERPOSE_` `INTERPOSE_` smallint(6) null DEFAULT null COMMENT '是否干预';
ALTER TABLE `bpm_task_notice_done` CHANGE `SUBJECT_` `SUBJECT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程标题';
ALTER TABLE `bpm_task_notice_done` CHANGE `PROC_DEF_NAME_` `PROC_DEF_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_task_notice_done` CHANGE `BPM_TASK_NOTICE_ID_` `BPM_TASK_NOTICE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '知会待办主键ID';
ALTER TABLE `bpm_task_notice_done` CHANGE `SUPPORT_MOBILE_` `SUPPORT_MOBILE_` int(11) null DEFAULT '0' COMMENT '是否支持手机0:不支持,1:支持';
ALTER TABLE `bpm_task_read` CHANGE `READ_ID_` `READ_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '主键';
ALTER TABLE `bpm_task_read` CHANGE `PROC_DEF_ID` `PROC_DEF_ID` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_task_read` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_task_read` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_read` CHANGE `NODE_ID_` `NODE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID';
ALTER TABLE `bpm_task_read` CHANGE `USER_ID_` `USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户ID';
ALTER TABLE `bpm_task_read` CHANGE `USER_NAME_` `USER_NAME_` varchar(32) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户名';
ALTER TABLE `bpm_task_reminder` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办任务ID';
ALTER TABLE `bpm_task_reminder` CHANGE `NAME_` `NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办名称';
ALTER TABLE `bpm_task_reminder` CHANGE `DUE_ACTION_` `DUE_ACTION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '到期执行动作';
ALTER TABLE `bpm_task_reminder` CHANGE `DUE_SCRIPT_` `DUE_SCRIPT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '调用指定方法';
ALTER TABLE `bpm_task_reminder` CHANGE `IS_SEND_MSG_` `IS_SEND_MSG_` int(11) null DEFAULT null COMMENT '期间是否发送催办';
ALTER TABLE `bpm_task_reminder` CHANGE `MSG_INTERVAL_` `MSG_INTERVAL_` int(11) null DEFAULT null COMMENT '发送消息间隔';
ALTER TABLE `bpm_task_reminder` CHANGE `MSG_COUNT_` `MSG_COUNT_` int(11) null DEFAULT null COMMENT '发送次数';
ALTER TABLE `bpm_task_reminder` CHANGE `MSG_TYPE_` `MSG_TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '消息类型 inner,msg,email 等';
ALTER TABLE `bpm_task_reminder` CHANGE `HTML_MSG_` `HTML_MSG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '富文本';
ALTER TABLE `bpm_task_reminder` CHANGE `PLAIN_MSG_` `PLAIN_MSG_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '纯文本消息';
ALTER TABLE `bpm_task_reminder` CHANGE `WARNINGSET_` `WARNINGSET_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '预警配置(预警名称,triggerDate,change2level)';
ALTER TABLE `bpm_task_sign_line` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例';
ALTER TABLE `bpm_task_sign_line` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_sign_line` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径';
ALTER TABLE `bpm_task_sign_line` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(2048) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人';
ALTER TABLE `bpm_task_sign_line` CHANGE `ACTION_` `ACTION_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '并行签署后的动作 submit提交 back返回 ';
ALTER TABLE `bpm_task_sign_line` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点id';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点key';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `NEXT_TASK_ID_` `NEXT_TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '下一任务ID';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `PATH_` `PATH_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '路径';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `SEQ_` `SEQ_` smallint(6) null DEFAULT null COMMENT '顺序';
ALTER TABLE `bpm_task_sign_sequence` CHANGE `EXECUTOR_` `EXECUTOR_` varchar(2048) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '执行人';
ALTER TABLE `bpm_task_signdata` CHANGE `DEF_ID_` `DEF_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_task_signdata` CHANGE `INST_ID_` `INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_task_signdata` CHANGE `EXECUTE_ID_` `EXECUTE_ID_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'act运行实例Id';
ALTER TABLE `bpm_task_signdata` CHANGE `ACT_INST_ID_` `ACT_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT 'ACT流程实例ID';
ALTER TABLE `bpm_task_signdata` CHANGE `NODE_ID_` `NODE_ID_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点ID';
ALTER TABLE `bpm_task_signdata` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程任务ID';
ALTER TABLE `bpm_task_signdata` CHANGE `QUALIFIED_ID_` `QUALIFIED_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有资格审批的成员ID';
ALTER TABLE `bpm_task_signdata` CHANGE `QUALIFIED_NAME_` `QUALIFIED_NAME_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '有资格审批的成员名称';
ALTER TABLE `bpm_task_signdata` CHANGE `VOTE_RESULT_` `VOTE_RESULT_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票结果(no 未投票 通过 agree,abandon 弃权,oppose 反对)';
ALTER TABLE `bpm_task_signdata` CHANGE `VOTE_ID_` `VOTE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票人';
ALTER TABLE `bpm_task_signdata` CHANGE `VOTER_` `VOTER_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票人';
ALTER TABLE `bpm_task_signdata` CHANGE `INDEX_` `INDEX_` int(11) null DEFAULT null COMMENT '投票次序';
ALTER TABLE `bpm_task_signdata` CHANGE `IS_ACTIVE_` `IS_ACTIVE_` int(11) null DEFAULT null COMMENT '是否活动';
ALTER TABLE `bpm_task_signdata` CHANGE `TYPE_` `TYPE_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义ID';
ALTER TABLE `bpm_task_trans` CHANGE `INSTANCE_ID_` `INSTANCE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例';
ALTER TABLE `bpm_task_trans` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID
流转任务ID';
ALTER TABLE `bpm_task_trans` CHANGE `ACTION_` `ACTION_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '完成后的操作';
ALTER TABLE `bpm_task_trans` CHANGE `CREATOR_` `CREATOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_task_trans` CHANGE `DECIDE_TYPE_` `DECIDE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '决策类型
agree
oppose';
ALTER TABLE `bpm_task_trans` CHANGE `VOTE_TYPE_` `VOTE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票类型
amount
percent';
ALTER TABLE `bpm_task_trans` CHANGE `VOTE_AMOUNT_` `VOTE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '票数';
ALTER TABLE `bpm_task_trans` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会签类型
parallel,seq';
ALTER TABLE `bpm_task_trans` CHANGE `TOTAL_AMOUNT_` `TOTAL_AMOUNT_` smallint(6) null DEFAULT null COMMENT '总票数';
ALTER TABLE `bpm_task_trans` CHANGE `AGREE_AMOUNT_` `AGREE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '通过票数';
ALTER TABLE `bpm_task_trans` CHANGE `OPPOSE_AMOUNT_` `OPPOSE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '反对票数';
ALTER TABLE `bpm_task_trans` CHANGE `SEQ_` `SEQ_` smallint(6) null DEFAULT null COMMENT '投票次序';
ALTER TABLE `bpm_task_trans` CHANGE `USER_JSON_` `USER_JSON_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '用户数据';
ALTER TABLE `bpm_task_trans` CHANGE `ALLOW_FORM_EDIT_` `ALLOW_FORM_EDIT_` smallint(6) null DEFAULT null COMMENT '表单允许编辑';
ALTER TABLE `bpm_task_trans_record` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例';
ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID
流转任务ID';
ALTER TABLE `bpm_task_trans_record` CHANGE `ACTION_` `ACTION_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '完成后的操作';
ALTER TABLE `bpm_task_trans_record` CHANGE `CREATOR_` `CREATOR_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人';
ALTER TABLE `bpm_task_trans_record` CHANGE `DECIDE_TYPE` `DECIDE_TYPE` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '决策类型
同意 agree
反对 oppose';
ALTER TABLE `bpm_task_trans_record` CHANGE `VOTE_TYPE_` `VOTE_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '投票类型';
ALTER TABLE `bpm_task_trans_record` CHANGE `VOTE_AMOUNT_` `VOTE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '票数';
ALTER TABLE `bpm_task_trans_record` CHANGE `SIGN_TYPE_` `SIGN_TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '会签类型';
ALTER TABLE `bpm_task_trans_record` CHANGE `TOTAL_AMOUNT_` `TOTAL_AMOUNT_` smallint(6) null DEFAULT null COMMENT '总票数';
ALTER TABLE `bpm_task_trans_record` CHANGE `AGREE_AMOUNT_` `AGREE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '通过票数';
ALTER TABLE `bpm_task_trans_record` CHANGE `OPPOSE_AMOUNT_` `OPPOSE_AMOUNT_` smallint(6) null DEFAULT null COMMENT '反对票数';
ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_USERS_` `TRANS_USERS_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转人员';
ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务名称';
ALTER TABLE `bpm_task_trans_record` CHANGE `TASK_SUBJECT_` `TASK_SUBJECT_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务标题';
ALTER TABLE `bpm_task_trans_record` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态:0流转中 1流转结束 2已撤销';
ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_USER_IDS_` `TRANS_USER_IDS_` varchar(300) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转人员ids';
ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_OPINION_` `TRANS_OPINION_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转意见(原因)';
ALTER TABLE `bpm_task_trans_record` CHANGE `DEF_NAME_` `DEF_NAME_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程名称';
ALTER TABLE `bpm_task_trans_record` CHANGE `TRANS_OWNER_` `TRANS_OWNER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务所属人ID';
ALTER TABLE `bpm_task_turn` CHANGE `TASK_ID_` `TASK_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务ID';
ALTER TABLE `bpm_task_turn` CHANGE `TASK_NAME_` `TASK_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '任务名称';
ALTER TABLE `bpm_task_turn` CHANGE `TASK_SUBJECT_` `TASK_SUBJECT_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '待办事项标题';
ALTER TABLE `bpm_task_turn` CHANGE `NODE_ID_` `NODE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '关联 - 任务节点ID';
ALTER TABLE `bpm_task_turn` CHANGE `PROC_INST_ID_` `PROC_INST_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' NOT NULL COMMENT '关联 - 流程实例ID';
ALTER TABLE `bpm_task_turn` CHANGE `OWNER_ID_` `OWNER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人ID';
ALTER TABLE `bpm_task_turn` CHANGE `OWNER_NAME_` `OWNER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务所属人姓名';
ALTER TABLE `bpm_task_turn` CHANGE `ASSIGNEE_ID_` `ASSIGNEE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人ID';
ALTER TABLE `bpm_task_turn` CHANGE `ASSIGNEE_NAME_` `ASSIGNEE_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务执行人姓名';
ALTER TABLE `bpm_task_turn` CHANGE `STATUS_` `STATUS_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '状态。running=正在运行;finish=完成;cancel=取消';
ALTER TABLE `bpm_task_turn` CHANGE `TURN_TYPE_` `TURN_TYPE_` varchar(40) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '更改类型。agent=代理;shift=转办;copy_to=抄送';
ALTER TABLE `bpm_task_turn` CHANGE `TYPE_ID_` `TYPE_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '所属分类ID';
ALTER TABLE `bpm_task_turnassign` CHANGE `TASK_TURN_ID_` `TASK_TURN_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '转交ID和task_turn表主键关联';
ALTER TABLE `bpm_task_turnassign` CHANGE `FROM_USER_ID_` `FROM_USER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务转交人ID';
ALTER TABLE `bpm_task_turnassign` CHANGE `FROM_USER_` `FROM_USER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务转交人';
ALTER TABLE `bpm_task_turnassign` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人ID';
ALTER TABLE `bpm_task_turnassign` CHANGE `RECEIVER` `RECEIVER` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '接收人';
ALTER TABLE `bpm_task_turnassign` CHANGE `COMMENT_` `COMMENT_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '备注';
ALTER TABLE `bpm_task_urgent` CHANGE `TASK_ID_` `TASK_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '任务ID';
ALTER TABLE `bpm_task_urgent` CHANGE `NODE_NAME_` `NODE_NAME_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '节点名称';
ALTER TABLE `bpm_task_urgent` CHANGE `INST_ID_` `INST_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';
ALTER TABLE `bpm_task_urgent` CHANGE `SUBJECT_` `SUBJECT_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程标题';
ALTER TABLE `bpm_task_urgent` CHANGE `CONTENT_` `CONTENT_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办内容';
ALTER TABLE `bpm_task_urgent` CHANGE `PROMOTER_ID_` `PROMOTER_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办人ID';
ALTER TABLE `bpm_task_urgent` CHANGE `PROMOTER_` `PROMOTER_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办人';
ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_ID_` `APPOINTEE_ID_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被催办人ID';
ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_` `APPOINTEE_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被催办人';
ALTER TABLE `bpm_task_urgent` CHANGE `TYPE_` `TYPE_` varchar(255) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办类型';
ALTER TABLE `bpm_task_urgent` CHANGE `APPOINTEE_SECRETARY_CONF_` `APPOINTEE_SECRETARY_CONF_` varchar(1024) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '催办的领导和秘书的id关系map,方便秘书回复时确定代哪个领导审批的';
ALTER TABLE `bpm_test_case` CHANGE `NAME_` `NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '测试用例名称';
ALTER TABLE `bpm_test_case` CHANGE `BO_FORM_DATA_` `BO_FORM_DATA_` text character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '表单数据';
ALTER TABLE `bpm_test_case` CHANGE `FLOW_VARS_` `FLOW_VARS_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程变量';
ALTER TABLE `bpm_test_case` CHANGE `ACTION_TYPE_` `ACTION_TYPE_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审批动作, 默认动作时 agree';
ALTER TABLE `bpm_test_case` CHANGE `STARTOR_` `STARTOR_` varchar(4000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人json';
ALTER TABLE `bpm_test_case` CHANGE `BPM_DEBUGGER_` `BPM_DEBUGGER_` varchar(512) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '断点测试设置';
ALTER TABLE `bpm_test_case` CHANGE `DEF_KEY_` `DEF_KEY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程定义key';
ALTER TABLE `bpm_test_case` CHANGE `STARTOR_ACCOUNT_` `STARTOR_ACCOUNT_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人账号';
ALTER TABLE `bpm_test_case` CHANGE `STARTOR_FULL_NAME_` `STARTOR_FULL_NAME_` varchar(128) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '发起人姓名';
ALTER TABLE `bpm_trans_receiver` CHANGE `TRANS_RECORDID_` `TRANS_RECORDID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转任务记录ID';
ALTER TABLE `bpm_trans_receiver` CHANGE `RECEIVER_` `RECEIVER_` varchar(100) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转接受人员';
ALTER TABLE `bpm_trans_receiver` CHANGE `RECEIVER_ID_` `RECEIVER_ID_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流转接收人id';
ALTER TABLE `bpm_trans_receiver` CHANGE `STATUS_` `STATUS_` smallint(6) null DEFAULT null COMMENT '状态:0尚未处理1已处理';
ALTER TABLE `bpm_trans_receiver` CHANGE `OPINION_` `OPINION_` varchar(200) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '审核意见';
ALTER TABLE `bpm_trans_receiver` CHANGE `CHECK_TYPE_` `CHECK_TYPE_` smallint(6) null DEFAULT null COMMENT '审核状态';
ALTER TABLE `bpm_trans_record` CHANGE `TYPE_` `TYPE_` varchar(20) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交类型';
ALTER TABLE `bpm_trans_record` CHANGE `TRANSFER_` `TRANSFER_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交人ID';
ALTER TABLE `bpm_trans_record` CHANGE `TRANSFER_NAME_` `TRANSFER_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交人姓名';
ALTER TABLE `bpm_trans_record` CHANGE `TRANSFERED_NAME_` `TRANSFERED_NAME_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '被移交人姓名';
ALTER TABLE `bpm_trans_record` CHANGE `REASON_` `REASON_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交原因';
ALTER TABLE `bpm_trans_record` CHANGE `CREATE_BY_` `CREATE_BY_` varchar(64) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '创建人ID';
ALTER TABLE `bpm_trans_record` CHANGE `RESULT_` `RESULT_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '移交结果';
ALTER TABLE `bpm_trans_record` CHANGE `VAR_` `VAR_` int(11) null DEFAULT null COMMENT '移交方式';
ALTER TABLE `bpm_trans_record` CHANGE `PROC_INST_IDS_` `PROC_INST_IDS_` varchar(2000) character set utf8 COLLATE 'utf8_general_ci' null DEFAULT null COMMENT '流程实例ID';