CREATE TABLE bpm_process_instance_copy
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
start_user_id
bigint(20) NOT NULL DEFAULT '0' COMMENT '发起流程的用户编号',
process_instance_id
varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '流程实例的id',
process_instance_name
varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '流程实例的名字',
task_id
varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '发起抄送的任务编号',
user_id
bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id,被抄送人',
reason
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审批建议',
creator
varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
create_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
updater
varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
update_time
datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
deleted
bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
tenant_id
bigint(20) NOT NULL DEFAULT '0' COMMENT '租户编号',
category
varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '流程实例的分类',
task_name
varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '任务的名字',
PRIMARY KEY (id
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='流程实例抄送'
将category这个字段缩短了